This is regarding a query which has been discussed a few times, but the exact fix seems to elude me.
Scenario:
We are trying to load a HANA table with the write method as "Insert Then Update".
The HANA table belongs to a package. Hence the table name shows up as "SCHEMA_NAME"."PACKAGE_NAME::TABLE_NAME". (with the double quotes.)
Issue:
The job seems to work when the generate SQL has been set to 'YES'.
But when we set it to 'NO' we immediately get a barrage of warnings.
Code: Select all
Message Id:
IIS-CONN-DAAPI-00063
Message:
Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
I had used the query from the director which datastage had generated and yet I am receiving the same warning.
Kindly help me with any pointers regarding resolving this issue.
Additional Information:
1. We have 24 columns in all, with 4 audit columns, two for create id and timestamp and another 2 for update id and timestamp.
2. We have 3 keys, but they are not actually available in the table. Can this be an issue ?
3. The generated sql is updating 21 columns with the exception of the three key fields. (21+3)
4. The insert statement inserts all 24 columns.
5. The source is a dataset having all the 24 columns. The jobs merely has a dataset leading to a copy and then to a ODBC stage. Rejects are captured as well.
6. Updates are happening properly despite the warning.