User's Guide

Index

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

Special Characters

&& in SQLCODE mapping file (1165)

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

* (asterisk) in CLP for AIX (900)

* (asterisk) in SQLCODE mapping file (1167)

, (comma) in parameter string (860)

,, (comma comma) in parameter string (863)

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

access RDB command (949) See also ACCRDB command

accounting string (1152)

ACCRDB command (948), (959)

ACCRDBRM command (952), (964)

ACCSEC (960)

ACQUIRE statement, DB2 Connect support (1136)

adaptive pacing (1244)

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

AGENTPRI parameter (1228)

AIX clients (772)

AIX Encina Monitor (831), (1131)

already verified (998)

ambiguous cursors (1076)

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

API (869), (870)

updating database directories (871), (872)

APPC (760)

Appl. Handle (905)

application development (774), (1007), (1200)

application name (monitor) (904)

application requester (856), (1262)

DRDA definition (811)

application server

database concept (782)

database products (730)

DRDA definition (814)

overview (753)

publications (743)

applications

binding (875)

APPN (1246)

ARI (DB2 for VSE & VM) (1062)

AS/400

database (736), (788)

DRDA (808)

publications (748)

ASCII

mixed-byte data (1038)

sort order (1095)

asterisk in SQLCODE mapping file (1168)

ATOMIC compound SQL

not supported in DB2 Connect (1203)

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

authentication (868), (1267)

authentication type (1294)

authentication type default is SERVER (978)

AUTHENTICATION=CLIENT (999)

authority needed for binding (883)

authorization ID (monitor) (903)

benchmarking (1193)

BIND command

syntax (889)

bind list (877), (1302)

BINDADD privilege (884)

binding (873)

authority needed (882)

packages (888)

utilities and applications (874)

block size (1222), (1242)

blocking (1075), (1207)

bottlenecks (1192)

c in SQLCODE mapping file (1176)

C programming language (775)

cached directory information (1225)

CALL statement

on different platforms (1119)

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

cascade (1103)

cc in SQLCODE mapping file (1174)

CCSID (1271)

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

CHAR data type (1239)

character data conversion (1274)

Character Data Representation Architecture (CDRA) (818)

character translation (1041)

CICS (833), (1020), (1133)

CLI/ODBC applications

CURRENTPACKAGESET (1003)

client application ID (monitor) (909)

CLIENT authentication type (976)

client DB alias (monitor) (911)

client NNAME (monitor) (912)

client product ID (monitor) (913)

client sequence no (monitor) (910)

clients supported by DB2 Connect (767)

CLP (893) See also command line processor

code page (1270)

conversion (1276)

in SQLERRMC field of SQLCA (1067)

code page ID (monitor) (914)

code set

in SQLERRMC field of SQLCA (1069)

collating sequence

EBCDIC and ASCII (1093)

collection ID (1083)

DB2 for AS/400 (1085)

collections (1086)

comma comma in parameter string (862)

comma in parameter string (859)

command line processor (799), (891), (895)

performance (1220)

REBIND PACKAGE command (892)

COMMIT statement

statically bound (1217)

COMMIT WORK RELEASE

not supported in DB2 Connect (1144)

common SQL (796)

communication protocols (755)

APPC (757)

IPX/SPX (758)

NetBIOS (759)

TCP/IP (756)

communication system tuning (1241)

Communications Manager for host connections (765)

compound SQL, NOT ATOMIC (1125), (1204)

configuring DB2 Connect (793)

connect

CONNECT RESET statement (1054)

CONNECT TO statement (1053)

implicit connect (1056)

null CONNECT (1055)

contention for system resources (1252)

conversion of data (1234)

core file (1185)

country code

in SQLERRMC field of SQLCA (1066)

CPU usage tools (1195)

CREATE IN COLLECTION NULLID (885)

CREATE STORGROUP statement

DB2 Connect support (1025)

CREATE TABLESPACE statement

DB2 Connect support (1026)

creator (1082)

CURRENTPACKAGESET (1001)

cursor stability (1107)

D (disconnect) parameter (861)

data compression (1248)

data control language (DCL) (1050)

data conversion (1232), (1275)

data definition language (DDL) (1023)

