FW: RE: How change SO environments by DBACCESS ?

Well, you could insert your row and then have a trigger & stored procedure look at the current date and the one you inserted to determine if you need to do something like my_date = my_date - 100 UNITS YEAR. --EEM -----Original Message----- From: DYNAMIC INFORMIX [mailto:iffranco@hotmail.com] Sent: Monday, March 05, 2007 2:22 PM To: Everett Mills Subject: Re: RE: How change SO environments by DBACCESS ? [] The following e-mail was sent to you via IDS Forum from DYNAMIC INFORMIX (iffranco@hotmail.com) at IP address 207.43.195.202 (kcecfp02.sprint.com). ************************************************************************ ******* Re: RE: How change SO environments by DBACCESS ? Hi. I need do a insert operation of a DATE field with a 2 algarism year (ex - 99). To do that, I have to update the DBCENTURY unix environment variable to Value C (Closest), but I was thinking to make a Procedure in DBACCESS to do this, because ending the Insert, the DBCENTURY have to return to previous value : R (current). I know, it is confuse. Thanks. Dynamic ************************************************************************ *******