native SQL

[Former Member]

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?

[rainer_hbenthal]

Other system might have a different DBMS.

[Former Member]

you can not declare

ORDER BY PRIMARY KEY / must be fields from table

solved!!!