data flow (815), (1191)

data manipulation language (DML) (1028)

data transfer

between host and workstation (922)

data transfer rate (1190), (1250)

data types

numeric (1034)

data types, conversion (1233)

database alias (866), (1265)

database concept (780)

database connection services (DCS) directory (842)

database directories (839)

database locator object (1279)

database name (854), (865), (1260), (1264)

database object (1278)

database performance tools (1197), (1198)

database system monitor (901)

database tuning (1231)

DB2 Connect (1013)

isolation level (1117)

DB2 Connect programming considerations (1016)

DB2 Connect workstation (754)

DB2 family

overview (738)

DB2 for OS/390

DYNAMICRULES(BIND) (1005)

extended security (990)

TCP/IP already verified (995)

ZPARM (989)

DB2 using DB2 Connect (1010)

DB2, not required on DB2 Connect workstation (773)

DB2ACCOUNT environment variable (1155)

DB_Authentication parameter (1285)

DB_Communication_Protocol (1287), (1289)

DB_Database_Protocol parameter (1284)

DB_Native_Database_Name parameter (1283)

DB_Object_Type parameter (1281), (1288)

DB_Principal (1286)

DB_Product_Name parameter (1282)

DB_Target_Database_Info parameter (1290)

DCE

setup information (974)

software prerequisites (975)

DCE Directory Services (1277)

DCL (data control language) (1049)

DCLGEN command (MVS) (1073)

DCS authentication type (979)

dcs1ari.map file (1163)

dcs1dsn.map file (1162)

dcs1qsq.map file (1164)

ddcs400.lst file (881)

ddcsmvs.lst file (878)

ddcstrc utility (931)

ddcstrc.dmp file (947)

ddcsvm.lst file (880)

ddcsvse.lst file (879)

DDL (data definition language) (1022)

DDM (821) See also distributed data management

DECLARE PROCEDURE statement (OS/400) (1121)

DECLARE STATEMENT

DECLARE statement

DB2 Connect support (1145)

DB2 Connect support (1137)

DELETE

DB2 Connect support (1032)

DESCRIBE statement

DB2 Connect support (1139), (1146)

dynamic SQL (1215)

design of applications (1201)

DFT_ACCOUNT_STR configuration parameter (1156)

diagnostic tools (1181)

differences between different DB2 products (1021)

differences between DRDA server and workstation (1135), (1143)

differences in SQLCODEs and SQLSTATEs (1109)

DIR_CACHE parameter (1224)

directories (840)

distributed data management (820), (941)

distributed environment (1014)

Distributed Relational Database Architecture (813) See also DRDA

distributed relational database architecture (802) See also DRDA

distributed unit of work (829)

DB2 Connect support (1129)

DML (data manipulation language) (1027)

DOS clients (769)

DRDA

application requester (810)

application server (812)

architectures used by (817)

concepts (801)

data flow (816)

publications (741)

DRDA environment, programming (1009)

DRDA server

database concept (781)

database products (729)

overview (752)

publications (742)

DSN (DB2 for MVS/ESA) (1060)

DSN (DB2 for OS/390) (1061)

DSS type (trace) (940)

DUOW (1130) See also distributed unit of work

dynamic cursors (1079)

Dynamic SQL

dynamic SQL (795), (1211)

CURRENTPACKAGESET (1004)

DB2 Connect support (1018)

EBCDIC

mixed-byte data (1037)

sort order (1094)

embedded SQL (837)

Encina Monitor (832), (1132)

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

ENDUOWRM message (969)

errors (1180)

events, trace (945), (946)

exchange server attributes command (951) See also EXCSAT command

EXCSAT command (950)

EXCSATRD command (953), (965)

EXCSQLSTT, DRDA command (1141)

EXECUTE IMMEDIATE statement (1219)

expansion of data on the DRDA server (1040)

export utility

general description (921)

extended dynamic SQL statements

not supported in DB2 Connect (1151)

extended security codes (994)

EXTNAM object (955)

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

first failure service log (1182)

flavors of SQL (798)

floating point data type (1238)

FOR FETCH ONLY on SELECT statement (1209)

FORCE command (906), (1071)

foreign key, DB2 Connect support (1101)

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

