dEAR rafik2k,
Below u can find my sql and error log.
1.SQL that I used in the user-defined sql.
INSERT INTO LIB1.destinationtable(ID, TR, DAT, VEN, DPT, CT, ST, CTN, CN, YY, MM, WK, DD, RET, CST, RAT, SDEP, COMM, QTY) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) WITH NONE;
UPDATE LIB1.destinationtable SET ID = ?, TR = ?, DAT = ?, VEN = ?, DPT = ?, CT = ?, ST = ?, CTN = ?, CN = ?, YY = ?, MM = ?, WK = ?, DD = ?, RET = ?, CST = ?, RAT = ?, SDEP = ?, COMM = ?, QTY = ? WHERE (SID = ? AND STR = ? AND DAT = ? AND VEN = ? AND DPT = ? AND CT = ? AND CTN = ? AND SDEP = ?) WITH NONE;
2.Error log that I got when I run.
UpdateJob1.CTransformerStage3.Lnk_To_Destinatintable: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO LIB11.Destinatintable(ID, SS, DAT, VEN, DPT, CT, ST, CTN, CN, YY, MM, WK, DD, RET, CST, RAT, SDEP, COMM, QTY) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) WITH NONE;
UPDATE LIB11.Destinatintable SET ID = ?, TR = ?, DAT = ?, VEN = ?, DPT = ?, CT = ?, ST = ?, CTN = ?, CN = ?, YY = ?, MM = ?, WK = ?, DD = ?, RET = ?, CST = ?, RAT = ?, SDEP = ?, COMM = ?, QTY = ? WHERE (SID = ? AND STR = ? AND DAT = ? AND VEN = ? AND DPT = ? AND CT = ? AND CTN = ? AND SDEP = ?) WITH NONE
SQLSTATE=S1009, DBMS.CODE=0
[Ardent][SQL Client][ODBC][Microsoft][ODBC Driver Manager] Invalid argument value
ID = 9
TR = 5
DAT = 70514
VEN = 7315
DPT = 24
CT = 1
ST = "CC"
CTN = 353
CN = 0
YY = 7
MM = 5
WK = 20
DD = 1
RET = 7662.94
CST = 0.00
RAT = 4.00
SDEP = 8
COMM = 306.51
QTY = 2
Is there any idea u have???
Thanks so much,
rafik2k wrote:Can you post the sql you are using insert or update?
Also post log error message for that