gtpa3m19
Application Requester User's Guide
Index
Special Characters
Numerics
A
B
C
D
E
F
H
I
J
K
L
M
N
O
P
R
S
T
V
Z
Special Characters
#IBMMP4 records
(1205)
Numerics
24-bit mode
(1472)
3088 channel-to-channel link station
(1372)
31-bit mode
(1473)
37x5 link station
(1375)
A
Advanced Peer-to-Peer Communication (APPC) session
(1090)
,
(1095)
ALREADYV
specifying on the SECACPT keyword of VTAM APPL statement
(1348)
APPC
starting
(1421)
APPC (Advanced Peer-to-Peer Communication) session
(1091)
,
(1096)
application programs
assembler language
(1605)
assembler modifications when using the same cursor
(1588)
C
(1506)
defining to VTAM
(1377)
effect on TPFAR performance
(1642)
header files for C
(1507)
role in synchronizing updates
(1499)
SQL considerations for
(1498)
TPF C
(1585)
,
(1593)
,
(1595)
,
(1597)
,
(1599)
,
(1601)
application requester (AR)
definition of
(1674)
illustration in remote data access
(1075)
,
(1084)
implementation in Distributed Relational Database Architecture (DRDA)
(1074)
application server (AS)
(1066)
,
(1107)
definition of
(1676)
example of setting up when using assembler language with TPFAR
(1610)
illustration in remote data access
(1079)
,
(1082)
implementation in Distributed Relational Database Architecture (DRDA)
(1078)
AR (application requester)
definition of
(1675)
illustration in remote data access
(1077)
,
(1085)
implementation in Distributed Relational Database Architecture (DRDA)
(1076)
AS (application server)
(1067)
,
(1108)
definition of
(1677)
example of setting up when using assembler language with TPFAR
(1611)
illustration in remote data access
(1081)
,
(1083)
implementation in Distributed Relational Database Architecture (DRDA)
(1080)
assembler language
for TPF applications
(1604)
modifications
(1589)
to offload data from TPF
(1606)
AUTHID field of SYSIBM.SYSUERNAMES table
relationship to TPF complex name in CTKI
(1412)
B
bind
definition of
(1678)
bind file (DB2)
(1527)
package
(1552)
bind process (DB2)
(1526)
package
(1551)
block query method for using TPFAR
(1131)
illustration of
(1129)
blocks (TPFAR), working storage
(1483)
bootstrap data set (BSDS) of DB2
(1255)
,
(1330)
,
(1341)
,
(1399)
BSDS (bootstrap data set) of DB2
(1254)
,
(1329)
,
(1340)
,
(1398)
bulk data transfer method for using TPFAR
(1119)
illustration of
(1123)
C
C language for TPF applications
(1505)
,
(1592)
example of displaying data
(1600)
example of inserting data
(1594)
example of removing data
(1596)
example of updating data
(1598)
modifications
(1586)
CCSID (coded character set identifier) default for DB2
(1270)
,
(1388)
Ccsid parameter of ZSQLD
(1279)
CDRSC statement
defining
(1380)
illustration of dependency of parameters
(1419)
,
(1420)
Channel-to-Channel (CTC) link station
(1374)
considerations
(1650)
read buffers and SNAKEY
(1651)
code page specifications
(1262)
coded character set identifier (CCSID) default for DB2
(1269)
,
(1387)
COLLECTION-ID option of DBRM
(1558)
column
and primary key/index
(1617)
definition of
(1679)
explanation of
(1438)
in relational databases
(1429)
commands for TPFAR
(1244)
ZNKEY
(1291)
ZSQLD
(1178)
,
(1306)
,
(1315)
,
(1390)
ZSTTD
(1297)
,
(1658)
communications requirements for TPFAR
(1141)
CONFIG macro of SIP
TPFAR option
(1157)
CONFIG.SYS file
(1260)
connection
3088 channel-to-channel link station
(1368)
37x5 link station
(1367)
TPF and DB2 for VTAM
(1366)
conversational security and TPF/APPC
(1345)
CTC (channel-to-channel) link station
(1373)
considerations
(1648)
read buffers and SNAKEY
(1649)
CTK2 (keypoint 2)
(1191)
,
(1309)
CTKI (keypoint I)
(1414)
cursor
(1465)
definition of
(1680)
maximum number
(1468)
using the same cursor in SQL source programs
(1579)
D
data collection reports for TPFAR
STREAMDDM
(1666)
data definition language files for SQL
(1444)
,
(1560)
data reduction reports for TPFAR
system summary report
(1663)
DATABASE 2 (DB2)
(1104)
bind file
(1525)
bind process
(1524)
coded character set identifier (CCSID) default
(1271)
connecting with TPF for VTAM
(1371)
definition of
(1685)
DSNTIPE installation panel
(1401)
DSNTIPF installation panel
(1264)
,
(1385)
DSNTIPR installation panel
(1336)
,
(1393)
moving TPF data using TPFAR
(1098)
moving TPF data without TPFAR
(1093)
precompiler
(1523)
,
(1535)
,
(1583)
relational database
(1064)
requirements for TPFAR
(1143)
database management system (DBMS)
(1088)
,
(1183)
definition of
(1681)
Database Request Module (DBRM)
(1542)
,
(1548)
database request module (DBRM)
(1533)
COLLECTION-ID option
(1556)
definition of
(1683)
MEM option
(1566)
PACKAGE option
(1553)
RELEASE option
(1563)
DB2 (DATABASE 2)
(1103)
bind file
(1530)
bind process
(1529)
coded character set identifier (CCSID) default
(1272)
connecting with TPF for VTAM
(1370)
definition of
(1686)
DSNTIPE installation panel
(1402)
DSNTIPF installation panel
(1265)
,
(1386)
DSNTIPR installation panel
(1337)
,
(1394)
moving TPF data using TPFAR
(1099)
moving TPF data without TPFAR
(1094)
precompiler
(1528)
,
(1536)
,
(1582)
relational database
(1065)
requirements for TPFAR
(1142)
,
(1381)
DB2 PLU
defining
(1159)
OSTG definition
(1167)
,
(1331)
DBMS (database management system)
(1089)
,
(1184)
definition of
(1682)
DBRM (Database Request Module)
(1543)
,
(1549)
DBRM (database request module)
(1534)
COLLECTION-ID option
(1557)
definition of
(1684)
MEM option
(1567)
PACKAGE option
(1554)
RELEASE option
(1564)
DBSAC macro
(1211)
,
(1321)
,
(1485)
DBSDC macro
(1212)
,
(1322)
,
(1486)
DDF (Distributed Data Facility) of DB2
(1339)
,
(1397)
DDL files for SQL
(1443)
,
(1561)
DEC parameter of DB2 precompiler
(1537)
decimal (DEC) parameter of DB2 precompiler
(1539)
defining user exits
SQL trace table
(1299)
distributed access capability of SAA
(1058)
distributed access capability of Systems Application Architecture
(1057)
Distributed Data Facility (DDF) of DB2
(1338)
,
(1396)
Distributed Relational Data Architecture (DRDA)
definition of
(1687)
Distributed Relational Database Architecture (DRDA)
(1072)
illustration of implementation
(1086)
DRDA (Distributed Relational Data Architecture)
definition of
(1688)
DRDA (Distributed Relational Database Architecture)
(1073)
illustration of implementation
(1087)
DSNTIPE DB2 installation panel
(1400)
DSNTIPF DB2 installation panel
(1263)
,
(1384)
DSNTIPR DB2 installation panel
(1335)
,
(1395)
dynamic Structured Query Language (SQL)
(1477)
E
EAS keyword of VTAM APPL statement
(1334)
ECB processing and TPFAR
(1194)
,
(1318)
,
(1489)
,
(1643)
error handling for SQL
(1510)
F
frequent flyer database and transaction logging
(1117)
H
HCT
definition of
(1689)
heap storage
(1201)
host language considerations when using the same cursor
assembler modifications
(1587)
TPF C modifications
(1584)
HOST parameter of DB2 precompiler
(1540)
HOST parameter of TPF DB2 postprocessor
(1575)
hotcon
benefits
(1637)
cost
(1639)
definition of
(1181)
,
(1690)
table
(1182)
hotcons
(1282)
I
implied ROLLBACK
(1504)
,
(1519)
J
JCL to run TPF DB2 postprocessor (TPF DB2PP)
(1576)
K
keypoint 2 (CTK2)
(1192)
,
(1310)
keypoint I (CTKI)
(1415)
L
logical unit of work
definition of
(1691)
logical unit of work identifier (LUWID)
(1640)
definition of
(1693)
loosely coupled
(1165)
loosely coupled requirement for TPFAR
(1300)
LU 6.2 conversation
(1068)
,
(1109)
,
(1494)
,
(1638)
LU 6.2 requirements for TPFAR
(1140)
,
(1215)
conversational security
(1344)
MAXCCB
(1228)
MAXSCB
(1224)
MAXTPI
(1218)
NETID
(1232)
session level security
(1358)
specifying ALREADYV
(1350)
LU 6.2 sessions
establishing
(1422)
LU names connecting to the DB2 system, specifying
(1407)
Lu parameter of ZSQLD
(1278)
LUNAME field of SYSIBM.SYSUSERNAMES table
(1417)
LUWID (logical unit of work identifier)
(1641)
definition of
(1692)
M
macros
DBSAC
(1213)
,
(1323)
,
(1487)
DBSDC
(1214)
,
(1324)
,
(1488)
MSGRTA
(1164)
SIP CONFIG
(1152)
SNAKEY
(1173)
,
(1221)
,
(1227)
,
(1231)
,
(1235)
,
(1242)
malloc
heap storage
(1200)
malloc blocks
(1484)
MAXCCB parameter of SNAKEY macro
(1229)
MAXHCT
(1281)
,
(1283)
Maxhct
parameter of ZSQLD
(1280)
storage area for TPFAR
(1176)
MAXRU
(1463)
MAXSCB parameter of SNAKEY macro
(1225)
MAXSDD
(1284)
storage area for TPFAR
(1186)
MAXSMTB
(1287)
storage area for TPFAR
(1190)
MAXSOCK parameter of SNAKEY macro
(1240)
MAXTPI parameter of SNAKEY macro
(1219)
MEM option of DBRM
(1568)
mixed-byte support
(1266)
mode name
(1360)
,
(1426)
RDB APPC mode name
(1259)
SYSLUNAMES table
(1258)
SYSMODENAME
(1408)
moving TPF data to DB2 using TPFAR
advantages of
(1102)
illustration of
(1097)
moving TPF data to DB2 without TPFAR
illustration of
(1092)
MSGRTA macro
(1163)
N
NETID parameter of SNAKEY macro
(1234)
NEWAUTHID field of SYSIBM.SYSUSERNAMES table
(1418)
NONE
specifying on the VERIFY keyword of VTAM APPL statement
(1354)
O
OSTG
(1168)
,
(1332)
P
pacing and RU size considerations for VTAM
(1362)
package (output from DB2 bind process)
(1550)
definition of
(1694)
PACKAGE option of DBRM
(1555)
performance of TPFAR
(1627)
calculation methods for response time
(1654)
data reduction reports
(1662)
segment allocation
(1668)
pools (short term)
(1492)
precompiler (DB2)
bind file
(1532)
bind process
(1531)
DEC parameter
(1538)
HOST parameter
(1541)
VERSION parameter
(1545)
primary index
(1616)
primary key
(1615)
protect key
(1469)
PRTCT keyword of VTAM APPL statement
(1343)
R
RACF checking
(1416)
Rdb (relational database name)
relationship to bootstrap data set (BSDS)
(1253)
RDB (relational database)
(1063)
column
(1437)
definition of
(1696)
example of
(1431)
row
(1433)
table
(1435)
Rdb parameter of ZSQLD
(1277)
read buffers (CTC) and SNAKEY
(1652)
record ID X'FF0F'
(1208)
registers
(1474)
relational database (RDB)
(1062)
column
(1436)
definition of
(1695)
example of
(1430)
row
(1432)
table
(1434)
relational database name (Rdb)
relationship to bootstrap data set (BSDS)
(1252)
RELEASE option of DBRM
(1565)
remote data access
(1071)
remote unit of work
(1061)
request unit
calculating size
(1462)
size requirements
(1460)
,
(1461)
response time
(1636)
row
(1620)
and primary key/index
(1618)
definition of
(1697)
explanation of
(1439)
in relational databases
(1428)
RU sizes and pacing considerations for VTAM
(1361)
,
(1364)
S
SAA (Systems Application Architecture)
definition of
(1707)
distributed access capability of
(1060)
SDD (SQL database management system directory)
(1203)
,
(1246)
,
(1304)
adding an entry using ZSQLD
(1268)
definition of
(1703)
SECACPT keyword of VTAM APPL statement
specifying ALREADYV
(1347)
security
(1356)
conversational and TPF/APPC
(1349)
session level and TPF/APPC
(1359)
segment allocation and TPFAR performance
(1669)
service LUs
(1166)
session level security and TPF/APPC
(1355)
,
(1357)
short term pools
(1210)
,
(1493)
single line query method for using TPFAR
(1126)
illustration of
(1124)
SIP CONFIG macro changes for TPFAR
(1151)
TPFAR option of
(1155)
SIP stage 1
(1162)
SMIT CCSIDs
(1261)
SNAKEY macro
and CTC read buffers
(1653)
MAXCCB parameter
(1230)
MAXSCB parameter
(1226)
MAXSOCK parameter
(1243)
MAXSOCK parameter of SNAKEY macro
(1241)
MAXTPI parameter
(1222)
MAXTPI parameter of SNAKEY macro
(1220)
NETID parameter
(1233)
SNAKEY macro
(1172)
SPUFI (SQL Processor Using File Input)
(1411)
,
(1441)
,
(1562)
,
(1613)
SQL (Structured Query Language)
(1069)
SQL (structured query language)
C language header files
(1508)
considerations
(1445)
definition of
(1701)
dynamic
(1478)
error handling
(1511)
maximum number of cursors
(1466)
protect key
(1470)
registers
(1475)
request unit size
(1458)
supported commands for TPFAR
(1670)
synchronizing updates
(1495)
time field length, specifying
(1447)
working storage for TPFAR blocks
(1480)
SQL COMMIT command
(1122)
,
(1501)
,
(1520)
,
(1609)
,
(1623)
,
(1624)
,
(1647)
SQL CONNECT command
(1121)
,
(1607)
SQL CREATE INDEX command
(1621)
SQL CREATE TABLE command
(1442)
,
(1614)
,
(1622)
SQL database management system directory (SDD)
(1202)
,
(1245)
,
(1303)
adding an entry using ZSQLD
(1267)
definition of
(1702)
SQL FETCH command
(1134)
,
(1136)
,
(1464)
SQL INSERT command
(1115)
,
(1503)
,
(1521)
,
(1608)
,
(1646)
SQL OPEN command
(1135)
SQL Processor Using File Input (SPUFI)
(1410)
,
(1440)
,
(1559)
,
(1612)
SQL SELECT INTO command
(1128)
,
(1133)
SQL source programs
host language considerations
(1581)
modifying to use the same cursor
(1580)
SQL trace table
(1187)
,
(1285)
,
(1292)
,
(1659)
defining the user exit
(1298)
SQL trace table user exit
(1661)
SQL tracing
(1250)
SQL UPDATE command
(1116)
,
(1502)
SQLCA (Structured Query Language Communications Area)
(1450)
definition of
(1704)
SQLCODE
(1453)
,
(1516)
SQLSTATE
(1452)
,
(1515)
SQLCODE
(1457)
,
(1514)
definition of
(1698)
SQLSTATE
(1456)
,
(1500)
,
(1513)
definition of
(1699)
storage areas for TPFAR
(1174)
MAXHCT
(1175)
MAXSDD
(1185)
MAXSMTB
(1189)
STREAMDDM data collection report for TPFAR
(1667)
Structured Query Language (SQL)
(1070)
structured query language (SQL)
C language header files
(1509)
considerations
(1446)
definition of
(1700)
dynamic
(1479)
error handling
(1512)
maximum number of cursors
(1467)
protect key
(1471)
registers
(1476)
request unit size
(1459)
supported commands for TPFAR
(1671)
synchronizing updates
(1496)
time field length, specifying
(1449)
working storage for TPFAR blocks
(1481)
Structured Query Language (SQL) trace table
(1188)
,
(1286)
,
(1293)
,
(1660)
Structured Query Language Communications Area (SQLCA)
(1451)
definition of
(1705)
SQLCODE
(1455)
,
(1518)
SQLSTATE
(1454)
,
(1517)
subsystem requirements for TPFAR
(1311)
synchronization of SQL updates
application program considerations for
(1497)
SYSIBM.SYSLUNAMES table
(1404)
SYSIBM.SYSLUSERNAMES table
LUNAME field
(1405)
NEWAUTHID field
(1406)
system summary report
(1664)
Systems Application Architecture (SAA)
definition of
(1706)
distributed access capability of
(1059)
T
table
(1619)
definition of
(1708)
in relational databases
(1427)
TCP/IP requirements for TPFAR
(1236)
MAXSOCK
(1239)
time field length for SQL
(1448)
TPF
connecting with DB2 for VTAM
(1369)
TPF application LUs
defining to VTAM
(1376)
TPF application program
precompiling
(1522)
TPF Application Requester (TPFAR)
calculation methods for response time
(1656)
DB2 requirements
(1149)
,
(1383)
defining storage areas for in SNAKEY
(1171)
distributed access capability of Systems Application Architecture
(1055)
ECB processing
(1196)
,
(1320)
,
(1491)
,
(1645)
how it works
(1106)
introduction to
(1056)
loosely coupled requirements
(1302)
LU 6.2 requirements
(1217)
Lu 6.2 requirements
(1148)
methods for using
(1111)
performance and tuning
(1630)
preparing your environment for
(1138)
response time
(1632)
role in moving TPF data to DB2
(1101)
SIP CONFIG macro changes for TPF
(1154)
subsystem requirements for TPFAR
(1312)
suggested methods for using
(1114)
,
(1120)
,
(1127)
,
(1132)
supported SQL commands
(1673)
TCP/IP requirements
(1238)
TPF requirements
(1147)
TPF storage requirements
(1198)
tuning and performance
(1631)
using assembler language in applications
(1603)
using TPF C in applications
(1591)
VTAM requirements
(1327)
ZNKEY command
(1289)
ZSQLD command
(1179)
,
(1249)
,
(1307)
,
(1316)
,
(1391)
ZSTTD command
(1296)
TPF complex name in CTKI
(1413)
TPF DB2 postprocessor (TPF DB2PP)
(1547)
invoking
(1573)
required parameter
(1574)
sample JCL to run TPF DB2PP
(1578)
strings altered
(1570)
TPF DB2PP (TPF DB2 Postprocessor)
(1546)
TPF DB2PP (TPF DB2 postprocessor)
invoking
(1571)
required parameter
(1572)
sample JCL to run TPF DB2PP
(1577)
strings altered
(1569)
TPF requirements for TPFAR
(1139)
SIP CONFIG macro changes
(1150)
TPF storage requirements for TPFAR
#IBMMP4 records
(1204)
and ECB processing
(1193)
LU 6.2 Fastpath
(1206)
malloc
(1199)
record ID X'FF0F'
(1207)
short term pools
(1209)
TPF/APPC Application
TPF/APPC application
defining
(1158)
defining
(1161)
TPF/APPC resources
defining
(1160)
TPFAR (TPF Application Requester)
calculation methods for response time
(1655)
DB2 requirements
(1146)
,
(1382)
defining storage areas for in SNAKEY
(1169)
distributed access capability of Systems Application Architecture
(1053)
ECB processing
(1195)
,
(1319)
,
(1490)
,
(1644)
,
(1665)
how it works
(1105)
introduction to
(1054)
loosely coupled requirements
(1301)
LU 6.2 requirements
(1145)
,
(1216)
methods for using
(1110)
performance and tuning
(1625)
preparing your environment for
(1137)
response time
(1626)
role in moving TPF data to DB2
(1100)
SIP CONFIG macro changes for TPF
(1153)
SNAKEY macro
(1170)
subsystem requirements for TPFAR
(1313)
suggested methods for using
(1112)
,
(1118)
,
(1125)
,
(1130)
supported SQL commands
(1672)
TCP/IP requirements
(1237)
TPF requirements
(1144)
TPF storage requirements
(1197)
using assembler language in applications
(1602)
using TPF C in applications
(1590)
VTAM requirements
(1326)
ZNKEY command
(1288)
ZSQLD command
(1180)
,
(1248)
,
(1308)
,
(1317)
,
(1392)
ZSTTD command
(1295)
TPFAR blocks, working storage
(1482)
TPFAR option of SIP CONFIG macro
(1156)
tracing SQL entries
(1251)
transaction logging method for using TPFAR
(1113)
tuning TPFAR
performance of TPFAR
(1633)
response time
(1629)
,
(1635)
tuning and performance
(1628)
,
(1634)
V
VERIFY keyword of VTAM APPL statement
conversational security
(1353)
specifying NONE
(1352)
VERSION parameter of DB2 precompiler
(1544)
VTAM APPL statement
(1256)
,
(1328)
defining
(1379)
,
(1403)
EAS keyword
(1333)
PRTCT keyword
(1342)
SECACPT keyword
(1346)
VERIFY keyword
(1351)
VTAM definitions for TPF applications
(1378)
VTAM requirements for TPFAR
(1325)
connecting TPF and DB2
(1365)
RU sizes and pacing considerations
(1363)
Z
ZNCNS command
(1223)
,
(1257)
,
(1409)
,
(1425)
ZNETW command
(1424)
ZNKEY command
(1290)
ZROUT command
(1423)
ZSQLD command for TPFAR
(1177)
,
(1247)
,
(1305)
,
(1314)
,
(1389)
Ccsid parameter
(1275)
Lu parameter
(1274)
Maxhct parameter
(1276)
Rdb parameter
(1273)
ZSTTD command for TPFAR
(1294)
,
(1657)