All Forums Database
pnandak 1 post Joined 05/12
28 May 2012
Upadate Syntax

update table lci_work_tbls.wi_purge_tbls_list
set delete_flag='N'
where SERIAL in(149);

 

the above code throws me error -

"expected something like a name or unicode delimiter identifier or "UDFCALLNAME" keyword between UPDATE keyword and the TABLE keyword....

 

166    crm_mart1_tbls    pn_sears_lyl_all                            Y    ?
159    crm_mart1_tbls    pn_srslyl_apr_jun_catg                 Y    ?
149    crm_mart1_tbls    pn_srs_apr_jun_buyer_5MM         Y    ?
183    crm_mart1_tbls    pn_sears_apr_jun_base_5MM       Y    ?
244    crm_mart1_tbls    pn_srslyl_apr_jun_cont                 Y    ?
 

i want to update those flags to N based on serial number

ulrich 816 posts Joined 09/09
28 May 2012

just remove the "table" 

update lci_work_tbls.wi_purge_tbls_list
set delete_flag='N'
where SERIAL in(149);

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

You must sign in to leave a comment.