topic Dump in Update statement of Native SQL in Application Development and Automation Discussions

Dump in Update statement of Native SQL

Former Member — Wed, 06 Jan 2010 12:40:46 GMT

Hi All,

I am getting a short dump while executing the below xode snippet in Native SQL.

EXEC SQL.
    UPDATE misuser.table_4 set otype = :gc_otype1
      WHERE otype = :gc_otype
  IF sy-dbcnt = 0.
    WRITE: 'No rows updated'.
   ELSE.
    WRITE: sy-dbcnt, 'rows updated'.
  ENDIF.
  ENDEXEC.

Please update on this if anybody knows.

Thanks

Nitesh

Re: Dump in Update statement of Native SQL

kesavadas_thekkillath — Wed, 06 Jan 2010 12:56:27 GMT

Dump report ?

Re: Dump in Update statement of Native SQL

JL23 — Wed, 06 Jan 2010 12:57:33 GMT

and what did the short dump tell you why the program terminated?

Re: Dump in Update statement of Native SQL

Former Member — Wed, 06 Jan 2010 13:01:47 GMT

Hi Jurgen,

I dont have any key field in table misuser.table_4.

Dump: Short text
   An SQL error occurred when executing Native SQL.

Thanks

Nitesh

Re: Dump in Update statement of Native SQL

JL23 — Wed, 06 Jan 2010 13:11:35 GMT

go into ST22 transaction already in the overview you should see the name of the runtime error.

here you can go into the detail to read the dump. read section 1 to 5 of the short dump. it usually gives you all info that you need to know the root cause.

Re: Dump in Update statement of Native SQL

Former Member — Thu, 07 Jan 2010 06:06:34 GMT

Thanks a lot.