SQL Concepts and Language Elements › SQL Dataviews › Extension to INTO and VALUES Clauses

Extension to INTO and VALUES Clauses

CA Ideal PDL supports the following extension to the SQL INTO and VALUES clauses.

You can move data into PDL group data items using FETCH and SELECT statements and from PDL group data items to tables or views using the INSERT statement through the BY POSITION option.

The extension has the following format:

INTO host‑structure [BY POSITION]
VALUES host‑structure [BY POSITION]

host‑structure

A PDL group identifier.

BY POSITION

Moves data between each elementary field in the PDL group and each column in the currently accessed row. The structures must be compatible as defined for the BY POSITION option of the PDL MOVE statement. That is, you cannot define a group referenced in an INTO clause with an OCCURs attribute, nor can you redefine any of its subordinate fields. These groups can, however, contain subordinate groups. The data types must be compatible and conform to SQL requirements.

If you do not specify BY POSITION, you cannot specify a non‑alpha group. An alpha group is treated as an elementary alpha field.

Also, you can use the COPY DATAVIEW clause with a Working Data fill‑in to automatically create an image of an SQL dataview in a group item.