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.) -jeff frabutt (jfrabutt@pts.mot.com) >You will probally have to export DBDATE also in your "C" program/shell. >But a DBA Q here: why are you doing this at a 4gl level? > > ------------------------------------------------------------------------- > Cheryl Kendricks> Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov >------------------------------------------------------------------------ > >On Wed, 29 May 1996, phr (Peter Harris) wrote: > >} >} Berton, >} >} Try writing a c function that calls putenv("DBDATE=whatever") and then >} link that >} into you 4gl. Bear in mind though that when you run this program the new >} DBDATE >} will not be available to the calling shell. >} >} All the best, Pete Harris >} >} ---------- >} From: Berton Sierens >} Sent: Wednesday, 29 May 1996 13:29 >} To: informix-list@rmy.emory.edu >} Subject: Changing value of a Informix variable >} >} How do you change the value of let4s say DBDATE from within a 4GL?