Re: moving databases and SPL

Sory, I haven't any experience with IDS 9.14 and I can't help solving your problem. Are you sure the "database.sql" file in dbexport doesn't contain the stored procedures ? If it doesn't you could try to use a 7.23 version of dbexport to export the database (I'm not sure about results). Best Regards, Octav On Tue, Feb 16, 1999 at 10:32:29AM -0500, Maria Wilson wrote: > Hi - The spl is on IDS 9.14.UC2 on a Solaris 2.6 machine. We also have some > version 7.23 machines but not much spl coding to have any real experience > with it. Thanks for your help! Maria > > Octav Chiriac wrote: > > > It's a strange thing. Usually dbexport saves the stored procedures > > definition in the .sql export file. There were bugs in some versions > > but usually it works fine. What version of Informix Server are you > > using ? > > > > Best Regards, > > Octav > > > > On Tue, Feb 16, 1999 at 09:58:36AM -0500, Maria Wilson wrote: > > > Looking for some information on how to move databases along with stored > > > procedures from machine to machine. (Identical setup on these two > > > machines - just going to a production environment from development.) I > > > typically use dbexport to do this with - but oops- no stored > > > procedures. Anybody have any experience doing this? > > > > > > -- > > > ---------------------------------------------------------------- > > > Maria L. Wilson 757.766.8265 757.766.2571(fax) > > > Computer Sciences Corporation > > > NASA Langley Research Center m.l.wilson@larc.nasa.gov > > > Hampton, VA 23666 http://www.larc.nasa.gov > > > ---------------------------------------------------------------- > > > > > > > > > > -- > > Octav Chiriac Phone: (373) 2 21 20 96 > > NetInfo S.R.L. Fax: (373) 2 21 36 59 > > Chisinau (373) 2 24 00 83 > > Moldova, Republic of mailto:com@netinfo-moldova.com > > > > -- > ---------------------------------------------------------------- > Maria L. Wilson 757.766.8265 757.766.2571(fax) > Computer Sciences Corporation > NASA Langley Research Center m.l.wilson@larc.nasa.gov > Hampton, VA 23666 http://www.larc.nasa.gov > ---------------------------------------------------------------- > > -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com