topic Re: SQL return codes... in Application Development and Automation Discussions

SQL return codes...

Former Member — Mon, 28 Aug 2006 12:32:30 GMT

Hi all,

I'm curious about the return code for a SQl statment embedded in my ABAP program. The help states that any code other than 0 suggests there was an error executing the SQL statement. So...I include the following to test for an error:

IF SY-SUBRC <> 0.

MESSAGE I000(38) WITH 'Error retrieving data from MAKT MARA MARC'(M01).

LEAVE LIST-PROCESSING.

ENDIF.

I notice that if no records are returned my app throws the message and exits. Why? No records returned doesn't necessarily mean an error..it just means the query returned no records. Also...what would be the correct way to handle the error so no recoreds returned doesn't poop on me?

regards,

Mat

Re: SQL return codes...

Former Member — Mon, 28 Aug 2006 13:13:26 GMT

Hi,

then it will return sy-subrc 4 you can write case endcase.

with the different actions to take on each return

grtz

Koen

Re: SQL return codes...

Former Member — Mon, 28 Aug 2006 13:14:04 GMT

(double post, sorry)

Koen

Message was edited by: Koen Labie

Re: SQL return codes...

Former Member — Mon, 28 Aug 2006 14:28:08 GMT

The return code for a SELECT statement just tells you if any records were returned or not. If there is an SQL error, the program will likely dump.

Rob