Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

START commands for the UDS/SQL programs

program run the system sets the job variable to the followingThe following table shows the START commands (and their aliases) that you can use to call the specified UDS/SQL programs

The following prerequisites must be fulfilled:

  • UDS/SQL must be installed with IMON and

  • the SDF system syntax file must be activated.

Program

START command

Alias

UDSSQL

START-UDS-DBH

UDS, SYSINT

BALTER

START-UDS-BALTER

BALTER

BCALLSI

START-UDS-BCALLSI

BCALLSI

BCHANGE

START-UDS-BCHANGE

BCHANGE

BRENAME

START-UDS-BRENAME

BRENAME

BCHECK

START-UDS-BCHECK

BCHECK

BCREATE

START-UDS-BCREATE

BCREATE

BFORMAT

START-UDS-BFORMAT

BFORMAT

BGSIA

START-UDS-BGSIA

BGSIA

BGSSIA

START-UDS-BGSSIA

BGSSIA

BINILOAD

START-UDS-BINILOAD

BINILOAD

BMEND

START-UDS-BMEND

BMEND, START-UDS-REPAIR

BMODTT

START-UDS-BMODTT

BMODTT

BOUTLOAD

START-UDS-BOUTLOAD

BOUTLOAD,
START-UDS-OUTLOAD

BPGSIZE

START-UDS-BPGSIZE

BPGSIZE,
START-UDS-PAGE-RESIZING

BPRECORD

START-UDS-BPRECORD

BPRECORD

BPRIVACY

START-UDS-BPRIVACY

BPRIVACY,
START-UDS-AUTHORIZATION

BPSIA

START-UDS-BPSIA

BPSIA

BPSQLSIA

START-UDS-BPSQLSIA

BPSQLSIA,
START-UDS-PRINT-SQLSIA

BREORG

START-UDS-BREORG

BREORG,
START-UDS-REORGANIZATION

BSTATUS

START-UDS-BSTATUS

BSTATUS

DDL

START-UDS-DDL

DDL

DMLTEST

START-UDS-DMLTEST

DMLTEST

SSL

START-UDS-SSL

SSL

ONLINE-PRIVACY

START-UDS-ONLINE-PRIVACY

OPRIVACY

UDSADM

START-UDS-ADM

UDSADM,
START-UDS-ADMINISTRATION

UDSMON

START-UDS-UDSMON

UDSMON

UDS online utility

START-UDS-ONLINE-UTILITY

ONLUTIL

Table 10: Calling UDS/SQL programs using START commands

Syntax of the START-UDS-... commands

START-UDS-...

VERSION = *STD / <product-version>


,MONJV = *NONE / <filename 1..54 without-gen-vers>


,CPU-LIMIT = *JOB-REST / <integer 1..32767 seconds>


,RESIDENT-PAGES = [*PAR AMETERS](...)

Only for DBH


[ *PARAMETERS](...)




|

MINIMUM = *STD / <integer 0..32767 4Kbyte>




|

,MAXIMUM = *STD / <integer 0..32767 4Kbyte>


VERSION =
Product version of the program which is to be started.

VERSION = *STD
No explicit specification of the product version. The product version is selected as follows:

  1. The version predefined with the /SELECT-PRODUCT-VERSION command.

  2. The highest version installed with IMON.

VERSION = <product-version>
Explicit specification of the product version in the form mm.n[a[kk]].

You are recommended always to specify the version in full, e.g. 02.9B00, in order to facilitate migration in the event of correction packages.

MONJV =
Specifies a monitor job variable to monitor the program run.

MONJV = *NONE
No monitor job variable is used.

MONJV = <filename 1..54 without-gen-vers>
Name of the job variable to be used.

During the program run the system sets the job variable to the following values:

$R

Program running

$T

 Program successfully terminated

$A

 Program terminated with error

CPU-LIMIT =
Maximum CPU time in seconds which the program may take to execute.

CPU-LIMIT = *JOB-REST
The remaining CPU time for the BS2000 job is to be used for the task.

CPU-LIMIT = <integer 1..32767 seconds >
Only the time specified should be used.

RESIDENT-PAGES = *PARAMETERS(...)
This operand is only permitted for the DBH.

Number of resident memory pages which are required for the DBH run. This operand must be specified if pages are to be made resident in the program by means of a CSTAT macro (see the "Executive Macros” manual). The permissible number of resident memory pages can be influenced by the operator.
If the operand is missing (this corresponds to MIN=*STD, MAX=*STD), the memory requests are taken from the first record in the program. The file must be open to do this.

MINIMUM = *STD / <integer 0..32767 4Kbyte >
Minimum number of resident memory pages required.

MAXIMUM = *STD / <integer 0..32767 4Kbyte >
Maximum number of resident memory pages required. 

UDS/SQL programs not installed with IMON

If UDS/SQL has not been installed with IMON, you must enter the following commands to start the UDS/SQL programs:

[/MODIFY-SDF-OPTIONS SYNTAX-FILE=$userid.SYSSDF.UDS-SQL.029.USER]

  /ADD-FILE-LINK LINK-NAME=DATABASE,FILE-NAME=dbname

  /ADD-FILE-LINK LINK-NAME=$UDSLIB,FILE-NAME=$userid.SYSLNK.UDS-SQL.029

  /START-EXECUTABLE-PROGRAM FROM-FILE=(LIB=$userid.SYSLNK.UDS-SQL.029

,ELEMENT=uds-utility)

You only need to specify the USER syntax file with the MODIFY-SDF-OPTIONS command if the system syntax file SYSSDF.UDS-SQL.029 is not active and if UDS/SQL programs are used with the SDF command interface, i.e. for

  • BMEND

  • BOUTLOAD

  • BPGSIZE

  • BPRIVACY and OPRIVACY

  • BPSQLSIA

  • BREORG

  • UDSADM

  • BTRANS24