How to write a SQL Update statement in a TI process

Post Reply
NewtoTm1
Posts: 5
Joined: Fri Dec 09, 2016 4:40 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

How to write a SQL Update statement in a TI process

Post by NewtoTm1 »

Hi Everyone,
I am trying to write a sql update statement in a TI process but I keep getting an error 'SET key word missing' and execution is aborted. I have pasted out the part where I am using the update statement. It will be great if anyone could help me out with this.

---------------------------------------------------------------

If (STG_Meeting_Measures @= 'Class Size');

classSize = VValue;

ODBCOutput( 'WLM_STG','update rpt_sample

set class_size = ''%classSize%''

where VYear =''%VvYear%''');

endif;

----------------------------------------------------------------------
Thanks
Post Reply