UPDATE

[Former Member]

is this code correct or do i need to put the table name befror the field name

UPDATE NRIV SET NRRANGENR = number where OBJECT = 'J_1IEXCLOC'

or it should be

UPDATE NRIV SET NRIV-NRRANGENR = number where NRIV-OBJECT = 'J_1IEXCLOC'

[Former Member]

it should be

UPDATE NRIV SET NRRANGENR = number where OBJECT = 'J_1IEXCLOC'

[Former Member]

Hi

first one is ok

plzz reward if u found i am helpfull.. plzz

[Former Member]

Thats a danger comand to be used in NRIV or other standard table... Use transaction SNRO to manipulate the NRIV table or the functions in function group SNR3.

[Former Member]

can you specify how shall i do this

[Former Member]

Hi,

You can use the first statement.

UPDATE NRIV SET NRRANGENR = number where OBJECT = 'J_1IEXCLOC'.

Thanks,

Sriram Ponna.

[Former Member]

hi,

UPDATE NRIV SET NRRANGENR = number where OBJECT = 'J_1IEXCLOC'

or Object in gr_object is correct version.

because when you are updating and dealing with one tableits enough mentioning the table at one part and syntax is also correct for the above only.

Regds

Sivaparvathi

Please reward points if helpful..

[Former Member]

The main question is why do you want to update a standard number interval (J_1IEXCLOC) ?