On the Options tab,you selected a Standard for the generate SQL to follow. However, some of the format values that are used to format time, dates, and literal constants are compatible with the standards. If you continually get an error message, indicating that you are selecting a Standards option that is not compatible with your format settings, you might considermodifiying the format information provided by your data source. For more information, see Setting up your JDBC connection.
ANSI/ISO Standard
Naming convention:
SQL naming convention
Decimal separator:
. (period)
Time format:
hh.mm.ss (*ISO)
Date format:
yyyy-mm-dd (*ISO)
DB2 family Standard
Naming convention:
SQL naming convention
Decimal separator:
. (period)
Time format:
hh.mm.ss (*ISO)
hh:mm AM/PM (*USA)
hh.mm.ss (*EUR)
hh:mm:ss (*JIS)
Date format:
yyyy-mm-dd (*ISO)
mm/dd/yyyy (*USA)
dd.mm.yyyy (*EUR)
yyyy-mm-dd (*JIS)
DB2 family with extensions
Naming convention:
SQL naming convention
System naming convention
Decimal separator:
. (period)
, (comma)
Time format:
hh.mm.ss (*ISO)
hh.mm.ss (*EUR)
hh:mm:ss (*JIS)
hh:mm AM/PM (*USA)
hh:mm:ss (*HMS)
Date format:
yyy-mm-dd (*ISO)
dd.mm.yyy (*EUR)
yyy-mm-dd (*JIS)
mm/dd/yyyy (*USA)
mm/dd/yy (*MDY)
dd/mm/yy (*DMY)
yy/mm/dd (*YMD)
yy/ddd (*JUL)