EXEC SQL. command [UPDATE]

[former_member207153]

Hi Expert.

on 4.6c i use below statement to update other table which reside in other sql server :

DATA: Updatedby(10).

updatedby = sy-repid.

exec sql.

update SAP_BOOKING

set contractno = '1234',

sapstatusdate = GETDATE(),

lastupdatedby = :updatedby

where BOOKINGNO = '22384'

commit

endexec.

but when i trigger this statement on ECC6 env, this command failed , its due to :updatedby parameter.

how to deal with this problem? did anyone encounter this problem before? please kindly help.

[former_member222860]

Hi,

Check the tcode SM21, you'll find the detailed analysis of the error.

[former_member207153]

i did try using that sm21, but not helping to solve problem.

not much information specify in there.

[former_member222860]

Pl. check the datatype and length of the field 'Updatedby' at the database level and Maintain the same at the ABAP level.

[former_member207153]

Seem either because of kernel error or something,

This coding only work in 4.6C , but in ECC6, i tested and found that

it must use Method EXECUTE_UPDATE instead using direct command on my previous thread.

anyone have other comment , prob can share with me any SAP Notes related with my thread?

[former_member207153]

case close