DATA STAGE VER 4.2
OS : NT
I am trying to REPLACE EXISTING ROWS COMPLETELY
in to ODBC stage MSSQL From A ODBC stage MSSQL
I have set the UPDATE ACTION AS : REPLACE EXISTING ROWS COMPLETELY
MY SQL SHOWS THIS
DELETE FROM NPP_2."dbo".DELIVERY_ORDERS_SUMMARY WHERE ();
INSERT INTO NPP_2."dbo".DELIVERY_ORDERS_SUMMARY(DO_ORDER_NO, GROUP_CODE, CUST_CODE, CUST_NAME, DEL_DATE, TTL_QTY, GROSS_AMT, NET_AMT, DISC_AMT, INVOICE_NO, FLAG) VALUES (?,?,?,?,?,?,?,?,?,?,?);
MY LOG SHOWS THE FOLLOWING ERROR:
UPDATEINVSUMMARY.CODBCStage2.DSLink4: DSD.BCIOpenW call to SQLPrepare failed.
DELETE FROM NPP_2."dbo".DELIVERY_ORDERS_SUMMARY WHERE ()
SQLSTATE=37000, DBMS.CODE=170
[Ardent][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
SQLSTATE=37000, DBMS.CODE=8180
[Ardent][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared
PLEASE HELP
THANKS AND REGARDS
SKPAHUJA
DSD.BCIPut Call to SQLExecute failed
Moderators: chulett, rschirm, roy