OUTPUT Parameter

Accessing SQL Defined Tables › OUTPUT Parameter

OUTPUT Parameter

More information:

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

Syntax

      Col
      2
      ▼
►►─── nnOUTput ──┬─ T ───┬── SQLTABLE = table-name ───────────────────────────►
                 └─ D ◄ ─┘

 ►─── TYPE = ─┬─ CREATE ──┬──┬─────────────────┬──────────────────────────────►
              ├─ ADD ─────┤  └─ CASCADE = YES ─┘
              ├─ REPLACE ─┤
              └─ DELETE ──┘
 ►───┬──────────────────────────┬───┬────────────────────────┬────────────────►
     └─ DICTIONARY = dict-name ─┘   └─ SCHEMA = schema-name ─┘

 ►───┬────────────────────┬───┬──────────────────────────────┬────────────────►
     └─ SQL = sql-option ─┘   └─ BULKROWS = rows-per-buffer ─┘

 ►───┬─────────────────────────────┬──────────────────────────────────────────►◄
     └─ SQLCOMMIT = ──┬─ NO ◄ ─────┤
                      └─ interval ─┘

Syntax Rules

nnOUTput

Defines the OUTPUT specifications for report number nn. The report number must begin in column 2.

T / D

T specifies that totals-only are written to the output table.

D indicates that details-only are written to the output table. Details-only is the default.

SQLTABLE= table-name

Specifies the name of the SQL table to be modified. The table name can be up to 18 characters long, and single quotes are optional.

TYPE=

CA Culprit can perform the following functions for output SQL tables:

Option	What it does
CREATE	Issues create table SQL syntax and inserts new rows.
ADD	Validates an existing SQL table, and inserts additional rows.
REPLACE	Validates an existing SQL table, deletes all existing rows from the table, and then inserts new rows.
DROP	Issues SQL drop table syntax to delete a table definition and all of its rows.

CASCADE= YES

This keyword only applies to the TYPE=DROP function. It directs the database to also delete the definitions of all referential constraints and all views derived from the named 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.

When creating new SQL tables using CA Culprit, you must specify a schema that has been previously defined to the SQL dictionary and has a default area for storing data rows.

BULKROWS=

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

SQLCOMMIT =

Specifies the interval at which SQL COMMIT statements are issued when a table is updated.

NO

(Default) Indicates that no COMMIT statements are to be issued until all rows are updated.

interval

An integer that specifies the interval at which COMMITs are to be issued.

COMMIT statements are issued when CREATE, ADD, or REPLACE stores the specified number of rows and after all rows for a table have been stored.

Note: If the SQLCOMMIT parameter is set lower than the BULKROWS parameter, the COMMIT is issued after "BULKROWS" number of records have been stored. For more information about COMMIT statements, see the CA IDMS SQL Programming Guide.