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 |