SQL/MP Programming Manual for COBOL

Program Execution
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
7-7
Pathway Environment
Pathway Environment
In a Pathway environment, an SQL program running as a server process can run at an
available high PIN if these conditions are met:

The SQL program was written (or converted) to run at a high PIN.

The HIGHPIN server attribute for the SQL program in the Pathway
configuration file is ON.

The HIGHPIN object-file attribute in the SQL program file is ON.

A high PIN is available when the server runs.
If a Pathway server must run at a low PIN, use either of these methods:

In the SQL program file, set the HIGHPIN object-file attribute to OFF by using the
Binder CHANGE command as previously described under “Interactive
Commands.”

In the Pathway configuration file, set the HIGHPIN server attribute to OFF by using
the SET SERVER or ALTER SERVER command. (The default for the HIGHPIN
server attribute is OFF.)
Determining Compatibility With the
SQL Executor
The PFV of an SQL program indicates the oldest version of the SQL executor that can
execute the program. During SQL compilation, the SQL compiler writes the PFV in the
program’s file label. Then, at run time, the SQL executor checks the PFV, and if the
executor version is the same as or later than the program’s PFV, it executes the
program. Otherwise, the executor returns an error.
To determine the version of the SQL executor, use the GET VERSION OF SYSTEM
statement (all NonStop SQL/MP components on a system, including the executor,
must have the same version). You can execute the GET VERSION OF SYSTEM
statement from SQLCI or embedded in a COBOL program.
For a static embedded GET VERSION OF SYSTEM statement, include the INTO
clause with a host variable:
EXEC SQL
GET VERSION OF SYSTEM \NEWYORK INTO :HV-SYSTEM-VERSION
END-EXEC.
In this example, the statement returns the SQL/MP software version on the
\NEWYORK system to the HV-SYSTEM-VERSION host variable. If you do not specify
a system name, the statement returns the version of the local system.
To determine the PFV of an SQL program, use a FUP INFO or SQLCI FILEINFO
command with the DETAIL option. For programs registered in version 300 (or later)
catalogs, you can also query the PROGRAMS.PROGRAMFORMATVERSION column.