How to write a SQL Update statement in a TI process
Posted: Tue Jan 17, 2017 11:26 am
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
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