Format:
Calling LOAD (general format)
xload
The options -u, -U, -d, and -n required for the connect are described in Section Establishing a Database Session, the options -V and -h in Section General Information.
After the connect, the user is in input mode where the LOAD commands can then be entered.
Specifying a TIMEOUT Value
The SESSION TIMEOUT value determines the time interval at the end of which the session will be terminated if it was not active. The database administrator can determine this value for the whole database using CONTROL or for a single user on his creation (default: 300 seconds). The option -t allows the user to specify a smaller value in seconds. A value larger than predefined produces an error message.
xload -t 90
The database session started with this call is terminated after 90 seconds of inactivity.
Specifying an SQLMODE
The option -S can be used to specify the SQLMODE desired for the call. If the option is not used, LOAD works in the default mode ADABAS.
xload -S ORACLE
Specifying a Command With a Call
In LOAD, command files can be started interactively or in batch mode. Calls are for the
1) interactive mode:
xload -u parker,secret -d testdb -r filename
LOAD executes the statements of the command file and then displays the input screen. If '-P' (PROMPT) was not specified, LOAD executes the indicated command file in NOPROMPT mode.
2) batch mode:
xload -u parker,secret -d testdb -b filename
In this case, LOAD suppresses any screen interaction and terminates after execution.
To execute the command file in a new window (as a background process), specify the corresponding Windows NT command (START):
start /min xload -b filename
3) execution with parameter transfer
xload -r filename 21.00 Mayr
xload -b filename 21.00 Mayr
In this example, the values '21.00' and 'Mayr' are assigned to the formal parameters of the command file 'filename'.
The blank has the effect of a separator between two parameters.
All of these call formats can also be used from a Windows NT command file.