topic Re: EXEC SQL join in ABAP program in Application Development and Automation Discussions

EXEC SQL join in ABAP program

Former Member — Tue, 09 Jun 2009 10:19:32 GMT

Hi All,

I am using EXEC SQL join in my ABAP report,but it is giving dump.could you please correct my following code?

START-OF-SELECTION.

CONCATENATE '%' pa_match '%' INTO tp_match.

EXEC SQL.

OPEN dbcur FOR

SELECT kunnr,name1, banks

FROM kna1 as a inner join

knbk as b

on a_{kunnr = b}kunnr

WHERE a.kunnr = b.kunnr and

upper(a~name1) LIKE :tp_match

ENDEXEC.

DO.

EXEC SQL.

FETCH NEXT dbcur INTO :wa_name1

ENDEXEC.

IF sy-subrc <> 0.

EXIT.

ENDIF.

APPEND wa_name1 TO ta_name1.

COLLECT wa_name1 INTO ta_name1.

ENDDO.

EXEC SQL.

CLOSE dbcur

ENDEXEC.

Re: EXEC SQL join in ABAP program

Former Member — Tue, 09 Jun 2009 10:22:02 GMT

why are u using EXEC SQL???

Re: EXEC SQL join in ABAP program

former_member222860 — Tue, 09 Jun 2009 10:23:59 GMT

Remove the 'As' from the statement

EXEC SQL.
  OPEN dbcur FOR
  SELECT kunnr,name1, banks
  FROM kna1 a inner join        "Delete 'AS' here
  knbk b
  on a~kunnr = b~kunnr
  WHERE a.kunnr = b.kunnr and
  upper(a~name1) LIKE :tp_match
ENDEXEC.

Re: EXEC SQL join in ABAP program

Former Member — Wed, 14 Oct 2009 12:53:43 GMT

"why are u using EXEC SQL???"

Because he needs NAME1 in uppercase when doing the select... something ABAP SQL doesn't support.

Edited by: Matt Sprague on Oct 14, 2009 2:54 PM