Open command
Posted: Fri Nov 19, 2010 2:11 am
Hi all
i want to update a table AZ_PMGProvXRef_Temp1 based on the below query
the Query is
i want to do this in open command.
but open command cannot be used to commit(i had seen this in datastage developers guide), so how to commit the records in open command
can i put simply semi-colon ' ; ' or 'COMMIT;'
my database is SQL server-2005 and i am using ODBC stage and 2-node config file
Thanks in advance
i want to update a table AZ_PMGProvXRef_Temp1 based on the below query
the Query is
Update AZ_PMGProvXRef_Temp1
Set
ProductID = 'CO'
where
ProductID = '3' or
productid = '0';
i want to do this in open command.
but open command cannot be used to commit(i had seen this in datastage developers guide), so how to commit the records in open command
can i put simply semi-colon ' ; ' or 'COMMIT;'
my database is SQL server-2005 and i am using ODBC stage and 2-node config file
Thanks in advance