Upadate Syntax

Database

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

1 REPLY
Supporter

Re: Upadate Syntax

just remove the "table" 

update lci_work_tbls.wi_purge_tbls_list

set delete_flag='N'

where SERIAL in(149);