DB2 Connect User's Guide

Index

Special Characters
Numerics
A B C D E F G H I J L M N O P Q R S T U V W X Z

Special Characters

&& in SQLCODE mapping file (1332)

" (double quote) in CLP for AIX (1054)

* (asterisk) in CLP for AIX (1055)

* (asterisk) in SQLCODE mapping file (1334)

, (comma) in parameter string (1007)

,, (comma comma) in parameter string (1010)

\ (back slash) in OS/2 (1082)

Numerics

2PC (two-phase commit support) (937)

64-bit integer (BIGINT) data type

supported by DB2 Connect Version 5.2 (1217)

access RDB command (1087) See also ACCRDB command

accounting string (1319)

ACCRDB command (1086), (1097)

ACCRDBRM command (1090), (1102)

ACCSEC (1098)

ACQUIRE statement, DB2 Connect support (1303)

adaptive pacing (1411)

Advanced Program-to-Program Communication (882) See also APPC

AGENTPRI parameter (1395)

AIX clients (893)

already verified (1157)

ambiguous cursors (1246)

ampersand, double (&&) in SQLCODE mapping file (1333)

API (1024), (1025)

updating database directories (1026), (1027)

APPC (881)

Appl. Handle (1117)

application development (895), (1168), (1367)

application name (monitor) (1116)

application performance (1485)

application requester (1429)

DRDA definition (953)

Application requester name (1003)

application server

database concept (903)

database products (851)

DRDA definition (956)

overview (874)

publications (864)

applications

binding (1030)

APPN (1413)

AR name (1004)

ARI (DB2 for VSE & VM) (1232)

AS target database name (1002)

AS/400

database (857), (909)

DRDA (950)

publications (869)

ASCII

mixed-byte data (1199)

sort order (1265)

asterisk in SQLCODE mapping file (1335)

ATOMIC compound SQL

not supported in DB2 Connect (1370)

ATOMIC compound SQL, not supported in DB2 Connect (1294)

authentication (1023), (1434)

authentication type (1470)

authentication type default is SERVER (1137)

AUTHENTICATION=CLIENT (1158)

authority needed for binding (1038)

authorization ID (monitor) (1115)

benchmarking (1360)

Bidirectional language support (932)

bidirectional language support (1452)

big integer, data type (1218) See also 64-bit integer (BIGINT) data type

BIND command

syntax (1044)

bind list (1032), (1478)

BIND rules

DYNAMICRULES (930)

BINDADD privilege (1039)

binding (1028)

authority needed (1037)

packages (1043)

utilities and applications (1029)

bldschem (1489)

syntax (1494)

block size (1389), (1409)

blocking (1245), (1374)

Boostrap dataset on DB2 for MVS/ESA or DB2 for OS/390

BSDS parameters (989), (996)

bottlenecks (1359)

c in SQLCODE mapping file (1343)

C programming language (896)

cached directory information (1392)

CALL statement

on different platforms (1289)

CALL USING DESCRIPTOR statement (OS/400) (1292)

cascade (1273)

cc in SQLCODE mapping file (1341)

CCSID (1438)

CCSIDs (1443)

CDRA (961) See also Character Data Representation Architecture (CDRA)

CHAR data type (1406)

Character Data Representation Architecture (CDRA) (960)

character substitution (1450)

character translation (1202)

CICS (1181)

CLI

utilities (1493)

CLI/ODBC application performance (1482)

CLI/ODBC applications

CURRENTPACKAGESET (1162)

client application ID (monitor) (1121)

CLIENT authentication type (1135)

client DB alias (monitor) (1123)

client NNAME (monitor) (1124)

client product ID (monitor) (1125)

client sequence no (monitor) (1122)

clients supported by DB2 Connect (888)

CLP (1048) See also command line processor

code page (1437)

in SQLERRMC field of SQLCA (1237)

code page conversion exceptions (1449)

code page ID (monitor) (1126)

code pages (1444)

code set

in SQLERRMC field of SQLCA (1239)

collating sequence

EBCDIC and ASCII (1263)

collection ID (1253)

DB2 for AS/400 (1255)

collections (1256)

comma comma in parameter string (1009)

comma in parameter string (1006)

command line processor (920), (1046), (1050)

performance (1387)

