SQL/MP Programming Manual for COBOL

Program Execution
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
7-6
Interactive Commands
The information about D-series nodes also applies to G-series nodes. 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. If necessary, 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 on a D-series node, use
either of these methods:

Before you run the SQL program, set the HIGHPIN object-file attribute to OFF in
the SQL program file by 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 a COBOL creator program must create an SQL program programmatically at a low
PIN on a D-series node, consider these situations:

The COBOL creator program was not written (or converted) to use the Common
Run-Time Environment (CRE), or the COBOL creator uses the CRE but was
compiled with the ENV OLD compiler directive.
The SQL program runs at a low PIN by default, even if it was written (or converted)
to run at a high PIN.

The COBOL creator program was written (or converted) to run at a high PIN and to
create a high PIN process. The SQL program was also written (or converted) to
run at a high PIN.
A high-PIN COBOL creator program that uses the CRE automatically creates a
new process at a high PIN. Therefore, for the COBOL program to create the SQL
program at a low PIN, you must set the HIGHPIN object-file attribute to OFF in the
SQL program file by using the Binder CHANGE command as previously described
under Interactive Commands on page 7-6.