Q
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 
  
DATE-HEADING 
11/01/39 
12/02/39 
+++++++ 
++++++++ 
++++++++ 
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.

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.

-ADS BY GOOGLE

SearchDataCenter

Close