Re: DBCENTURY

You did include the OS and DB type and version, but you forgot the key information on what application you are using. DBCENTURY is implemented both in the engine and for tools for different purposes. If the application is 4GL it doesn't support DBCENTURY until ver. 7.2 which is just beeing released. ESQL/C, dbaccess and other tools support it in different versions that are documented at the end of the page you refer to. Also remember that DBCENTURY isn't all easy. I.e. a date in a literal string coming from any tool will be interpreted by the engine so it's supported even with 4GL prior to 7.2 (or an ODBC based application or anything else where you might not think of DBCENTURY immediately). Entering and displaying dates via 4GL or other tools is however an application issue, so the tool must understand the variable. On Fri, 22 May 1998 14:46:36 GMT, mbeauvais@wbn.ca (Marc Beauvais) wrote: >Hi, I have looked everywhere to understand how to use DBCENTURY. I >looked at www.informix.com/informix/products/year2000.htm and found >information. > >I then looked in the Informix Guide to SQL:Reference and found the >syntax. It seems like I just have to set the DBCENTURY variable in >the user profile and It should work. But Informix ignores it. > >Can somebody can give me a hint? Do I need to set something else? > >This is the way I set DBCENTURY: > >DBCENTURY=C;export DBCENTURY > >The system I use: > >AIX 4.1.5 >SE 7.2 Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)