Previous Topic: Data Control Language (DCL) OperationsNext Topic: Plan Security


CA Datacom/DB Commands and SQL Security Access Rights

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