tcl.z Verb: Access/SQL


Command tcl.z Verb: Access/SQL
Applicable release versions: AP
Category SQL (13)
Description starts a "phantom" jobs.
"phantom" jobs run in the background, meaning that they do not necessarily need a terminal present.

A phantom process is a process that is initiated at a terminal and detaches itself from that terminal for execution independent of that terminal. It is processed as a background task and the results are displayed on the initiating terminal when the process is complete.

The number of phantom processes that can be run is determined when the system is installed. In general, there is one phantom process available for every eight users plus one additional process.

After a phantom process is initiated, the user can use the terminal originating the phantom process for other jobs. The "dm,jobs," file tracks phantom processes. Phantom processes can be monitored with the "list-jobs" command.

"zh" and "zhs" hold all terminal output in a hold file.

"zs" and "zhs" suppress error messages. Otherwise, error messages are displayed on the terminal that initiated the phantom process.

"TCL command" specifies the TCL statement to be executed as the phantom process. If a TCL command is specified, no further prompting appears, and the job is submitted using all the default values from the following questions.

If a TCL command is not specified, it prompts for the following:

user id:
If specified, the user password is requested. Otherwise, it defaults to the current user-id. Passwords are case-sensitive.

md id:
If specified, the account password is requested. Otherwise, it defaults to the current master dictionary.

TCL command:
Specifies the (initial) TCL statement to execute by the phantom process.

Specifies the port number on which the process is to run. If not specified, a "phantom" line is used.

input data:
Designates input data to be stacked for use by the phantom process. Each separate string must be terminated by a <return>. A "null" response may be "stacked" by pressing "<ctrl>+n" followed by <return>. Pressing <return> at the "input data:" prompt indicates that all commands have been entered and the process is then released to the phantom scheduler.
Syntax z {TCL command}
zh {TCL command}
zhs {TCL command}
zs {TCL command}
user id (<cr>=bob):<return>
md id (<cr>=ref):<return>
command: compile bp process.see.also
(type ctrl-n<cr> to enter null data)
input data:<return>
[438] Job #882632715 Submitted.

This illustrates the "prompted" sequence. After the job completes, a 
message is transmitted to the sender, indicating that the job has completed:

09:05:18  29 Feb 1992 from user bob line 129
[241] Successful compile! 1 frame(s) used.

:z count entity
[438] Job #892243266 submitted.

This is the "unprompted" form.
Related tcl.logon