REBIND PACKAGE command (1047)

COMMIT statement

statically bound (1384)

COMMIT WORK RELEASE

not supported in DB2 Connect (1311)

common SQL (917)

communication system tuning (1408)

Communications Manager for host connections (886)

communications protocols (876)

APPC (878)

IPX/SPX (879)

NetBIOS (880)

TCP/IP (877)

compound SQL, NOT ATOMIC (1295), (1371)

configuration considerations

password change (1166)

configuring DB2 Connect (914)

connect

CONNECT RESET statement (1224)

CONNECT TO statement (1223)

implicit connect (1226)

null CONNECT (1225)

contention for system resources (1419)

conversion (1445)

conversion exceptions (1448)

conversion of data (1401)

core file (1352)

country code

in SQLERRMC field of SQLCA (1236)

country code page support (1440)

CPU usage tools (1362)

CREATE IN COLLECTION NULLID (1040)

CREATE STORGROUP statement

DB2 Connect support (1186)

CREATE TABLESPACE statement

DB2 Connect support (1187)

creator (1252)

CURRENTPACKAGESET (1160)

cursor stability (1277)

D (disconnect) parameter (1008)

data compression (1415)

data control language (DCL) (1220)

data conversion (1399)

CCSIDs (1441)

code pages (1442)

data conversion exceptions (1447)

data definition language (DDL) (1184)

data flow (957), (1358)

data manipulation language (DML) (1189)

data transfer

between host and workstation (1060)

data transfer rate (1357), (1417)

data types

numeric (1195)

data types supported by DB2 Connect Version 5.2 (941)

data types, conversion (1400)

database alias (1021), (1432)

database concept (901)

database connection services (DCS) directory (978)

database directories (975)

database locator object (1455)

database name (1000), (1020), (1427), (1431)

database object (1454)

database performance tools (1364), (1365)

database system monitor (1109)

database tuning (1398)

DataPropagator (1488)

date and time zone support (1017)

DB2 Connect (1174)

isolation level (1287)

DB2 Connect programming considerations (1177)

DB2 Connect RQRIOBLK size (1508)

DB2 Connect workstation (875)

DB2 family

overview (859)

DB2 for MVS/ESA or DB2 for OS/390

bootstrap dataset (988), (995)

DOMAIN (987)

RESPORT (994)

TCPPORT (993)

DB2 for OS/390

DYNAMICRULES(BIND) (1164)

extended security (1149)

TCP/IP already verified (1154)

ZPARM (1148)

DB2 System Monitor limitation (1110)

DB2 using DB2 Connect (1171)

DB2, not required on DB2 Connect workstation (894)

DB2ACCOUNT environment variable (1322)

db2cli.exe utility (1490)

db2cli.ini file

tuning ODBC and JDBC application performance (1487)

db2ocat

catalog optimizer utility (1496)

DB_Authentication parameter (1461)

DB_Communication_Protocol (1463), (1465)

DB_Database_Protocol parameter (1460)

DB_Native_Database_Name parameter (1459)

DB_Object_Type parameter (1457), (1464)

DB_Principal (1462)

DB_Product_Name parameter (1458)

DB_Target_Database_Info parameter (1466)

DCE (922)

setup information (1133)

software prerequisites (1134)

DCE Directory Services (1453)

DCL (data control language) (1219)

DCLGEN command (MVS) (1243)

DCS authentication type (1138)

DCS directory

LOCALDATE parameter (1014)

specifying the parameter string (1018)

SYSPLEX parameter (1012)

dcs1ari.map file (1330)

dcs1dsn.map file (1329)

dcs1qsq.map file (1331)

ddcs400.lst file (1036)

ddcsmvs.lst file (1033)

ddcstrc utility (1069)

ddcstrc.dmp file (1085)

ddcsvm.lst file (1035)

ddcsvse.lst file (1034)

DDL (data definition language) (1183)

DDM (963) See also distributed data management

DECLARE PROCEDURE statement (OS/400) (1291)

DECLARE STATEMENT

DECLARE statement

DB2 Connect support (1312)

DB2 Connect support (1304)

DELETE

DB2 Connect support (1193)

DESCRIBE statement

DB2 Connect support (1306), (1313)

dynamic SQL (1382)

