topic Re: How/Where to Interrogate Database Return Codes in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/how-where-to-interrogate-database-return-codes/m-p/10136243#M1818739 <HTML><HEAD></HEAD><BODY><P>Thank you Tomas and Rurda.</P><P></P><P>This is exactly what I was looking for!</P><P></P><P>Appreciate it.</P><P></P><P>Andy</P></BODY></HTML> Tue, 11 Feb 2014 15:58:37 GMT Former Member 2014-02-11T15:58:37Z How/Where to Interrogate Database Return Codes https://community.sap.com/t5/application-development-and-automation-discussions/how-where-to-interrogate-database-return-codes/m-p/10136240#M1818736 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am using a SQL INSERT statement to add records to a "Z" table in SAP.</P><P></P><P>Other than SY_SUBRC, what can I look at to determine the status of the INSERT?</P><P></P><P>For example, if I write a record that fails due to a duplicate key, other than SY_SUBRC, what can I look at to tell me the exact cause of the failure?</P><P></P><P>Thanks for your help,</P><P>Andy</P></BODY></HTML> Tue, 11 Feb 2014 13:59:44 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-where-to-interrogate-database-return-codes/m-p/10136240#M1818736 Former Member 2014-02-11T13:59:44Z Re: How/Where to Interrogate Database Return Codes https://community.sap.com/t5/application-development-and-automation-discussions/how-where-to-interrogate-database-return-codes/m-p/10136241#M1818737 <HTML><HEAD></HEAD><BODY><P>Hi Andrew,</P><P></P><P>You can check SY-DBCNT which should give you how many records are updated/inserted.</P><P></P><P>Regards,</P><P>R</P></BODY></HTML> Tue, 11 Feb 2014 14:05:08 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-where-to-interrogate-database-return-codes/m-p/10136241#M1818737 Former Member 2014-02-11T14:05:08Z Re: How/Where to Interrogate Database Return Codes https://community.sap.com/t5/application-development-and-automation-discussions/how-where-to-interrogate-database-return-codes/m-p/10136242#M1818738 <HTML><HEAD></HEAD><BODY><P>If you mean "Native SQL" with EXEC SQL. ... ENDEXEC. ,then you can (should) catch catchable exceptions from CX_SY_NATIVE_SQL_ERROR <SPAN __jive_emoticon_name="happy" __jive_macro_name="emoticon" class="jive_macro jive_emote" src="https://community.sap.com/568/images/emoticons/happy.gif"></SPAN> From there you will get exact error texts of what happened.</P></BODY></HTML> Tue, 11 Feb 2014 15:01:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-where-to-interrogate-database-return-codes/m-p/10136242#M1818738 Tomas_Buryanek 2014-02-11T15:01:19Z Re: How/Where to Interrogate Database Return Codes https://community.sap.com/t5/application-development-and-automation-discussions/how-where-to-interrogate-database-return-codes/m-p/10136243#M1818739 <HTML><HEAD></HEAD><BODY><P>Thank you Tomas and Rurda.</P><P></P><P>This is exactly what I was looking for!</P><P></P><P>Appreciate it.</P><P></P><P>Andy</P></BODY></HTML> Tue, 11 Feb 2014 15:58:37 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-where-to-interrogate-database-return-codes/m-p/10136243#M1818739 Former Member 2014-02-11T15:58:37Z