Update SQL Statement inside TI Process

[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

[mvaspal]

what happens if you try this:

Code: Select all

If (STG_Meeting_Measures @= 'Class Size');

classSize = VValue; 
vSQL = 'update rpt_sample set class_size = ' | classSize | ' where VYear = ' | VvYear | ' ;' ;

ODBCOutput( 'WLM_STG',vSQL); 

endif;

[mvaspal]

sorry, this may not work as those variables are numeric variables, so you may need to convert it to string