Skip to Content
0
Jun 08, 2009 at 06:24 AM

EXEC SQL. command [UPDATE]

35 Views

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.