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

DIRECT

No

Yes

Yes

Yes

DIRECTORY

No

No

No

No

INDEXED

No

Yes

No

Yes

MKEYED

Yes

Yes

Yes

Yes

PROGRAM

No

No

No

No

SERIAL

No

No

No

Yes

SORT

No

No

Yes

No

STRING

No

No

No

No

XKEYED

Yes

Yes

Yes

Yes