Resource Specification

The resource specification is used by the Query Processor to create a logical connection between a client application and the physical data source. The resource you specify is a logical identifier for the data source. A resource maps a data source identifier to one or more physical databases.

When an application using the Query Processor software attaches to a resource, the system automatically routes instructions and data between the client application and the physical data source or sources to which the resource is mapped. Whether a resource is mapped to one or several physical data sources is transparent to the user of the client application.

The following diagrams illustrate the syntax for configuring system resources:

<resource specification>

── RESOURCE <resource identifier> ── = ─┬─────────────────────┬────────►  
                                        └─ <CCS clause> ── , ─┘
  ┌►──────────── , ───────────┐
►─┴─ /5*\ ── <database list> ─┴────────────────────────────────────────┤

<CCS clause>

── CCS ──<coded character set name or library ccsnumber>───────────────┤

<database list>

──┬─ <database name> ──────────┬─┬──────────┬──────────────────────────┤
  └─ <logical database title> ─┘ └─ <mode> ─┘

<logical database title>

── <logical database name> ── OF ─┬─ <database name> ──┬───────────────┤
                                  └─ <database title> ─┘

<database title>

──┬─ * ───────────┬─ <database name> ON <family name> ─────────────────┤
  └─ <user code> ─┘

<mode>

── ( ── MODE ─┬─ INQUIRY ─┬─ ) ────────────────────────────────────────┤
              └─ UPDATE ──┘

The following table explains the elements of the syntax diagrams.

Element

Definition

<resource identifier>

Identifies the resource. The resource identifier must be 1 to 18 letters, numbers, underscores (_), or hyphens (-). The first character must be a letter or a number, and the last character must not be an underscore or a hyphen. SHIPPING is an example.

<CCS clause>

Specifies the coded character set used by the Query Processor server to map data characters between the workstation and the data source.

Refer to Using the CCS Clause later in this section for additional information.

<coded character set name or library ccsnumber>

Specifies the coded character set name or number.

For a detailed explanation and listing of coded character sets, refer to the MultiLingual System Administration, Operations, and Programming Guide.

<database list>

Associates databases with the resource identifier. At most, five databases can be associated with one logical resource.

<database name>

Identifies the database name. The database name is an identifier containing from 1 to 17 letters, numbers, or hyphens. The first character must be a letter. The last character cannot be a hyphen.

<database title>

Specifies the name of the database and location of the database control file. (ACCOUNTDB)PAYROLL ON PAYPACK is an example.

<logical database title>

Specifies the name of the logical database and location of the logical database control file. RESOURCE LDB1 = LDB1 OF (DEV)TESTDB ON PRODUCTION (MODE UPDATE) is an example.

<mode>

Indicates the way in which the specified database is to be accessed. The access mode defaults to INQUIRY if no mode is specified.

Prev  Up  Next
Default Release Specification  Home  Using the CCS Clause