NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
G-2
Examples—GET CATALOG OF SYSTEM
Examples—GET CATALOG OF SYSTEM
•
The following SQLCI example shows how GET CATALOG OF SYSTEM returns a
catalog name in an SQLCI session:
>>GET CATALOG OF SYSTEM \SYSA;
CATALOG: \SYSA.$SYSTEM.SQL
--- SQL operation complete.
•
The following static SQL statement from a C, Pascal, or TAL program retrieves the
system catalog name for \SYSA and stores it in hostvar1:
EXEC SQL GET CATALOG OF SYSTEM \SYSA INTO :hostvar1;
•
The following static SQL statement from a COBOL85 program retrieves the system
catalog name for the local system and stores it in HOSTVAR2:
EXEC SQL GET CATALOG OF SYSTEM INTO :HOSTVAR2 END-EXEC.
•
The following statements from a COBOL85 program use dynamic SQL to retrieve
the system catalog name for \SYSA and store it in a host variable, HOSTVAR3:
MOVE "GET CATALOG OF SYSTEM \SYSA " TO STRING1.
EXEC SQL PREPARE S1 FROM :STRING1 END-EXEC.
EXEC SQL EXECUTE S1 RETURNING :HOSTVAR3 END-EXEC.
•
The following statements from a COBOL85 program use dynamic SQL to retrieve
the system catalog name for \SYSA and store it in MYSQLDA, an output SQLDA:
MOVE "GET CATALOG OF SYSTEM \SYSA " TO STRING2.
EXEC SQL PREPARE S2 FROM :STRING2 END-EXEC.
EXEC SQL EXECUTE S2 RETURNING USING DESCRIPTOR :MYSQLDA
END-EXEC.
GET VERSION Statement
GET VERSION is a DSL statement that returns the version of an SQL catalog or object
or the version of the NonStop SQL/MP software on a node.
{ { CATALOG } s }
{ { COLLATION } }
{ { INDEX } name }
GET VERSION OF { { TABLE } } [ INTO :var ]
{ { VIEW } }
{ }
{ SYSTEM [ name ] }