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