HP NonStop G-Series Betriebsanweisung PDF herunterladen (Seite 77)

SQL/MX Connectivity Service Administrative Command Reference—526350-005

6-1

6 Object EVAR Commands

This section describes the MXCS administrative commands to use for the object EVAR

(see Valid Command and Object Type Pairs on page 2-3):



EVAR Types on page 6-1



EVAR Order on page 6-2



ADD EVAR on page 6-3



ALTER EVAR on page 6-6



DELETE EVAR on page 6-9



INFO EVAR on page 6-11

EVAR Types

The EVAR object defines NonStop OS or SQL environment variables and provides

commands to manage them. The server environment uses these variables to define

various aspects of queries, usually substitution variables or SQL operational

parameters. These variables affect operations after the client has connected to the

MXCS server.

An EVAR has three main components: type, name, and value. Each DS has its own

collection of EVARs. EVARs are not shared among DSs.

In these examples of different types of EVARs, the uppercase text example is

displayed by the INFO command and is stored in the database after the input

command is parsed and defaults added:

CONTROL QUERY DEFAULT QUERY_CACHE_STATISTICS 'OFF' (control type example)

ADD DEFINE =KEVIN_TABLE, FILE $DATA02.KEVIN2.KTABLE (define type example)

SET NAMETYPE ANSI (set type example

This list indicates the supported types and the default prefix:

Note. Single quotes delimiting ‘OFF’ are required.

all No default prefix

control CONTROL QUERY DEFAULT

define ADD DEFINE

rmp Not applicable

set SET

1 2 ... 72 73 74 75 76 77 78 79 80 81 82 ... 102 103

Keine Kommentare

HP NonStop G-Series Betriebsanweisung Seite 77