DEMO_NATIVE_SQL

REPORT demo_native_sql .

 

DATA: BEGIN OF wa,

        connid   TYPE spfli-connid,

        cityfrom TYPE spfli-cityfrom,

        cityto   TYPE spfli-cityto,

      END OF wa.

 

DATA c1 TYPE spfli-carrid VALUE 'LH'.

 

EXEC SQL PERFORMING loop_output.

  SELECT connid, cityfrom, cityto

  INTO   :wa

  FROM   spfli

  WHERE  carrid = :c1

ENDEXEC.

 

FORM loop_output.

  WRITE: / wa-connid, wa-cityfrom, wa-cityto.

ENDFORM.