Re: DBCENTURY and 4GL and ISQL

Christian Winterhager wrote: > > Hi, > > we are working with IDS 7.3, ISQL 6.04. If we set DBCENTURY=C, then > INSERTs with dbaccess are working well, as we expected it, but the > DATE-fields in the ISQL-Forms expand 2-digit Years allqays with "19". > > On page 45 of Tech Notes, Volume 8, Issue 3, 1998, June Tong wrote: > "Similarly, for input performed through a 4GL PROMPT statement or form, > if the receiving variable is defined as a DATE datatype, the century > expansion is accomplished at the point where the data is placed in the > variable, and the DBCCENTURY value is taken from the client." > > It seems, that this is not true. This is indeed true, and exactly what is happening. Unfortunately your 4GL version does not support DBCENTURY! So the year will be expanded by 4GL with 1900. You need to look at 4GL version 7.20 for DBCENTURY support. Perhaps June's definition could be expanded: "Similarly, for input performed through a 4GL PROMPT statement or form, if the receiving variable is defined as a DATE datatype, the century expansion is accomplished at the point where the data is placed in the variable, and the DBCENTURY value is taken from the client. For older clients that do not support DBCENTURY, 1900 will be used explicitly." Although I suspect June was assuming the client did support DBCENTURY, as that was the topic of the note. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 838250 2325 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+