design of applications (1368)

DFT_ACCOUNT_STR configuration parameter (1323)

diagnostic tools (1348)

differences between different DB2 products (1182)

differences between DRDA server and workstation (1302), (1310)

differences in SQLCODEs and SQLSTATEs (1279)

DIR_CACHE parameter (1391)

directories (976)

distributed data management (962), (1079)

distributed environment (1175)

Distributed Relational Database Architecture (955) See also DRDA

distributed relational database architecture (944) See also DRDA

distributed unit of work (971)

DB2 Connect support (1299)

DML (data manipulation language) (1188)

DOS clients (890)

double-byte characters (1451)

DRDA

application requester (952)

application server (954)

architectures used by (959)

concepts (943)

data flow (958)

publications (862)

DRDA environment, programming (1170)

DRDA server

database concept (902)

database products (850)

overview (873)

publications (863)

DSN (DB2 for MVS/ESA) (1230)

DSN (DB2 for OS/390) (1231)

DSS type (trace) (1078)

DUOW (1300) See also distributed unit of work

dynamic cursors (1249)

Dynamic SQL

dynamic SQL (916), (1378)

CURRENTPACKAGESET (1163)

DB2 Connect support (1179)

EBCDIC

mixed-byte data (1198)

sort order (1264)

embedded SQL (973)

end unit of work reply message (ENDUOWRM) (1106)

ENDUOWRM message (1107)

enhancements in DB2 Connect Version 5.2 (921)

errors (1347)

escape character (1019)

events, trace (1083), (1084)

exchange server attributes command (1089) See also EXCSAT command

EXCSAT command (1088)

EXCSATRD command (1091), (1103)

EXCSQLSTT, DRDA command (1308)

EXECUTE IMMEDIATE statement (1386)

expansion of data on the DRDA server (1201)

export utility

general description (1059)

extended dynamic SQL statements

not supported in DB2 Connect (1318)

extended security codes (1153)

EXTNAM object (1093)

FD:OCA (965) See also Formatted Data Object Content Architecture (FD:OCA)

first failure service log (1349)

flavors of SQL (919)

floating point data type (1405)

FOR FETCH ONLY on SELECT statement (1376)

FORCE command (1118), (1241)

foreign key, DB2 Connect support (1271)

Formatted Data Object Content Architecture (FD:OCA) (964)

GET SNAPSHOT support for DB2 Connect (933)

GRANT statement

DB2 Connect support (1221)

security (1146), (1476)

GROUP BY clause

sort order (1267)

grouping database requests (1372)

hardware, performance (1416)

host database name (monitor) (1128)

host product ID (monitor) (1129)

HP-UX clients (891)

i in SQLCODE mapping file (1344)

IBM SQL (918)

illustration of DB2 Connect (887)

implicit connect (1227)

import utility

general description (1058)

INSERT statement

DB2 Connect support (1191), (1206)

installing DB2 Connect (913)

integer data type (1404)

interactive input mode (CLP) (1052)

INTERRUPT_ENABLED (disconnect) parameter (1011)

IPX/SPX (884)

ISO/ANS SQL92 (1258)

isolation level (1286)

JDBC

catalog optimizer utility (1499)

JDBC application performance (1484)

LABEL ON statement

DB2 Connect support (1305)

LANGLEVEL SQL92E pre-compile option (1257)

languages (1439)

large object data type (1208) See also LOB data type

limitation of database system monitor (1112)

LIST DCS APPLICATIONS command (1114)

LOB data type

supported by DB2 Connect Version 5.2 (1207)

LOCALDATE (1015)

location name (MVS or OS/390) (911)

locking (1274)

long fields (1205)

mapping SQLCODEs (1326)

MAXAGENTS parameter (1396)

MAXDARI parameter (1393)

memory usage tools (1363)

Micro Focus COBOL (900)

Microsoft Transaction Server support (927)

Microsoft Windows applications (898)

mixed-byte data (1063), (1196)

importing and exporting (1064)

monitoring connections on a DB2 Connect gateway (1113)

MSA (967) See also SNA Management Services Architecture (MSA)

MVS

database (852), (904)

DRDA (945)

publications (865)

National language support (1446)

national language support (1435)

mixed-byte data (1065), (1197)

