Operation of CLI2MCI - IBM IMS/DC Interface for Teradata

IBM IMS/DC Interface for Teradata Reference

Product
IBM IMS/DC Interface for Teradata
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
jah1488824663543.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2447
lifecycle
previous
Product Category
Teradata Tools and Utilities

This program initiates the following multi-statement request “MAXTRANS” times:

MAXTRANS is a program constant that specifies the number of transactions to be initiated for each iteration of the conversation.
USING V1 (INT),V2 (INT),V3 (INT),V4 (INT),V5 (INT)
   INSERT INTO MYTABLE2 (F1) VALUES(:V1);
   INSERT INTO MYTABLE2 (F1) VALUES(:V2);
   INSERT INTO MYTABLE2 (F1) VALUES(:V3);
   INSERT INTO MYTABLE2 (F1) VALUES(:V4);
   INSERT INTO MYTABLE2 (F1) VALUES(:V5);
   UPDATE MYTABLE2 SET F2 = F1+1 WHERE F1=:V1;
   UPDATE MYTABLE2 SET F2 = F1+1 WHERE F1=:V2;
   UPDATE MYTABLE2 SET F2 = F1+1 WHERE F1=:V3;
   UPDATE MYTABLE2 SET F2 = F1+1 WHERE F1=:V4;
   UPDATE MYTABLE2 SET F2 = F1+1 WHERE F1=:V5;

Data values are generated by the program. The generated data are the integers 1,2,...N.

Each request (transaction) inserts and then updates five rows into MYTABLE2.

The following variables are contained within the program and can be adjusted to reset the total number of rows or concurrent sessions:
  • NUMLOG: Number of parallel sessions which are connected.
  • MAXTRANS: Number of times that the transaction is initiated.

This particular compilation set NUMLOG=3 and MAXTRANS=10.