topic insert Native SQL in Application Development and Automation Discussions

insert Native SQL

Former Member — Fri, 10 Aug 2007 13:36:25 GMT

Hi everybody, I am having a problem when i try to do an insert in a ms sql external database. I am caching the errors, but it doesnt show error. Its like that the operation was executed well, but when i read the table, the records inserted are not there. Wich could be the problem?

Regards

Re: insert Native SQL

former_member194669 — Fri, 10 Aug 2007 17:38:14 GMT

Hi,

Have you given commit ?

Like the following


 EXEC SQL.
    SET CONNECTION :con_name
  ENDEXEC.

  IF SY-SUBRC <> 0.
    EXEC SQL.
      CONNECT TO :con_name
    ENDEXEC.

    IF SY-SUBRC <> 0.
*     error handling  " <<<<< Error Handling 
    ENDIF.
  ENDIF.

  EXEC SQL.
*     ... "<<< your code to do something
  ENDEXEC.

* Commit the changes on 'con_name'
  EXEC SQL.
    COMMIT.          "<<<<<<< Commit work
  ENDEXEC.
  EXEC SQL.
    SET CONNECTION DEFAULT
  ENDEXEC.

aRs

Re: insert Native SQL

Former Member — Wed, 15 Aug 2007 13:32:37 GMT

The commit was thw problem. Thanks.