Database Operations

In non-Unicode programs, the following statements transfer the data to the field wa or the table line itab according to the structure of the table work area dbtab without considering the structure of the field or line. Only the length and the alignment are checked.

SELECT * FROM dbtab ... INTO wa ...
SELECT * FROM dbtab ... INTO TABLE itab  ...
SELECT * FROM dbtab ... APPENDING TABLE itab ...

FETCH NEXT CURSOR c ... INTO wa.
FETCH NEXT CURSOR c ... INTO TABLE itab.
FETCH NEXT CURSOR c ... APPENDING TABLE itab.

INSERT INTO dbtab ... FROM wa.
INSERT dbtab ... FROM wa.
INSERT dbtab ... FROM TABLE itab.

UPDATE dbtab ... FROM wa.
UPDATE dbtab ... FROM TABLE itab.

MODIFY dbtab ... FROM wa.
MODIFY dbtab ... FROM TABLE itab.

DELETE dbtab FROM wa.
DELETE dbtab FROM TABLE itab.

In Unicode programs the following rules apply:

• If the work area or the line of the internal table is a structure, the system also checks whether the fragment views of the work area and the database table are identical with regard to the length of the database table.

• If the work area is a single field, the field must be character-type and the database table purely character-type. These requirements are valid for all statements listed above.