To permit version migration from UDS/SQL V2.0 up to and including V2.3 to a version V2.4 or higher the databases must be converted to Database Layout Version '004.00' using the BTRANS24 utility routine.
Databases which were last modified using UDS/SQL versions up to and including V2.3 must also be migrated to Database Layout Version '004.00' in this way before they are processed - for example for auditing purposes using UDS/SQL version V2.4 or higher. When migration takes place, the Realm Layout Version of all realms is converted to '004.00'.
The BTRANS24 utility routine is a component part of the UDS-SQL-T package and is by default contained in the SIPPRG.UDS-SQL-T.029 library.
The BTRANS24 utility routine provides two functions for migrating the DB Layout Version:
It checks prerequisites for database migration (see section "Checking the prerequisites for migration")
It transforms the databases (see section "Performing a database transformation with BTRANS24")
For a description of the BTRANS24 statements, see section "BTRANS24 statements".
For information on calling BTRANS24, see section "Calling BTRANS24".
The messages output by BTRANS24 can be found in the “Messages” manual.