Skip to Content

sql statements generated by BODS 4.2

hi there,

Im loading data from SAP ECC to Sql Server 2012 using BODS 4.2 I'm facing issues with date and datetime fields in the target table.

For date datatype in the target table following error message is displayed "ODBC data source <CUSIID0q\WARRANTY> error message for operation <SQLBindParameter>: <[Microsoft][ODBC SQL Server Driver]Optional feature not implemented>."

For the datetime datatype in the target table following error message is displayed "datetime field overflow".

I would like to see the sql statements that are being generated by BODS for writing to the target table. Is there any trace option that I can enable that shows me the sql code thats generated during the execution of the job to understand this error message better.

Regards,

samique

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 03, 2017 at 05:24 PM

    From SQL Server side you can try to use SQL Profiler. But I believe what you really want is to trace the statements from the BODS right?

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 06, 2017 at 09:03 AM

    Can you trying using SQL Server Native client instead of ODBC driver.

    Are you fetching data directly from SAP tables or using an ABAP Data flow?

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded