Accessing SQL Defined Tables › INPUT Parameter

INPUT Parameter

More information:

INPUT Parameter

Purpose

The INPUT parameter describes the input medium as a CA IDMS/DB SQL table. It also identifies the SQL dictionary and schema name.

Syntax

      Col
      2
      ▼
►►─── INput DB(Q) ─── rec-size ─── SQL = ─┬─ ANSI ───┬────────────────────────►
                                          ├─ FIPS ───┤
                                          ├─ SAA ────┤
                                          └─ CA-X ◄ ─┘

 ►─┬──────────────────────────┬── SCHEMA = default-schema-name ───────────────►◄
   └─ DICTIONARY = dict-name ─┘

Syntax Rules

INput DB(Q)

Identifies this parameter as an INPUT statement.

rec-size

Allocates storage for the CA Culprit input buffer. If omitted, CA Culprit allocates the larger of 1000 bytes or the row length as determined by the SQL descriptor area.

DB(Q)

Identifies the source of input as a CA IDMS/DB SQL table.

DICTIONARY=

Specifies the name of the SQL dictionary. The name can be up to eight characters. Single quotes are optional.

SCHEMA=

Specifies the name of the default schema for this session. The name can be up to 18 characters. Single quotes are optional.

SQL=

Identifies the dialect of SQL that the SELECT clause is written in. Valid SQL options include CAX, ANSI, FIPS, and SAA. CAX is the default and represents compliance with CA IDMS/DB Extended SQL.

BULKROWS=

Determines the number of rows retrieved during each bulk fetch operation. For greater performance, try increasing this value. If omitted, CA Culprit builds a fetch buffer for 100 rows of data.