Hi,

Can anyone tell me the syntax of SET TABLE command. I am using IDS 9.3

The SET TABLE command is used to turn on the the resident state of one or more fragments of a table.

Regards,
Anu_R

SET TABLE tab1 MEMORY_RESIDENT
SET INDEX index1 (dbspace1, dbspace2) MEMORY_RESIDENT;
SET TABLE tab1 (dbspace1) NON_RESIDENT

Hi,
You can set eh residency in the follwoing manner-

SET TABLE abc RESIDENT

Specifies that all pages of the table named abc and its attached
index pages are to be resident.

SET TABLE abc RESIDENT on dbs1,dbs3

Specifies that only pages from the fragments in dbs1 and dbs3 are to be
resident. These pages will include both table and index pages for the
attached index.

SET TABLE abc RESIDENT WITH INDEX ALL

Specifies that the table and its detached indexes will be resident.

SET INDEX abcindex RESIDENT

Specifies that only the pages of the detached index abcindex will be
resident.

SET INDEX abc ON dbs3

Specifies that only the detached index fragment in dbs3 will be resident.

Note multiple SET commands may be used repeatedly on the same table or detached index. Note also that memory residency does not span the life of the server. This means that when IDS is restarted, memory residency must be reestablished for tables and indexes.