NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
I-28
Considerations—INVOKE
Considerations—INVOKE
•
Authorization requirements
To use the INVOKE statement on a table or view, you must have authority to read
the table or view at compile time.
•
Multibyte character sets
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 displayable on your output device.
Examples—INVOKE
•
The following 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 following SQLCI command generates a COBOL85-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.