CHANGE command use

The following two examples show two different ways of using of the CHANGE command.

Example 1—change table organization from Sequential to Hash

This change will be used to see whether Hash searching is more efficient than Binary searching. The table name is COUNTIES and it is on the tableBASE library identified by the DDNAME TESTLIB.

CHANGE LIB=TESTLIB TBL=COUNTIES ORG=H MTHD=H UCOMMENT=’Counties in NJ’;

Example 2—change the name of the Data Table

Change the name of the Data Table for the Alternate Index definition. DISTRICT.REGION is the new contents table name. The alternate table is in the tableBASE library identified by the DDNAME MAINLIB.

CHANGE ALT=DISTRICT BASENAME=REGION;