updating ztable with data

[Former Member]

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]

modify itab where period = p_period transporting field1.

[Former Member]

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.

or

update itab where fldname = ' ' .

if useful reward some points.

with reagrds,

suresh.

[Former Member]

hi

update <ztable>

set <ztable>-field = <value>

where period =P_period

<b>reward points if useful</b>

regards

ravish

[former_member194669]

Hi,

Please check this

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

aRs