一段读取数据表的例子

从数据库读取的几种方法

• 从数据表直接读取到工作区输出
• 从数据表读到内表，再从内表输出
• 从内表逐行读取到工作区，再输出

[@more@]REPORT YTEST0021.
DATA A_SPFLI TYPE SPFLI.
DATA TA_SPFLI TYPE TABLE OF SPFLI WITH HEADER LINE.
ULINE.
WRITE :/ 'USER ZONE'.
ULINE.
SELECT * INTO CORRESPONDING FIELDS OF A_SPFLI FROM SPFLI UP TO 5 ROWS.
WRITE :/ A_SPFLI-CONNID , A_SPFLI-CARRID, A_SPFLI-CITYFROM, A_SPFLI-CITYTO.
ENDSELECT.
ULINE.
WRITE :/'USE INSERT TABLE'.
ULINE.
SELECT * INTO CORRESPONDING FIELDS OF TABLE TA_SPFLI FROM SPFLI UP TO 5 ROWS.
LOOP AT TA_SPFLI.
WRITE :/ TA_SPFLI-CONNID, TA_SPFLI-CARRID, TA_SPFLI-CITYFROM, TA_SPFLI-CITYTO.
ENDLOOP.
ULINE.
LOOP AT TA_SPFLI INTO A_SPFLI.
WRITE:/ A_SPFLI-CONNID, A_SPFLI-CARRID, A_SPFLI-CITYFROM, A_SPFLI-CITYTO.
ENDLOOP.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10339634/viewspace-922723/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10339634/viewspace-922723/