System environment

Figure 11: BPSQLSIA system environment

BPSQLSIA can be run in parallel with database operations and is restartable.

If you are working with the DATABASE application area, you can call BPSQLSIA with the BS2000 command START-UDS-PRINT-SQLSIA or the alias BPSQLSIA.

The UDS/SQL user syntax file sets the SDF user prompting mode to EXPERT. You can change the user prompting with the command:

MODIFY-SDF-OPTIONS GUIDANCE=*EXPERT/*NO/*MAXIMUM/*MEDIUM/*MINIMUM

At startup BPSQLSIA takes into account any assigned UDS/SQL pubset declaration (see the “Database Operation” manual, Pubset declaration job variable). Faulty assignment leads to the program aborting.