Command sequence to start BALTER

It is assumed for the command sequences described here that UDS/SQL was installed with IMON (see section "START commands for the UDS/SQL programs").

The following commands are used under the identification in which the database is cataloged to initiate the BALTER analysis and restructuring phases (you can also start the program using the alias BALTER):

Analysis phase

01 /ADD-FILE-LINK LINK-NAME=DATABASE,FILE-NAME=dbname.DBDIR

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

03 /START-UDS-BALTER

04 EXECUTION IS NO.

05 REPORT IS YES.

06 END.

Restructuring phase

01   /ADD-FILE-LINK LINK-NAME=DATABASE,FILE-NAME=dbname.DBDIR

02   [/CREATE-FILE FILE-NAME=work-file-1 ...
      /ADD-FILE-LINK LINK-NAME=SCRTCH1,FILE-NAME=work-file-1
          ,ACCESS-METHOD=*UPAM]

03   [/CREATE-FILE FILE-NAME=work-file-2 ...
      /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-BALTER

06   [SORTCORE IS nnn.]

07   [FILL itemname OF recordname WITH value.]

08   [FILLING IS nnn PERCENT
        [ IN SET NAME IS {setname,... | *ALL [ EXCEPT setname,..]}].]

09   [FILLING WITH POPULATION
        [ IN SET NAME IS {setname,... | *ALL [ EXCEPT setname,..]}].]

10   EXECUTION IS YES.

11   REPORT IS {YES | NO}.

12   END