topic updating ztable with data in Application Development and Automation Discussions

updating ztable with data

Former Member — Wed, 20 Jun 2007 13:06:21 GMT

friends,

i need to modify a dbtab which has field1 to be modified to 'Y'

keeping the remaining fields unchanged

with where condition period =P_period.

can someone help with correct syntax,

thank you.

Former Member — Wed, 20 Jun 2007 13:11:43 GMT

modify itab where period = p_period transporting field1.

Former Member — Wed, 20 Jun 2007 13:15:38 GMT

update <ztable>

set <ztable>-field = <value>

where period =P_period

<b>reward points if useful</b>

regards

ravish

former_member194669 — Wed, 20 Jun 2007 13:19:16 GMT

Hi,

Please check this


update dbtab SET   field1 ='Y'  WHERE period = p_period.
commit work.

aRs

Former Member — Wed, 20 Jun 2007 13:21:24 GMT

hi saritha,

use can use either modify or update statement for internal tables and update for only database tables.

try like this,

modify itab where fldname = ' ' transporting fldname.

update itab where fldname = ' ' .

if useful reward some points.

with reagrds,

suresh.