TM1 Forum

Posted: **Tue Jun 30, 2015 3:27 pm**

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.

Posted: **Wed Jul 01, 2015 7:16 am**

manoj928 wrote: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

TM1 Forum

Update Query in TI Process data tab

Update Query in TI Process data tab

Re: Update Query in TI Process data tab