Command sequence to start BREORG

The command sequence described here is based on the assumption that UDS/SQL was installed with IMON (see the section “START commands of the UDS/SQL programs” in chapter 2 of the “Creation and Restructuring“ manual).

01 [/ADD-FILE-LINK LINK-NAME=DATABASE,

              FILE-NAME=[:catid:][$userid.]dbname.DBDIR)]

02 [/CREATE-FILE FILE-NAME=work-file-1[,SUPPORT=*PUBLIC-DISK

              (SPACE=*RELATIVE(PRIMARY-ALLOCATION=primary,
              SECONDARY-ALLOCATION=secondary))/

              ,SUPPORT=*PRIVATE-DISK(VOLUME=priv-vsn,

              DEVICE-TYPE=device[,SPACE=...])]
   /ADD-FILE-LINK LINK-NAME=SCRTCH1,FILE-NAME=work-file-1,

              ACCESS-METHOD=*UPAM]

03 [/CREATE-FILE FILE-NAME=work-file-2[,SUPPORT=*PUBLIC-DISK
              (SPACE=*RELATIVE(PRIMARY-ALLOCATION=primary,

              SECONDARY-ALLOCATION=secondary))/

              ,SUPPORT=*PRIVATE-DISK(VOLUME=priv-vsn,

              DEVICE-TYPE=device[,SPACE=...])]
   /ADD-FILE-LINK LINK-NAME=SORTWK,FILE-NAME=work-file-2,

              ACCESS-METHOD=*UPAM]

04 /SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL,VERSION=version.SCOPE=*TASK

05 /START-UDS-BREORG

06 [//ALLOCATE-BUFFERPOOL BUFFER-SIZE = ...]

07 [//OPEN-DATABASE DATABASE-NAME = ...]

08 [//SPECIFY-SCHEMA SCHEMA-NAME = ...]

09 [//SPECIFY-SUBSCHEMA SUBSCHEMA-NAME = ...]

10 ... Further statements of BREORG

11 //END

01, 07	You must specify one of the two statements.
02, 03	These CREATE-FILE commands can be used to create work files for the REORGANIZE-SET or REORGANIZE-CALC function (see "Work files"). By analogy, you can optionally create the work files for the REORGANIZE-POINTERS statement (see "Work files")
04	The version of the utility routine is selected. Specification of the version is generally recommended, since several UDS/SQL versions can be installed in parallel.
05	BREORG can be called from any user ID. The UDS/SQL utility routine can also be started with the alias BREORG or START-UDS-REORGANIZATION.
08	The SPECIFY-SCHEMA statement is only offered if a command /ADD-FILE-LINK..., LINK-NAME=DATABASE was issued earlier.
09	Only required for the REORGANIZE-SET function when creating new multi-level LIST sets with user-defined keys (i.e. SORTED INDEXED BY DEFINED KEYS).