Supported SQL Data Manipulation for PRO/5 File Types

SQL Data Manipulation commands are provided for the following PRO/5 file types:

File Type

Insert

Update

Delete

Select

C-ISAM

Yes

Yes

Yes

Yes

DIRECT

Yes

Yes

Yes

Yes

DIRECTORY

No

No

No

Yes

INDEXED

No

No

No

Yes

MKEYED

Yes

Yes

Yes

Yes

PROGRAM

No

No

No

No

SERIAL

No

No

No

Yes

SORT

Yes

No

Yes

Yes

STRING

No

No

No

Yes