.com Solutions Inc. - Logo  
support header buttons
.
FmPro Script Diffbullet 7f FmPro Migrator bullet 7f CGIScripter
.
.
.
. .

 

 


.

. .

 

...
.

support troubleshooting title image

hline f image

Perl CGI Scripts - DB2 CLI0113E SQLSTATE 22007 Error Troubleshooting

[IBM][CLI Driver] CLI0113E SQLSTATE 22007: An invalid datetime format was detected; that is, an invalid string representation or value was specified. SQLSTATE=22007


Solution: This error may be seen in the error log or displayed in the web browser if a date is entered incorrectly. DB2 supports automatic conversion and entry of data info into the database in both MM-DD-YYYY and YYYY-MM-DD formats. DB2 does not support 2 digit numbers for the year component of the date.

hline f image

hline

. .

.

. .

 

 

 

Home | Products | Services | Downloads | Order | Support | Contact

Legal Notices

.
.   .
.
Home Products Services Downloads Order Support Contact