SAP Knowledge Base Article - Preview

1181679 - Error: "SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007" when trying to use the "sql()" function to insert a Data Integrator date field into the date field of another DB2 table

Symptom

  • When trying to use a script to use the "sql()" function to insert a Data Integrator date field into the date field of another DB2 table and the following error is received:
    • "SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007".


Read more...

Environment

SAP Data Integrator

Product

BusinessObjects Data Integrator XI R2 MBMD ; SAP Data Integrator 6.5 ; SAP Data Integrator XI ; SAP Data Integrator XI R2 ; SAP Data Integrator XI R2 Accelerated

Keywords

13107, Data Integrator, SQL0180N , KBA , EIM-DI , Data Integrator, Composer , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.