Update Query in TI Process data tab

[manoj928]

Hello All,

Need a quick help.

I have below statement in data tab but whenever i run the TI Process i get an error of SQL invalidity.

sql= 'UPDATE MON_SAL SET UPI = get_decryption(UPI) WHERE UPI IS NOT NULL AND month =''APR'' and year = 2015';

ODBCoutput(strOrcDB, EXPAND(sql));


Please let me know what wrong with this code.

Thanks.

[Michel Zijlema]

Hello All,

Need a quick help.

I have below statement in data tab but whenever i run the TI Process i get an error of SQL invalidity.

sql= 'UPDATE MON_SAL SET UPI = get_decryption(UPI) WHERE UPI IS NOT NULL AND month =''APR'' and year = 2015';

ODBCoutput(strOrcDB, EXPAND(sql));


Please let me know what wrong with this code.

Thanks.

I don't know why you enclosed the string APR in double single quotes, you can leave those out. Also the Expand function is not required here.
You could try:

Code: Select all

sql= 'UPDATE MON_SAL SET UPI = get_decryption(UPI) WHERE UPI IS NOT NULL AND month = APR and year = 2015';
ODBCoutput(strOrcDB, sql);

Michel