GRANT statement

DB2 Connect support (1051)

security (987), (1300)

GROUP BY clause

sort order (1097)

grouping database requests (1205)

hardware, performance (1249)

host database name (monitor) (916)

host product ID (monitor) (917)

HP-UX clients (770)

i in SQLCODE mapping file (1177)

IBM SQL (797)

illustration of DB2 Connect (766)

implicit connect (1057)

import utility

general description (920)

INSERT statement

DB2 Connect support (1030), (1045)

installing DB2 Connect (792)

integer data type (1237)

interactive input mode (CLP) (897)

INTERRUPT_ENABLED (disconnect) parameter (864)

IPX/SPX (763)

ISO/ANS SQL92 (1088)

isolation level (1116)

LABEL ON statement

DB2 Connect support (1138)

LANGLEVEL SQL92E pre-compile option (1087)

languages (1272)

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

LIST DCS APPLICATIONS command (902)

LOB data type

not supported in DB2 Connect (1046)

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

locking (1104)

long fields (1044)

mapping SQLCODEs (1159)

MAXAGENTS parameter (1229)

MAXDARI parameter (1226)

memory usage tools (1196)

Micro Focus COBOL (779)

Microsoft Windows applications (777)

mixed-byte data (925), (1035)

importing and exporting (926)

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

MVS

database (731), (783)

DRDA (803)

publications (744)

national language support (1268)

mixed-byte data (927), (1036)

National Language Support (NLS)

character data conversion (1273)

NetBIOS (764)

network performance tools (1199)

NLS (1269) See also national language support

node directory (841)

node name (844), (867), (1254), (1266)

NOMAP parameter (858), (1161)

NONE security type (982)

NOT ATOMIC compound SQL (1123), (1202)

NULLID for OS/400 (886)

NUMDB parameter (1227)

numeric conversion overflows (1115)

numeric data types (1033)

OBDC interface, Microsoft (778)

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

ODBC applications

CURRENTPACKAGESET (1002)

ORDER BY clause

sort order (1096)

OS/2 clients (768)

OS/390

database (734), (787)

DRDA (804)

OS/400

database (735), (786)

DRDA (807)

publications (747)

OS/400 using DB2 Connect (1011)

outbound application ID (monitor) (907)

outbound sequence no (monitor) (915)

overview (751)

owner (1081)

P in SQLCODE mapping file (1172)

pacing (1245)

package

attributes (1084)

packages created on DRDA server (887)

packed decimal data type (1235)

page-level locking (1105)

paging (1223)

parameter string (857), (1263)

passwords (972), (1292)

PC/IXF file format (923)

performance (1186)

Performance Troubleshooting (1253)

porting applications (1015)

PRDDTA parameter (DRDA) (1153)

PRDID parameter (967)

precompiler

DB2 Connect support (1024), (1072)

predicate logic (1206)

PREPARE statement

DB2 Connect support (1147)

dynamic SQL (1213), (1216)

primary key, DB2 Connect support (1100)

problem determination (1179)

process status utility (957), (1184)

PROGRAM security type (981)

programming considerations

in a DRDA environment (1008)

programming information (1006)

ps (process status) utility (956), (1183)

publications for porting (1157)

PUT statement

not supported in DB2 Connect (1148)

QSQ (DB2 for AS/400) (1063)

qualifier

different platforms (1080)

quit command (CLP) (898)

RACF (984), (1297)

RDBNAM object (958)

REBIND PACKAGE command (CLP) (894)

receive buffer (trace) (936)

referential integrity

DB2 Connect support (1099)

Remote TCP/IP hostname (1256)

remote unit of work (827)

resource access control facility (RACF) (986), (1299)

response time (1187)

restrictions on import and export (924)

REVOKE statement

DB2 Connect support (1052)

security (988), (1301)

ROLLBACK command

statically bound (1218)

ROLLBACK statement

in DB2 Connect (1070)

ROLLBACK WORK RELEASE

not supported in DB2 Connect (1149)

routing information object (1280)

routing requests (826)

row-level locking (1106)

RQRIOBLK field (1078)

RQRIOBLK parameter (1221)

RUSIZE parameter (1243)

s in SQLCODE mapping file (1175)

