topic Re: EXEC SQL. command [UPDATE] in Application Development and Automation Discussions

EXEC SQL. command [UPDATE]

former_member207153 — Mon, 08 Jun 2009 06:24:17 GMT

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 — Mon, 08 Jun 2009 06:35:35 GMT

Hi,

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

former_member207153 — Mon, 08 Jun 2009 06:41:14 GMT

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

not much information specify in there.

former_member222860 — Mon, 08 Jun 2009 07:08:44 GMT

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

former_member207153 — Mon, 08 Jun 2009 07:23:54 GMT

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 — Tue, 02 Mar 2010 01:22:28 GMT

case close