Operation of CLI2SCI - IBM IMS/DC Interface for Teradata

IBM IMS/DC Interface for Teradata® Reference

Product
IBM IMS/DC Interface for Teradata
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2018-10-10
dita:mapPath
mzs1527114222327.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2447
lifecycle
previous
Product Category
Teradata Tools and Utilities

This program initiates the following set of requests in sequence.

Each request is a separate transaction.

  1. DROP TABLE T;
  2. CREATE TABLE T (I INT,I2 SMALLINT);
  3. USING V (INTEGER),V2(SMALLINT)INS INTO T VALUES(:V,:V2);
  4. UPDATE T SET I2 = I + 1;
  5. SEL SUM(I) FROM T;

Data values are generated by the program. The data generated for the INSERT statement are the integers 1,2,...MAXROWS for the fields I and I2 (equal values are inserted for the fields I and I2). MAXROWS can be adjusted to set the total number of rows inserted.