CA IDMS Reference 19.0

PDF
English

OUTPUT Parameter with Accessing SQL Defined Tables

The OUTPUT parameter describes the output medium as a CA IDMS/DB SQL table. It also identifies the SQL dictionary and schema name.
idmscu19
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
      ▼
►►─── 
nn
OUTput ──┬─ 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
  • nn
    OUTput
    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.
    If the SQLCOMMIT parameter is set lower than the BULKROWS parameter, the COMMIT is issued after "BULKROWS" number of records have been stored.