topic native SQL in Application Development and Automation Discussions

native SQL

Former Member — Mon, 19 Oct 2009 12:13:25 GMT

Hi all , I have problem run time eror in code


   OPEN dbcur1 FOR
      SELECT * FROM zbakt
      WHERE  indic IN ('P', 'A', 'B', 'K', 'T')
      AND    rownum <= :brred
      ORDER BY PRIMARY KEY
  ENDEXEC.
  DO.
    EXEC SQL.
      FETCH NEXT FROM dbcur1 INTO :itzbakt
    ENDEXEC.
    IF sy-subrc <> 0.
      EXIT.
    ELSE.
      APPEND itzbakt.
    ENDIF.
  ENDDO.
  EXEC SQL.
    CLOSE dbcur
  ENDEXEC.

on FETCH NEXT statement run time error aper

but in other programs same statement is OK.

Any sugsest?

Re: native SQL

rainer_hbenthal — Mon, 19 Oct 2009 12:18:09 GMT

Other system might have a different DBMS.

Re: native SQL

Former Member — Mon, 19 Oct 2009 12:43:04 GMT

you can not declare

ORDER BY PRIMARY KEY / must be fields from table

solved!!!