Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Control and fix date format problems on AS/400 SQL

To avoid date format problems on the DB2 for iSQL interface, specify a date format that supports a four-digit year value with the DATFMT parameter in the SQL precompiled commands.

How can you set up AS/400 SQL to fix this query:
Select SDATE from Library/file 
AS/400 SQL does not handle dates > 2039 
To eliminate this behavior, you must specify a date format (eg, *USA) that supports a 4-digit year value. Each DB2 for iSQL interface has a way to control the date format, for instance, the DATFMT parameter on the SQL precompiled commands.
This was last published in March 2009

Dig Deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.