DBTIME environment variable in dbaccess

Greetings all ! [IDS 7.30UC1 on Solaris] I'm trying to set the environment variable "DBTIME" so that I can change the date format for datetime datatypes. When I set the environment variable, it has no effect. But here's the rub: I'm setting it in a DBACCESS session which I run on the same machine as the db server, since I'm trying to load some data using dbaccess. Is DBACCESS sensitive to the DBTIME environment variable, or is it only the server itself? If it's just the server, that won't work for us, since we want to change the datetime format temporarily for just one data loading session. Is there a workaround for this? Many thanks. Rich -- Richard C. Auslander Database Manager AirFlash, Inc. 1733 Woodside Rd., Suite #110 Redwood City, CA 94061 (650) 556-7928 www.airflash.com

I'd recommend export the DBTIME variable to your environment prior to invoking dbaccess. It will be "in effect" until that person logs out of Unix. To get rid of it without logging out, you need to "unset" it using the correct syntax for whatever Unix shell you are using. In article <385ECD84.C60185F7@airflash.com>, Richard Auslander <rich@airflash.com> wrote: > This is a multi-part message in MIME format. > --------------BBA9B6FD2A7DCBBB0F3FC2D8 > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > Greetings all ! > > [IDS 7.30UC1 on Solaris] > > I'm trying to set the environment variable "DBTIME" so that I can change > the date format for datetime datatypes. When I set the environment > variable, it has no effect. But here's the rub: I'm setting it in a > DBACCESS session which I run on the same machine as the db server, since > I'm trying to load some data using dbaccess. Is DBACCESS sensitive to > the DBTIME environment variable, or is it only the server itself? If > it's just the server, that won't work for us, since we want to change > the datetime format temporarily for just one data loading session. Is > there a workaround for this? Many thanks. > > Rich > -- > Richard C. Auslander > Database Manager > > AirFlash, Inc. > 1733 Woodside Rd., Suite #110 > Redwood City, CA 94061 > (650) 556-7928 > > www.airflash.com > > --------------BBA9B6FD2A7DCBBB0F3FC2D8 > Content-Type: text/x-vcard; charset=us-ascii; > name="rich.vcf" > Content-Transfer-Encoding: 7bit > Content-Description: Card for Richard Auslander > Content-Disposition: attachment; > filename="rich.vcf" > > begin:vcard > n:Auslander;Richard > tel;fax:650-556-7930 > tel;work:650-556-7928 > x-mozilla-html:FALSE > url:http://www.airflash.com > org:AirFlash, Inc. > adr:;;1733 Woodside Road, Suite 110;Redwood City;CA;94061;USA > version:2.1 > email;internet:rich@airflash.com > title:Manager of Database Services > fn:Richard Auslander > end:vcard > > --------------BBA9B6FD2A7DCBBB0F3FC2D8-- > > Sent via Deja.com http://www.deja.com/ Before you buy.

My shell doesn't use or need "export". I use "setenv". I don't believe this is the issue. I'm really asking whether DBTIME is supported in dbaccess. Thanks for your effort though, George. Rich georhill@my-deja.com wrote: > I'd recommend export the DBTIME variable to your environment prior to > invoking dbaccess. It will be "in effect" until that person logs out of > Unix. To get rid of it without logging out, you need to "unset" it using > the correct syntax for whatever Unix shell you are using. > > In article <385ECD84.C60185F7@airflash.com>, > Richard Auslander <rich@airflash.com> wrote: > > This is a multi-part message in MIME format. > > --------------BBA9B6FD2A7DCBBB0F3FC2D8 > > Content-Type: text/plain; charset=us-ascii > > Content-Transfer-Encoding: 7bit > > > > Greetings all ! > > > > [IDS 7.30UC1 on Solaris] > > > > I'm trying to set the environment variable "DBTIME" so that I can > change > > the date format for datetime datatypes. When I set the environment > > variable, it has no effect. But here's the rub: I'm setting it in a > > DBACCESS session which I run on the same machine as the db server, > since > > I'm trying to load some data using dbaccess. Is DBACCESS sensitive to > > the DBTIME environment variable, or is it only the server itself? If > > it's just the server, that won't work for us, since we want to change > > the datetime format temporarily for just one data loading session. Is > > there a workaround for this? Many thanks. > > > > Rich > > -- > > Richard C. Auslander > > Database Manager > > > > AirFlash, Inc. > > 1733 Woodside Rd., Suite #110 > > Redwood City, CA 94061 > > (650) 556-7928 > > > > www.airflash.com > > > > --------------BBA9B6FD2A7DCBBB0F3FC2D8 > > Content-Type: text/x-vcard; charset=us-ascii; > > name="rich.vcf" > > Content-Transfer-Encoding: 7bit > > Content-Description: Card for Richard Auslander > > Content-Disposition: attachment; > > filename="rich.vcf" > > > > begin:vcard > > n:Auslander;Richard > > tel;fax:650-556-7930 > > tel;work:650-556-7928 > > x-mozilla-html:FALSE > > url:http://www.airflash.com > > org:AirFlash, Inc. > > adr:;;1733 Woodside Road, Suite 110;Redwood City;CA;94061;USA > > version:2.1 > > email;internet:rich@airflash.com > > title:Manager of Database Services > > fn:Richard Auslander > > end:vcard > > > > --------------BBA9B6FD2A7DCBBB0F3FC2D8-- > > > > > > Sent via Deja.com http://www.deja.com/ > Before you buy. -- Richard C. Auslander Database Manager AirFlash, Inc. 1733 Woodside Rd., Suite #110 Redwood City, CA 94061 (650) 556-7928 www.airflash.com

DB-Access doesn't really support DBTIME. In fact, DBTIME doesn't really support anything, either. How do you set DBTIME so that you can sensibly format all three of: DATETIME YEAR TO SECOND DATETIME YEAR TO DAY DATETIME HOUR TO FRACTION(5) Hence, DBTIME and its ugly sibling, GL_*TIME, are not worth the paper they're documented on. Just my jaundiced opinion on the subject, but no-one has ever come up with an answer for my question. Richard Auslander wrote: > Greetings all ! > > [IDS 7.30UC1 on Solaris] > > I'm trying to set the environment variable "DBTIME" so that I can change > the date format for datetime datatypes. When I set the environment > variable, it has no effect. But here's the rub: I'm setting it in a > DBACCESS session which I run on the same machine as the db server, since > I'm trying to load some data using dbaccess. Is DBACCESS sensitive to > the DBTIME environment variable, or is it only the server itself? If > it's just the server, that won't work for us, since we want to change > the datetime format temporarily for just one data loading session. Is > there a workaround for this? Many thanks. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.62 -- see http://www.perl.com/CPAN #include <disclaimer.h>