NetBIOS (885)

network performance tools (1366)

new data types supported by DB2 Connect Version 5.2 (942)

NLS (1436) See also national language support

node directory (977)

node name (980), (1022), (1421), (1433)

NOMAP parameter (1005), (1328)

NONE security type (1141)

NOT ATOMIC compound SQL (1293), (1369)

NULLID for OS/400 (1041)

NUMDB parameter (1394)

numeric conversion overflows (1285)

numeric data types (1194)

OBDC interface, Microsoft (899)

object, large data type (1209) See also LOB data type

ODBC application performance (1483)

ODBC applications

CURRENTPACKAGESET (1161)

ODBC performance (926)

ODBC/CLI

catalog optimizer utility (1498)

ORDER BY clause

sort order (1266)

OS/2 clients (889)

OS/390

database (855), (908)

DRDA (946)

OS/400

database (856), (907)

DRDA (949)

publications (868)

OS/400 using DB2 Connect (1172)

outbound application ID (monitor) (1119)

outbound sequence no (monitor) (1127)

overview (872)

owner (1251)

P in SQLCODE mapping file (1339)

pacing (1412)

package

attributes (1254)

packages created on DRDA server (1042)

packed decimal data type (1402)

page-level locking (1275)

paging (1390)

parameter string (1430)

passwords (1131), (1468)

change support through DRDA (924)

changing (923)

PC/IXF file format (1061)

performance (1353)

CLI applications (1481)

CLISCHEMA (1480)

PIU size (1504)

RU size (1503)

SNA tuning criteria (1502)

SNA tuning tips (1501)

tuning ODBC and JDBC application performance (1479)

Performance Troubleshooting (1420)

PIU (1506)

porting applications (1176)

PRDDTA parameter (DRDA) (1320)

PRDID parameter (1105)

precompiler

DB2 Connect support (1185), (1242)

predicate logic (1373)

PREPARE statement

DB2 Connect support (1314)

dynamic SQL (1380), (1383)

primary key, DB2 Connect support (1270)

problem determination (1346)

process status utility (1095), (1351)

PROGRAM security type (1140)

programming considerations

in a DRDA environment (1169)

programming information (1167)

ps (process status) utility (1094), (1350)

publications for porting (1324)

PUT statement

not supported in DB2 Connect (1315)

QSQ (DB2 for AS/400) (1233)

qualifier

different platforms (1250)

quit command (CLP) (1053)

RACF (1143), (1473)

RDBNAM object (1096)

REBIND PACKAGE command (CLP) (1049)

receive buffer (trace) (1074)

referential integrity

DB2 Connect support (1269)

Remote TCP/IP hostname (1423)

remote unit of work (969)

resource access control facility (RACF) (1145), (1475)

response time (1354)

restrictions on import and export (1062)

REVOKE statement

DB2 Connect support (1222)

security (1147), (1477)

ROLLBACK command

statically bound (1385)

ROLLBACK statement

in DB2 Connect (1240)

ROLLBACK WORK RELEASE

not supported in DB2 Connect (1316)

routing information object (1456)

routing requests (968)

row id, data type (1216) See also ROWID data type

row-level locking (1276)

ROWID data type

supported by DB2 Connect Version 5.2 (1215)

RQRIOBLK field (1248)

RQRIOBLK parameter (1388)

RQRIOBLK size (1507)

RU size (1505)

RUSIZE parameter (1410)

s in SQLCODE mapping file (1342)

SAME security type (1139)

SCO (940)

SDK (861) See also Software Developer's Kit (SDK)

SECCHK (1099)

section number (1307)

Security

security (1130), (1467)

DB2 for OS/390 ZPARM (1150)

diagnostics (1151)

extended security codes (1152)

password change (1165)

TCP/IP already verified (1155)

security type (985), (1426), (1471)

SELECT statement

DB2 Connect support (1190)

dynamic SQL (1379)

updateable (1375)

self-referencing tables (1272)

send buffer (trace) (1073)

SERVER authentication type (1136)

Set Client API (931)

SET CURRENT PACKAGESET (1159)

SET CURRENT statement

DB2 Connect support (1317)

setting up DB2 Connect (912)

shift-out and shift-in characters (1066), (1200)

SHOW DETAIL monitor option (1120)

