SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
G-5
Examples—GET VERSION OF PROGRAM
GET VERSION OF PROGRAM also sets SQLCODE to report status and fills in the
SQLCA. GET VERSION OF PROGRAM has no EXPLAIN output.
Examples—GET VERSION OF PROGRAM

This SQLCI example retrieves the PCV, PFV, and HOSV of program MYPROG:
>>GET CATALOG VERSION OF PROGRAM myprog;
VERSION: 315
--- SQL operation complete.
>>GET FORMAT VERSION OF PROGRAM myprog;
VERSION: 315
--- SQL operation complete.
>>GET HOST OBJECT VERSION OF PROGRAM myprog;
VERSION: 315
--- SQL operation complete.
>>

This static SQL statement from a C, Pascal, or TAL program retrieves the PCV of
program MYPROG and stores it in hostvar1:
EXEC SQL GET CATALOG VERSION OF PROGRAM myprog
INTO :hostvar1;

This static SQL statement from a COBOL program retrieves the HOSV of the
program MYPROG and stores it in HOSTVAR2:
EXEC SQL GET HOST OBJECT VERSION OF PROGRAM MYPROG
INTO :HOSTVAR2 END-EXEC.

This COBOL example uses dynamic SQL to retrieve the PCV of the program
MYPROG and store it in HOSTVAR3:
MOVE "GET CATALOG VERSION OF PROGRAM MYPROG " TO STRING1.
EXEC SQL PREPARE s1 FROM :STRING1 END-EXEC.
EXEC SQL EXECUTE s1 RETURNING :HOSTVAR3 END-EXEC.

This C example uses dynamic SQL to retrieve the HOSV of the program MYPROG
and store it in an output SQLDA:
string2 = "GET HOST OBJECT VERSION OF PROGRAM MYPROG ";
EXEC SQL PREPARE s2 FROM :string2;
EXEC SQL EXECUTE s2 RETURNING USING DESCRIPTOR :mysqlda;