DELETE
Delete from a database table
- DELETE FROM dbtab WHERE condition.
- DELETE FROM (dbtabname) WHERE condition.
- DELETE dbtab.
- DELETE *dbtab.
- DELETE (dbtabname) ... .
- DELETE dbtab FROM TABLE itab.
- DELETE (dbtabname) FROM TABLE itab.
- DELETE dbtab VERSION vers.
- DELETE *dbtab VERSION vers.
Delete from an internal table
- DELETE itab.
- DELETE itab INDEX idx.
- DELETE itab FROM idx1 TO idx2.
- DELETE itab WHERE condition.
- DELETE ADJACENT DUPLICATES FROM itab.
Delete a program
- DELETE REPORT prog.
Delete text elements
- DELETE TEXTPOOL prog LANGUAGE lg.
Delete a data cluster
- DELETE FROM DATABASE dbtab(ar) ...ID key.
Delete a file
- DELETE DATASET dsn.
Delete a screen
- DELETE DYNPRO f.
Delete 구문을 제어하기 위해서 DB Table의 앞은 모두 Replace 구문으로 Blank 처리를 하고,
이후 구문들은 Split 구문으로 나눠줘서 DB Table을 Check 한다.
일단, DB Table의 모든 앞을 제거한 뒤에 그 후 Split 하면 DB Table만 남게 될 것이다.
INSERT
Insert into a database table
- INSERT INTO dbtab [CLIENT SPECIFIED] VALUES wa.
INSERT INTO (dbtabname) [CLIENT SPECIFIED] VALUES wa.
- INSERT dbtab [CLIENT SPECIFIED].
INSERT *dbtab [CLIENT SPECIFIED].
INSERT (dbtabname) [CLIENT SPECIFIED] ... .
- INSERT dbtab [CLIENT SPECIFIED] FROM TABLE itab.
INSERT (dbtabname) [CLIENT SPECIFIED] FROM TABLE itab.
Insert into an internal table
- INSERT [wa INTO|INITIAL LINE INTO] itab [INDEX idx].
INSERT LINES OF itab1 [FROM idx1] [TO idx2] INTO itab2
[INDEX idx3].
Insert into a field group
- INSERT f1 f2 ... INTO fg.
Insert a program
- INSERT REPORT prog FROM itab.
Insert text elements
- INSERT TEXTPOOL prog ...FROM itab ...LANGUAGE lg.
Update
1. UPDATE dbtab SET s1 ... sn.
2. UPDATE dbtab. or
UPDATE *dbtab. or
UPDATE (dbtabname) ... .
3. UPDATE dbtab FROM TABLE itab. or
UPDATE (dbtabname) FROM TABLE itab.
Modify
Change a database table
- MODIFY dbtab.
MODIFY *dbtab.
MODIFY (dbtabname) ... .
- MODIFY dbtab FROM TABLE itab.
MODIFY (dbtabname) FROM TABLE itab.
- MODIFY dbtab VERSION vers.
MODIFY *dbtab VERSION vers.
Change an internal table
- MODIFY itab [FROM wa] [INDEX idx].
Change a list line
- MODIFY LINE n.
- MODIFY LINE n OF CURRENT PAGE.
- MODIFY LINE n OF PAGE m.
- MODIFY CURRENT LINE.
Change the attributes of a screen field
- MODIFY SCREEN.