Re: DBCENTURY

H.Sahar wrote in message <36534cdd.0@newsread1.dircon.co.uk>... > >I am not sure how I can set DBCENTURY. > >Do I have to set as environment variable DBDATE=DBCENTURY >or else? No. DBDATE is a pattern to show how dates should be displayed, like "mdy4/" would show 11/19/1998. DBCENTURY is a single character that describes the rules that determine what century to assign a date encountered in two-digit-year form. If you don't have DBCENTURY set, the default of "C" (current century) is used. You set DBCENTURY just like any other env variable (like DBDATE): in /etc/profile, .profile, or some shell script prior to running a 4GL program. See Informix Guide to SQL-Reference chapter 4 for a discussion of environment variables, and specifically the possible values for DBCENTURY. Bottom line, if you don't want to worry about DBCENTURY and other Y2K issues, make sure all programs, database tables, etc treat years as a full four digits, like us smart guys have for years. Dennis Pimple Principal Consultant Informix Software Inc. "Y2K compliant since 1955"