SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
I-28
Considerations—INVOKE
Considerations—INVOKE

To use the INVOKE statement on a table or view, you must have authority to read
the table or view at compile time.

Multibyte characters can be displayed only on output devices that support them. If
a record definition contains a DEFAULT clause with a multibyte character, the
output might not be displayed on your output device.
Examples—INVOKE

This SQLCI command generates an SQL-format description of a table named
EMPLOYEE:
>> INVOKE $VOL1.PERSNL.EMPLOYEE FORMAT SQL;
-- Definition of table \SYS1.$VOL1.PERSNL.EMPLOYEE
-- Definition current at 10:43:27 - 03/01/94
(
EMPNUM NUMERIC( 4, 0 ) UNSIGNED NOT NULL
, FIRST_NAME CHAR( 15 ) NOT NULL
, LAST_NAME CHAR ( 20 ) NOT NULL
, DEPTNUM NUMERIC( 4, 0 ) UNSIGNED NOT NULL
, JOBCODE NUMERIC( 4, 0 ) UNSIGNED
, SALARY NUMERIC( 8, 2 ) UNSIGNED
)

The next SQLCI command generates a COBOL-format record named EMP that
corresponds to a table named EMPLOYEE. SQLCI appends the record description
to an EDIT file name COBLIB in a section named EMPSEC and displays the
record description on the OUT file as well.
Compare the record description in the example to the SQL-format record
description in the last example and notice the indicator variables for JOBCODE-I
and SALARY-I that are included in the COBOL format but not in the SQL format.
>> INVOKE $VOL1.PERSNL.EMPLOYEE AS EMP FORMAT COBOL
+> TO COBLIB (EMPSEC);
?SECTION EMPSEC
* Definition of table \SYS1.$VOL1.PERSNL.EMPLOYEE
* Definition current at 10:50:32 - 03/01/94
01 EMP.
02 EMPNUM PIC 9(4) COMP.
02 FIRST_NAME PIC X(15)
02 LAST_NAME PIC X(20)
02 DEPTNUM PIC 9(4) COMP.
02 JOBCODE-I PIC S9(4) COMP.
02 JOBCODE PIC 9(4) COMP.
02 SALARY-I PIC S9(4) COMP.
02 SALARY PIC 9(6)V9(2) COMP.