SQL/MX 2.x Reference Manual (H06.04+)

MXCI Commands

HP NonStop SQL/MX Reference Manual—540440-003

4-33

INVOKE Command

Examples of INVOKE

The INVOKE command generates a record description that corresponds to a row in the

specified table or view. The record description includes a data item for each column in

the table or view except the SYSKEY column; it includes the SYSKEY column of a

view only if the view explicitly listed the column in its definition.

You can use this version of INVOKE only within an MXCI session.

table

names the table or view for which to generate a record description.

Examples of INVOKE

•

Generate a record description of table EMPLOYEE:

INVOKE EMPLOYEE;

-- Definition of table EMPLOYEE

-- Definition current Mon Apr 24 16:03:04 2000

(

EMPNUM NUMERIC(4, 0) UNSIGNED NO DEFAULT

HEADING 'Employee/Number' NOT NULL NOT DROPPABLE

, FIRST_NAME CHAR(15) CHARACTER SET ISO88591 COLLATE

DEFAULT DEFAULT ' '

HEADING 'First Name' NOT NULL NOT DROPPABLE

, LAST_NAME CHAR(20) CHARACTER SET ISO88591 COLLATE

DEFAULT DEFAULT ' '

HEADING 'Last Name' NOT NULL NOT DROPPABLE

, DEPTNUM NUMERIC(4, 0) UNSIGNED NO DEFAULT

HEADING 'Dept/Num' NOT NULL NOT DROPPABLE

, JOBCODE NUMERIC(4, 0) UNSIGNED DEFAULT NULL

HEADING 'Job/Code'

, SALARY NUMERIC(8, 2) UNSIGNED DEFAULT NULL

HEADING 'Salary'

)

--- SQL operation complete.

INVOKE table