SNA Management Services Architecture (MSA) (966)

SNA performance

tuning tips (1500)

SOCKS

mandatory environment variables (984)

Software Developer's Kit (SDK)

overview (860)

Solaris clients (892)

solving problems (1345)

numeric conversion overflows (1284)

sort order (1262)

SQL reference publications (871)

SQL statement categories (1180)

SQL statements

DB2 Connect support (1301), (1309)

embedded (974)

SQL/DS

database (858), (910)

DRDA (951)

publications (870)

SQL/DS using DB2 Connect (1173)

SQL1338 return code (981)

SQL92 (1259)

SQLCA

buffers of data (1077)

example (1108)

SQLCODE field (1076)

SQLERRMC field (1234), (1296)

SQLERRP field (1229)

SQLCODE

field in SQLCA (1075)

mapping (1325)

platform differences (1280)

standalone (1260)

SQLDA, best size to allocate (1381)

SQLERRMC field of SQLCA (1235), (1297)

SQLERRP field of SQLCA (1228)

sqlesact API (1321)

SQLQMF utility, replaced (1068)

SQLSTATE

class codes (1340)

differences (1281)

in SQLERRMC field of SQLCA (1298)

standalone (1261)

SRVNAM object (1092)

static SQL (915), (1377)

DB2 Connect support (1178)

stored procedures (929), (1288)

symbolic destination name (1422)

case sensitivity (982)

Syncpoint manager (SPM) (935)

configuration (939)

syntax

bldschem (1495)

syntax diagrams

BIND command (1045)

ddcstrc (1080)

syntax of SQLCODE mapping file (1337)

SYSIBM.SYSPROCEDURES catalog (MVS) (1290)

SYSPLEX (1013)

SYSPLEX support (925)

system catalog

DB2 Connect support (1282)

system database directory (979)

System Monitor (934)

System Monitor limitation (1111)

Target database name (1001)

target database name (1428)

TCP/IP (Transmission Control Protocol/Internet Protocol) (883)

TCP/IP

ACCSEC (1100)

DOMAIN (986)

mandatory environment variables for SOCKS security (983)

RESPORT (991)

resynch port (997)

SECCHK (1101)

security already verified (1156)

TCPPORT (992)

TCP/IP hostname (1424)

TCP/IP remote hostname (990)

TCP/IP service name (999)

TCP/IP service name or port number (1425)

terminate command (CLP) (1051)

territory, in SQLERRMC field of SQLCA (1238)

throughput (1356)

time zone support (1016)

timeout on a lock (1278)

tokens and SQLCODEs (1327)

tools for performance (1361)

Trace (1071)

output file (1072)

syntax (1081)

trace utility (1070)

traffic, network (1418)

transaction throughput (1355)

translation, character (1203)

tuning application performance (1486)

tuning, database (1397)

two-phase commit

resynch port used by TCP/IP connections (998)

two-phase commit support (936)

types, abstract (1214) See also User Defined Types

types, user defined (1212) See also User Defined Types

types, user defined distinct (1213) See also User Defined Types

U in SQLCODE mapping file (1338)

UDFs (928)

UDTs type (1211) See also User Defined Types

unambiguous cursors (1247)

unit of work, distributed (972)

unit of work, remote (970)

UPDATE statement

DB2 Connect support (1192)

User Defined Types

supported by DB2 Connect Version 5.2 (1210)

user names (1132), (1469)

user-defined collating sequence (1268)

utilities

binding (1031)

export (1057)

import (1056)

utility

bldschem (1492)

db2cli (1491)

db2ocat catalog optimizer utility (1497)

VALIDATE RUN

DB2 Connect support (1244)

VALNSPRM value (1104)

VARCHAR data type (1407)

variable-length character columns (1067)

variable-length strings (1204)

view

DB2 Connect support (1283)

virtual telecommunications access method (VTAM) (1144), (1474)

database (854), (906)

DRDA (948)

publications (867)

VPACING (VTAM) (1414)

VSE

database (853), (905)

DRDA (947)

publications (866)

VTAM (1142), (1472)

W in SQLCODE mapping file (1336)

Windows applications (897)

XA applications (two-phase commit support) (938)

zoned decimal data type (1403)

[ Top of Page | Previous Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]