HP NonStop SQL/MP

Program Execution
HP NonStop SQL/MP Programming Manual for C—429847-008
7-5
Interactive Commands
If an SQL program was written (or converted) to run at a high PIN, you usually want the
program to run at a high PIN because more high PINs are available, and it frees the
low PINs for processes that cannot run at a high PIN. In some cases, however, you
might need to run a program at a low PIN. For example, in a mixed network of C-series
and D-series nodes, a program must run at a low PIN on a D-series node to:

Communicate with a process on a C-series node

Access a file or an SQL object on a C-series node
If you run an SQL program remotely on a D-series node from a C-series node, the SQL
program automatically runs at a low PIN. If you run an SQL program locally on a
D-series node, you can force the program to run at a low PIN interactively from a TACL
process or programmatically from an application process. In a Pathway environment,
you can also force a server process to run at a low PIN.
Interactive Commands
To interactively force an SQL program to run at a low PIN, use either of these methods:

Before you run the SQL program, set the HIGHPIN object-file attribute to OFF in
the SQL program file using the Binder CHANGE command:
@CHANGE HIGHPIN OFF IN sqlprog
To change an object-file attribute in a program file, you must have read and write
access to the program file. For a description of the Binder CHANGE command,
see the Binder Manual.

If you have not set the HIGHPIN object-file attribute to OFF (or cannot set it
because of the file security), specify the HIGHPIN OFF run option in the
TACL RUN command:
RUN sqlprog / HIGHPIN OFF, ... /
Programmatic Commands
If you are starting the program programmatically, call the PROCESS_CREATE_
procedure with bit 15 of the create-options parameter set to 1:
#include <cextdecs(PROCESS_CREATE_, ...)>
...
error := PROCESS_CREATE_(program_file:length,
...
create_options); /* Bit 15=1 */
(You can also use the NEWPROCESS or NEWPROCESSNOWAIT procedure, which
always forces a new process to run at a low PIN.)