Q

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.
This was first 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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchEnterpriseLinux

SearchDataCenter

Close