ORDERBY<f1>[ASCENDING|DESCENDING]<f2> [ASCENDING|DESCENDING] 二、INSERT 一条数据 INSERTINTO<target>VALUES<wa>.INSERT<target>FROM<wa>. 多条数据. INSERT<target>FROMTABLE [ACCEPTING DUPLICATE KEYS] 插入数据时,避免有相同主键引起dump error错误,使用ACCEPTING DUPLICATE。此时sy-subrc返回4. 三、UPDATE 一...
INSERT INTO ZTTEMP VALUES ('4502',:LV_WERKS) ENDEXEC. IF sy-subrc = 0. *提交数据更新 EXEC SQL. COMMIT WORK ENDEXEC. DATA: lv_msg(50). lv_msg = '写入成功记录数:' && sy-dbcnt . cl_demo_output=>display( lv_msg ). ELSE. cl_demo_output=>display( '写入失败' ). ENDIF. ENDFO...
ABAP/4中可以利用SQL语法创建或读取TABLE,SQL语法分为DDL(DATA DEFINE LANGUAGE)语言和DML(DATA MULTIPULATION LANGUAGE)语言,DDL语言是指数据定义语言,例如CREATE等, DML语言是数据操作语言,例如SELECT, INSERT等语句。SQL语句有OPEN SQL语句和NATIVE SQL语句。 OPEN SQL语句不是标准SQL语句,是ABAP/4语言,利用OPEN S...
%_p_4_%_app_%-text = 'INSERT:写入表内容'. START-OF-SELECTION. conn = 'MTD'. "检查连接是否已经打开 EXEC SQL. SET CONNECTION :conn ENDEXEC. IF sy-subrc <> 0. "如果连接没有打开, 打开连接 EXEC SQL. CONNECT TO :conn ENDEXEC. ENDIF. *两种方式: 方式一性能好于方式二 CASE 'X'. ...
EXEC SQL. insert into "REALREAL"."realreal.db/ORDER_HEADER" values("REALREAL"."realreal.db/ORDER_SEQ".NEXTVAL, :lv_date,:lv_buyer,:lv_processor,:lv_amount,now() ) ENDEXEC. EXEC SQL. insert into "REALREAL"."realreal.db/ORDER_ITEM" values((select max(ORDER_KEY) from "REALREAL"."real...
exec sql.UPDATE TESTSET A = 'JKJKJKJKJJ'WHERE C = 3* DELETE TEST* WHERE C = 0* INSERT INTO TEST V ALUES ('aaaaaa','BBBBBB',100)*SELECT A ,B , C INTO :W A FROM TESTendexec.*&Form LOOP_OUT*&-*输出*form LOOP_OUT.*write: / WA-A ,WA-B , WA-C.*endform."LOOP_OUT...
21、NDFUNCTION ENDIF ENDLOOP ENDMODULE ENDON ENDPROVIDE ENDSELECT ENDWHILEEXEC SQL: EXEC SQL PERFORMING form ENDEXEC*-EXIT: EXIT EXIT FROM SQL EXIT FROM STEP-LOOP*-EXPORT: EXPORT objn1 . objn2 TO MEMORY FROM v1 . ID key1 EXPORT objn1 . objn2 TO DATABASE etab3(ar4) ID key5 FROM...
exec sql. SELECT xianb INTO :lv_xianb FROM ZTPP0015 WHERE werks = :gt_alv-werks and xianb = :gt_alv-xianb endexec. if sy-subrc = 0. exec sql. update ZTPP0015 set descp_xb = :gt_alv-descp_xb, bum = :gt_alv-bum, descp_bm = :gt_alv-descp_bm, ...
I have a problem in ABAP connect SQL,Below is my code snippet sentence. CONCATENATE 'Insert Into [timportcortrol]' '(zucode,zstate,zdate,zkind) Values(''' VG_PCID ''',''' '1'',''' SY-DATUM ''',''' '1' ''')' INTO SQL. CALL METHOD OF REC 'Execute' EXPORTING #1 = SQL...
EXEC SQL. ... ENDEXEC. Effect These statements define an area in an ABAP program in which one or more Native SQL statements can be specified statically. The area between EXEC and ENDEXEC is not checked completely by the syntax check. The statements entered there are passed to the Native...