Re: Changing value of a Informix variabl

> > More than one person has questioned my intentions on this one. I have found the need > to dynamically change DBDATE because I have a single 4GL program that is unloading data > into ascii files to be loaded in systems around the world. Each system may have a > different DBDATE so I must unload my data to match theirs. I have found it easiest > to use the 'unload' command since it provides pipe delimited files. (I also realize that > we could agree on a single DBDATE to be used worldwide but it is not as easy as one > might think.) Consider: 1) shipping a load script with your files which has the DBDATE specifically set within it or begs the question - a dbload.com file somes readily to mind. 2) Don't export the data at all. Use an Istar connection to write data directly from your database into theirs and not worry about loading/unloading - and incidentally DBDATE. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@hpbs3645.boi.hp.com Back in Boise _____________________________________________________________________________ If anything can go wrong, fix it. To hell with Murphy. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________