SAME security type (980)

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

SECCHK (961)

section number (1140)

Security

security (971), (1291)

DB2 for OS/390 ZPARM (991)

diagnostics (992)

extended security codes (993)

TCP/IP already verified (996)

security type (849), (1259), (1295)

SELECT statement

DB2 Connect support (1029)

dynamic SQL (1212)

updateable (1208)

self-referencing tables (1102)

send buffer (trace) (935)

SERVER authentication type (977)

SET CURRENT PACKAGESET (1000)

SET CURRENT statement

DB2 Connect support (1150)

setting up DB2 Connect (791)

shift-out and shift-in characters (928), (1039)

SHOW DETAIL monitor option (908)

SNA Management Services Architecture (MSA) (824)

SOCKS

mandatory environment variables (848)

Software Developer's Kit (SDK)

overview (739)

Solaris clients (771)

solving problems (1178)

numeric conversion overflows (1114)

sort order (1092)

SQL reference publications (750)

SQL statement categories (1019)

SQL statements

DB2 Connect support (1134), (1142)

embedded (838)

SQL/DS

database (737), (789)

DRDA (809)

publications (749)

SQL/DS using DB2 Connect (1012)

SQL1338 return code (845)

SQL92 (1089)

SQLCA

buffers of data (939)

example (970)

SQLCODE field (938)

SQLERRMC field (1064), (1126)

SQLERRP field (1059)

SQLCODE

field in SQLCA (937)

mapping (1158)

platform differences (1110)

standalone (1090)

SQLDA, best size to allocate (1214)

SQLERRMC field of SQLCA (1065), (1127)

SQLERRP field of SQLCA (1058)

sqlesact API (1154)

SQLQMF utility, replaced (930)

SQLSTATE

class codes (1173)

differences (1111)

in SQLERRMC field of SQLCA (1128)

standalone (1091)

SRVNAM object (954)

static SQL (794), (1210)

DB2 Connect support (1017)

stored procedures (1118)

symbolic destination name (1255)

case sensitivity (846)

syntax diagrams

BIND command (890)

ddcstrc (942)

syntax of SQLCODE mapping file (1170)

SYSIBM.SYSPROCEDURES catalog (MVS) (1120)

system catalog

DB2 Connect support (1112)

system database directory (843)

target database name (855), (1261)

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

TCP/IP

ACCSEC (962)

mandatory environment variables for SOCKS security (847)

read-only DB access over TCP/IP connections using XA (835)

resynch port (851)

SECCHK (963)

security already verified (997)

supported to host systems (800)

TCP/IP hostname (1257)

TCP/IP remote hostname (850)

TCP/IP service name (853)

TCP/IP service name or port number (1258)

terminate command (CLP) (896)

territory, in SQLERRMC field of SQLCA (1068)

throughput (1189)

timeout on a lock (1108)

tokens and SQLCODEs (1160)

tools for performance (1194)

TP Monitor support

read-only DB access over TCP/IP connections (836)

Trace (933)

output file (934)

syntax (943)

trace utility (932)

traffic, network (1251)

transaction throughput (1188)

translation, character (1042)

tuning, database (1230)

two-phase commit

resynch port used by TCP/IP connections (852)

U in SQLCODE mapping file (1171)

unambiguous cursors (1077)

unit of work, distributed (830)

unit of work, remote (828)

UPDATE statement

DB2 Connect support (1031)

user names (973), (1293)

user-defined collating sequence (1098)

utilities

binding (876)

export (919)

import (918)

VALIDATE RUN

DB2 Connect support (1074)

VALNSPRM value (966)

VARCHAR data type (1240)

variable-length character columns (929)

variable-length strings (1043)

view

DB2 Connect support (1113)

virtual telecommunications access method (VTAM) (985), (1298)

database (733), (785)

DRDA (806)

publications (746)

VPACING (VTAM) (1247)

VSE

database (732), (784)

DRDA (805)

publications (745)

VTAM (983), (1296)

W in SQLCODE mapping file (1169)

Windows applications (776)

XA environments

read-only DB access over TCP/IP connections (834)

zoned decimal data type (1236)

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

[ DB2 List of Books | Search the DB2 Books ]