Adapting incompatible subschemas

For all subschemas which, in their original form, are not compatible with the new schema, it is necessary to do the following:

• correct the subschema description if required

• recompile the corrected subschema with the DDL compiler

• generate a new SSIA using BGSSIA and enter it in the DBDIR

• recompile and relink all relevant application programs.

It is assumed for the command sequence described here that UDS/SQL was installed with IMON (see section "START commands for the UDS/SQL programs". The aliases for calling the utility routines are also listed in this section).

Command sequence for adapting the subschemas

Compiling the corrected subschema (see section "Compiling the Schema DDL")

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-DDL

04 [DELETE 'subschema-name':'new schema-name']

05 SOURCE IS 'subschema-file'

06 SORCLIST IS YES

07 END

08 /ASSIGN-SYSDTA TO=*SYSCMD

02	The version-independent module of the linked-in DBH of the relevant version is loaded dynamically (see the section entitled "Compiling, linking and loading UDS/SQL-TIAM application programs" in the "Application Programming" manual).
03	The UDS/SQL utility routine can also be started using the alias DDL.
04	The DELETE statement should be specified only if a subschema recognized as compatible and copied by the DDL compiler has been modified and requires recompilation.

Generating the SSIA and entering it in the DBDIR

See section "Generating the Subschema Information Area (SSIA) with BGSSIA".

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-BGSSIA

04 GENERATE SUBSCHEMA subschema-name OF SCHEMA schema-name

05 [DISPLAY[ SUBSCHEMA subschema-name OF SCHEMA schema-name]]

06 END