Question Re: native sql question in Technology Q&A

native sql question

Aaron_Lee — Sun, 22 Dec 2024 23:03:23 GMT

Hello experts on line, my codes is as below and without syntax error.

TYPES: BEGIN OF t_str,

carrid like sflight-carrid,

connid like sflight-connid,

END OF t_str.

data: gt_itab type table of t_str,

gs_wa type t_str,

gv_carrid like sflight-carrid value 'AA'.

EXEC SQL PERFORMING APPEND_ITAB.

SELECT A.CARRID, A.CONNID

INTO :GS_WA-CARRID, :GS_WA-CONNID

FROM SFLIGHT A

WHERE A.MANDT =: SY-MANDT AND A.CARRID =: GV_CARRID

ENDEXEC.

FORM APPEND_ITAB.

WRITE:/ GS_WA-CARRID, GS_WA-CONNID.

APPEND GS_WA TO GT_ITAB.

CLEAR GT_ITAB.

ENDFORM.

But when it runs, it has runtime error in category installation error. Short Text is ‘SQL error 257 occured while executing Native SQL’. How can I correct it? Thanks

Re: native sql question

Sandra_Rossi — Mon, 23 Dec 2024 07:46:20 GMT

":" must be placed right before the global variable name (e.g. use "A.MANDT = :SY-MANDT" instead of "A.MANDT =: SY-MANDT")

EXEC SQL PERFORMING APPEND_ITAB. SELECT A.CARRID, A.CONNID INTO :GS_WA-CARRID, :GS_WA-CONNID FROM SFLIGHT A WHERE A.MANDT = :SY-MANDT AND A.CARRID = :GV_CARRID ENDEXEC.

NB: Please use the buttons "..." and "</>" to display your code nicely, and also to let the people test and fix your code easily. See how to do it here: https://community.sap.com/t5/questions-about-sap-websites/how-to-post-code-in-sap-community-gt-2024/qaq-p/13684774

NB: Please indicate your database software if it's a question about native SQL ("sql error 257" depends on the database software).

Re: native sql question

Aaron_Lee — Tue, 24 Dec 2024 11:17:19 GMT

Hello Sandra_Rossi,

Re: native sql question

Aaron_Lee — Tue, 24 Dec 2024 11:17:46 GMT

Thanks very much for your explaination!