|
Command |
Authorization |
Function |
|---|---|---|
|
ADDIT |
INSERT |
Add Record |
|
CNTFL/CNTTB |
SELECT |
Count for Table |
|
CNTKR |
SELECT |
Count for Key Value Range |
|
CNTKY |
SELECT |
Count for Equal Key Value |
|
DELET |
DELETE |
Delete Record |
|
GETIT |
SELECT |
Retrieve Next Sequential Record |
|
GETPS |
SELECT |
Get Next Physical Sequential Record |
|
GSETL |
SELECT |
Set to Starting Key Value |
|
GSETP |
SELECT |
Set Physical Sequential Record Processing |
|
LOCBR |
SELECT |
Locate Backwards |
|
LOCKG |
SELECT |
Locate Key Equal or Higher |
|
LOCKI |
SELECT |
Test for Logical Intersections of Two Keys |
|
LOCKL |
SELECT |
Locate Key Value Equal or Lower |
|
LOCKR |
SELECT |
Locate a Record in a Specified Range |
|
LOCKX |
SELECT |
Locate Key Value Exact |
|
LOCKY |
SELECT |
Locate Key Value Equal or Higher |
|
LOCNE |
SELECT |
Locate Next Equal Key Value |
|
LOCNK |
SELECT |
Locate Next Key Value |
|
LOCNR |
SELECT |
Locate Next Record in Specified Range |
|
LOCNX |
SELECT |
Locate Next |
|
REDBR/RDUBR |
SELECT |
Read Backwards |
|
REDID/RDUID |
SELECT |
Read Record by ID |
|
REDKG/RDUKG |
SELECT |
Read Record Greater Than or Equal to Key |
|
REDKL/RDUKL |
SELECT |
Read Key Less Than or Equal to Key |
|
REDKR/RDUKR |
SELECT |
Read Record in a Specified Range |
|
REDKX/RDUKX |
SELECT |
Read Key Exact |
|
REDKY/RDUKY |
SELECT |
Read Key Exact |
|
REDLE/RDULE |
SELECT |
Read Located Entry |
|
REDNE/RDUNE |
SELECT |
Read Next Equal Key Value |
|
REDNK/RDUNK |
SELECT |
Read Record with the Next Sequential Key Value |
|
REDNR/RDUNR |
SELECT |
Read the Next Record in a Specified Range |
|
REDNX/RDUNX |
SELECT |
Read Next |
|
SELCN |
SELECT |
Continue Set Record Selection |
|
SELFR |
SELECT |
Select Set - Return First Record |
|
SELNR |
SELECT |
Select Next Record |
|
SELPR |
SELECT |
Release Set |
|
SELSM |
SELECT |
Select Same Record |
|
SELST |
SELECT |
Stop Set Record Selection |
|
UPDAT |
UPDATE |
Update Record |
|
Copyright © 2014 CA.
All rights reserved.
|
|