Re: PB with DBDATE (IUS2000)

Hi, Thx for your anwser, I'll try to be a bit more clear. The Data type of the date is DATE. The data are in the table displayed with the format MM/DD/YYYY. Date are stored as integer (Informix support). I think DBDATE is not recognize or not known by the engine, so it doesn't convert the date to a proper state to be stored in the DB. "COOPER, Joseph" wrote: > > > > Hi All, > > I'm running IUS 2000 on Sun ultra entreprise 450, I've set > > the variable > > DBDATE on my environement with Y4MD/. In my table the data are stored > > under the format MM/DD/YYYY. And I get an error -1204: invalid year in > > date while I try to update or insert. It seems pretty obvious, but why > > the engine does not take care of my DBDATE setting ??? > > We're running also webdriver (webblade web.3.36.uc6). > > I don't fully understand! > > Are you saying that the data in the table is not stored > as a date but instead as a char. > DBDATE converts informix dates ( which are stored as > integer - I think ) into the required format. > > What is the data type of the date > > > > > Any clues ???? > > Thx for help. > > > > Steph. > > > > -- > > _________________________________________________________________ > > > > Stephane Monier > > DBA - System Engineer > > REEF France > > 116, rue du Faubourg Saint Martin - 75010 Paris > > Phone 33 (0)1 55 26 53 59 - Fax 33 (0)1 55 26 53 55 > > http://www.reef.com - http://product.reef.com > > _________________________________________________________________ > > > > REEF is a global provider of Internetware for online publishing, > > e-commerce, Web site administration and dynamic asset management. > > _________________________________________________________________ > > > > > > ___________________________________________________________________________ > This email is confidential and intended solely for the use of the > individual to whom it is addressed. Any views or opinions presented are > solely those of the author and do not necessarily represent those of > Sema Group. > If you are not the intended recipient, be advised that you have received this > email in error and that any use, dissemination, forwarding, printing, or > copying of this email is strictly prohibited. > > If you have received this email in error please notify the Sema Group > Helpdesk by telephone on +44 (0) 121 627 5600. > ___________________________________________________________________________ -- _________________________________________________________________ Stephane Monier DBA - System Engineer REEF France 116, rue du Faubourg Saint Martin - 75010 Paris Phone 33 (0)1 55 26 53 59 - Fax 33 (0)1 55 26 53 55 http://www.reef.com - http://product.reef.com _________________________________________________________________ REEF is a global provider of Internetware for online publishing, e-commerce, Web site administration and dynamic asset management. _________________________________________________________________

Hi Joseph, After installing Informix Client you have to set the "Setnet" environments. Set DBDATE = MDY4/ FYI - Powerbuilder reads the env. from the win.ini not the registry!! C/YA