Index

A B C D E F G H I L M N O P R S T U V W X
A
  • absolute paths, for flat files (1391)
  • accessing flat files (1374)
  • ALIGN (1096)
  • alternate text, Web browsers (1140)
  • APPLET tag, alternate text (1141)
  • authorization requirement, FFI_PATH (1403)
  • B
  • built-in functions (1209)
  • C
  • calling
  • external programs (943)
  • functions (960)
  • calling FFI language environment (1378)
  • case, specifying for SQL commands (1125)
  • COMMENT block
  • description (931)
  • syntax (933)
  • conditional string processing (972), (1015)
  • conditional variables
  • description (1025)
  • example (1050)
  • with LIST statements (1027)
  • with variable references (1026)
  • configuring the FFI language environment (1396)
  • connecting to a database, DATABASE variable (1122)
  • connecting to DB2 subsystem
  • DB2 plan (1132)
  • location (1156)
  • subsystem ID (1136)
  • cookies
  • DTW_GETCOOKIE (1229)
  • DTW_PRINT_HEADER (1202)
  • DTW_SETCOOKIE (1243)
  • sending (1203)
  • current directory, determining for flat files (1384)
  • D
  • DATABASE (1120)
  • database consistency, transaction scope (1178)
  • date formats, UTF-8 (1223)
  • date variables (1182)
  • DB2PLAN (1129)
  • DB2SSID (1133)
  • DB_CASE (1123)
  • declaration part, macro (917)
  • DEFINE block
  • description (934)
  • syntax (937)
  • DEFINE statement
  • description (935)
  • syntax (938)
  • delimited string of values (1047)
  • delimiters, FFI language environment
  • ASCIITEXT (1406)
  • DELIMITED (1407)
  • DTWF_APPEND (1415)
  • DTWF_CLOSE (1414), (1417)
  • DTWF_DELETE (1419)
  • DTWF_INSERT (1421)
  • DTWF_OPEN (1413), (1423)
  • DTWF_READ (1425)
  • DTWF_READFILE (1427)
  • DTWF_REMOVE (1429)
  • DTWF_SEARCH (1431)
  • DTWF_UPDATE (1433)
  • DTWF_WRITE (1435)
  • DTWR_ADDENTRY (1438)
  • DTWR_CLEARREG (1440)
  • DTWR_CLOSEREG (1443)
  • DTWR_CREATEREG (1444)
  • DTWR_DELENTRY (1446)
  • DTWR_DELREG (1448)
  • DTWR_LISTREG (1450)
  • DTWR_LISTSUB (1452)
  • DTWR_OPENREG (1455)
  • DTWR_RTVENTRY (1456)
  • DTWR_UPDATEENTRY (1458)
  • DTW_ACCEPT (1462)
  • DTW_ADD (1251)
  • DTW_ADDQUOTE (1216)
  • DTW_APPLET_ALTTEXT (1138)
  • DTW_ASSIGN (1065), (1271), (1272)
  • DTW_CACHE_PAGE (1219)
  • DTW_CHARTOHEX (1275)
  • DTW_COMMIT (1464)
  • DTW_CONCAT (1277)
  • DTW_CURRENT_FILENAME (1184)
  • DTW_CURRENT_LAST_MODIFIED (1185)
  • DTW_DATE (1220)
  • DTW_DEFAULT_MESSAGE (1187)
  • DTW_DEFAULT_REPORT (1099)
  • DTW_DELSTR (1278)
  • DTW_DELWORD (1307)
  • DTW_DIVIDE (1253)
  • DTW_DIVREM (1255)
  • DTW_EDIT_CODES (1142)
  • DTW_FORMAT (1257)
  • DTW_GETCOOKIE (1228)
  • DTW_GETENV (1230)
  • DTW_GETINIDATA (1232)
  • DTW_HEXTOCHAR (1280)
  • DTW_HTMLENCODE (1234)
  • DTW_HTML_TABLE (1103)
  • DTW_INSERT (1282)
  • DTW_INTDIV (1259)
  • DTW_LASTPOS (1284)
  • DTW_LENGTH (1286)
  • DTW_LOG_LEVEL (1190)
  • DTW_LOWERCASE (1288)
  • DTW_MACRO_FILENAME (1191)
  • DTW_MACRO_LAST_MODIFIED (1192)
  • DTW_MBMODE (1194)
  • DTW_MP_PATH (1196)
  • DTW_MP_VERSION (1198)
  • DTW_MULTIPLY (1261), (1262)
  • DTW_PAD_PGM_PARMS (1144)
  • DTW_POS (1290)
  • DTW_POWER (1264)
  • DTW_PRINT_HEADER (1200)
  • DTW_QHTMLENCODE (1236)
  • DTW_REMOVE_WS (1204)
  • DTW_REPLACE (1293)
  • DTW_REVERSE (1295)
  • DTW_ROLLBACK (1466)
  • DTW_RTVHANDLE (1468)
  • DTW_SAVE_TABLE_IN (1146)
  • DTW_SENDMAIL (1239)
  • DTW_SETCOOKIE (1242)
  • DTW_SETENV (1244)
  • DTW_SET_TOTAL_ROWS (1149)
  • DTW_STATIC (1470)
  • DTW_STRIP (1297)
  • DTW_SUBSTR (1298)
  • DTW_SUBTRACT (1266)
  • DTW_SUBWORD (1309)
  • DTW_TB_APPENDROW (1322)
  • DTW_TB_COLS (1324)
  • DTW_TB_deleteCOL (1326)
  • DTW_TB_DELETEROW (1328)
  • DTW_TB_DLIST (1330)
  • DTW_TB_DUMPH (1332)
  • DTW_TB_DUMPV (1334)
  • DTW_TB_GETN (1336)
  • DTW_TB_GETV (1338)
  • DTW_TB_HTMLENCODE (1340)
  • DTW_TB_INPUT_CHECKBOX (1342)
  • DTW_TB_INPUT_RADIO (1344)
  • DTW_TB_INPUT_TEXT (1346)
  • DTW_TB_INSERTCOL (1349)
  • DTW_TB_INSERTROW (1351)
  • DTW_TB_LIST (1348)
  • DTW_TB_QUERYCOLNONJ (1354)
  • DTW_TB_ROWS (1356)
  • DTW_TB_SELECT (1358)
  • DTW_TB_SETCOLS (1360)
  • DTW_TB_SETN (1362)
  • DTW_TB_SETV (1364)
  • DTW_TB_TABLE (1367)
  • DTW_TB_TEXTAREA (1369)
  • DTW_TERMINATE (1472)
  • DTW_TIME (1246)
  • DTW_TRANSLATE (1300)
  • DTW_UPPERCASE (1302)
  • DTW_URLESCSEQ (1248)
  • DTW_USE_DB2_PREPARE_CACHE (1151)
  • DTW_WORD (1311)
  • DTW_WORDINDEX (1313)
  • DTW_WORDLENGTH (1315)
  • DTW_WORDPOS (1317)
  • DTW_WORDS (1319)
  • E
  • environment variables
  • description (1029)
  • ENVVAR statement (942)
  • example (1031)
  • ENVVAR statement (1030)
  • description (939)
  • syntax (940)
  • error handling (996)
  • EXEC block
  • description (946)
  • syntax (949)
  • EXEC statement (1034)
  • description (944)
  • syntax (945)
  • executable variables
  • as a variable reference (1036)
  • description (1033)
  • example (1035)
  • with parameters (1037)
  • EXEC_PATH (948)
  • EXEC_SQL (1473)
  • F
  • FFI functions
  • DTWF_APPEND (1416)
  • DTWF_CLOSE (1418)
  • DTWF_DELETE (1420)
  • DTWF_INSERT (1422)
  • DTWF_OPEN (1424)
  • DTWF_READ (1426)
  • DTWF_READFILE (1428)
  • DTWF_REMOVE (1430)
  • DTWF_SEARCH (1432)
  • DTWF_UPDATE (1434)
  • DTWF_WRITE (1436)
  • freeing files (1410)
  • locking files (1409)
  • FFI language environment
  • accessing files (1376)
  • authorization requirement (1402)
  • configuration rules (1395)
  • current directory (1386)
  • delimiters (1405)
  • file location (1382)
  • security recommendations (1399)
  • FFI_PATH
  • accessing flat files (1375)
  • configuration rules (1394)
  • flat file location (1379)
  • matching paths with filename parameter (1392)
  • security recommendations (1398)
  • syntax (1377)
  • file location variables (1181)
  • flat files
  • absolute paths (1390)
  • accessing (1373)
  • authorization requirement (1401)
  • configuration rules (1393)
  • creating in current directory (1388)
  • data sources (1372)
  • definition (1371)
  • delimiters (1404)
  • location
  • current directory (1381), (1385)
  • FFI_PATH (1380)
  • locking files (1408)
  • matching the FFI_PATH (1389)
  • recommendations for access (1387)
  • security recommendations (1397)
  • footers (980)
  • freeing files, FFI functions (1412)
  • FUNCTION block
  • description (950)
  • syntax (952)
  • function calls
  • description (961)
  • formatting output (1000)
  • processing table rows (1005)
  • syntax (963)
  • use of INOUT variables (964)
  • functions
  • description (1208)
  • flat file interface (FFI) (1370)
  • general (1214)
  • math (1250)
  • naming conventions (1210)
  • passing groups of values (1056)
  • persistent (1460)
  • string (1268)
  • table (1321)
  • Web registry (1437)
  • word (1304)
  • G
  • general functions (1215)
  • DTW_ADDQUOTE (1217)
  • DTW_CACHE_PAGE (1218)
  • DTW_DATE (1221)
  • DTW_EXIT (1224)
  • DTW_GETCOOKIE (1227)
  • DTW_GETENV (1231)
  • DTW_GETINIDATA (1233)
  • DTW_HTMLENCODE (1235)
  • DTW_QHTMLENCODE (1237)
  • DTW_SENDMAIL (1238)
  • DTW_SETCOOKIE (1241)
  • DTW_SETENV (1245)
  • DTW_TIME (1247)
  • DTW_URLESCSEQ (1249)
  • glossary (1484)
  • H
  • headers (979)
  • hidden variables
  • description (1039)
  • example, in an HTML form (1043)
  • steps (1042)
  • hiding variable names (1040)
  • HTML
  • displaying table results in (1106)
  • form, entering passwords (1168)
  • form, entering user IDs (1161)
  • hiding variable names (1041)
  • HTML block
  • description (966)
  • syntax (968)
  • HTML_INPUT block (1474)
  • HTML_REPORT block (1475)
  • I
  • IF block
  • description (969)
  • syntax (971)
  • IN keyword (953), (989), (1211)
  • include files (981)
  • INCLUDE statement
  • description (976)
  • syntax (978)
  • INCLUDE_PATH (982)
  • INCLUDE_URL (1476)
  • INOUT keyword (955), (991), (1213)
  • INOUT variable
  • example (965)
  • L
  • language constructs
  • COMMENT block (932)
  • common syntax elements (923)
  • DEFINE block or statement (936)
  • ENVVAR statement (941)
  • EXEC block or statement (947)
  • FUNCTION block (951)
  • function calls (962)
  • HTML block (967)
  • IF block (970)
  • INCLUDE statement (977)
  • LIST statement (984)
  • macro
  • description (930)
  • syntax (911)
  • MACRO_FUNCTION block (987)
  • MESSAGE block (994)
  • REPORT block (998)
  • ROW block (1003)
  • strings (928)
  • TABLE statement (1007)
  • variable name (925)
  • variable reference (927)
  • WHILE block (1013)
  • XML block (1021)
  • language environment variables
  • DATABASE (1121)
  • DB2PLAN (1130)
  • DB2SSID (1134)
  • DB_CASE (1124)
  • description (1119)
  • DTW_APPLET_ALTTEXT (1139)
  • DTW_EDIT_CODES (1143)
  • DTW_MBMODE (1195)
  • DTW_PAD_PGM_PARMS (1145)
  • DTW_SAVE_TABLE_IN (1147)
  • DTW_SET_TOTAL_ROWS (1150)
  • DTW_USE_DB2_PREPARE_CACHE (1152)
  • LOCATION (1154)
  • LOGIN (1159)
  • NULL_RPT_FIELD (1164)
  • PASSWORD (1166)
  • SHOWSQL (1171)
  • SQL_STATE (1174)
  • TRANSACTION_SCOPE (1177)
  • line length limits, macros (921)
  • LIST statement
  • description (983)
  • syntax (985)
  • list variables
  • description (1045)
  • example (1049)
  • value separators (1051)
  • listing delimited strings (1046)
  • local DB2 subsystem, ID (1137)
  • LOCATION (1153)
  • location, connecting to DB2 subsystem (1155)
  • location, flat files (1383)
  • locking files, FFI functions (1411)
  • LOGIN (1158)
  • looping (1016)
  • lower case, specifying (1128)
  • M
  • macros
  • common syntax elements (922)
  • declaration part (914)
  • format (918)
  • global syntax (913)
  • language constructs (912)
  • line length limits (920)
  • presentation part (915)
  • sample (919)
  • stop processing (1226)
  • MACRO_FUNCTION block
  • description (986)
  • syntax (988)
  • math functions
  • DTW_ADD (1252)
  • DTW_DIVIDE (1254)
  • DTW_DIVREM (1256)
  • DTW_FORMAT (1258)
  • DTW_INTDIV (1260)
  • DTW_MULTIPLY (1263)
  • DTW_POWER (1265)
  • DTW_SUBTRACT (1267)
  • MBCS support for functions
  • string functions (1270)
  • word functions (1306)
  • MESSAGE block
  • description (993)
  • syntax (995)
  • messages, default text (1189)
  • miscellaneous variables
  • description (1180)
  • DTW_CURRENT_FILENAME (1183)
  • DTW_CURRENT_LAST_MODIFIED (1186)
  • DTW_DEFAULT_MESSAGE (1188)
  • DTW_MACRO_LAST_MODIFIED (1193)
  • DTW_MP_PATH (1197)
  • DTW_MP_VERSION (1199)
  • DTW_PRINT_HEADER (1201)
  • DTW_REMOVE_WS (1205)
  • RETURN_CODE (1207)
  • N
  • Nn (1061)
  • Net.Data tables
  • defining (1009)
  • upper limit (1010)
  • Next button, RPT_MAX_ROWS (1116)
  • NLIST (1066)
  • NULL_RPT_FIELD (1163)
  • numeric comparison of strings (975), (1019)
  • NUM_COLUMNS (1070)
  • NUM_ROWS (1074)
  • O
  • operating system reference (1481)
  • OUT keyword (954), (990), (1212)
  • P
  • parameters, passing (959)
  • passing groups of values (1055)
  • passing parameters, System language environment (958)
  • PASSWORD (1165)
  • performance, DTW_EXIT (1225)
  • Persistent macro functions
  • DTW_ACCEPT (1461)
  • DTW_COMMIT (1463)
  • DTW_ROLLBACK (1465)
  • DTW_RTVHANDLE (1467)
  • DTW_STATIC (1469)
  • DTW_TERMINATE (1471)
  • plan, connecting to DB2 subsystem (1131)
  • platform support reference (1483)
  • presentation part, macro (916)
  • Previous button, RPT_MAX_ROWS (1117)
  • R
  • remote DB2 subsystem, location (1157)
  • REPORT block
  • ALIGN (1098)
  • description (997)
  • DTW_DEFAULT_REPORT (1101)
  • DTW_HTML_TABLE (1105)
  • Nn (1063)
  • NLIST (1068)
  • NUM_COLUMNS (1072)
  • NUM_ROWS (1076)
  • RPT_MAX_ROWS (1110)
  • START_ROW_NUM (1114)
  • syntax (999)
  • table variables (1057)
  • TOTAL_ROWS (1084)
  • report variables
  • ALIGN (1097)
  • description (1095)
  • DTW_DEFAULT_REPORT (1100)
  • DTW_HTML_TABLE (1104)
  • RPT_MAX_ROWS (1109)
  • START_ROW_NUM (1113)
  • reports
  • formatting (1001)
  • overriding Net.Data default (1102)
  • restricting database access (1162), (1169)
  • RETURNS keyword (956), (992)
  • RETURN_CODE (1206)
  • ROW block
  • description (1002)
  • Nn (1064)
  • NLIST (1069)
  • NUM_COLUMNS (1073)
  • NUM_ROWS (1077)
  • ROW_NUM (1080)
  • syntax (1004)
  • TOTAL_ROWS (1083)
  • Vn (1090), (1093)
  • V_columnName (1087)
  • ROW_NUM (1078)
  • RPT_MAX_ROWS (1108)
  • S
  • scrolling, with Next and Previous buttons (1115)
  • security
  • login ID (1160)
  • passwords (1167)
  • security recommendations, FFI_PATH (1400)
  • sending e-mail from the macro (1240)
  • SHOWSQL (1170)
  • SQL
  • commands, specifying case (1126)
  • hiding or displaying (1172)
  • SQL block (1477)
  • SQL state, displaying (1175)
  • SQL_CODE (1480)
  • SQL_MESSAGE block (1478)
  • SQL_REPORT block (1479)
  • SQL_STATE (1173)
  • START_ROW_NUM (1112)
  • string functions
  • DTW_ASSIGN (1273)
  • DTW_CHARTOHEX (1274)
  • DTW_CONCAT (1276)
  • DTW_DELSTR (1279)
  • DTW_HEXTOCHAR
  • DTW_HEXTOCHAR (1281)
  • DTW_INSERT
  • DTW_INSERT (1283)
  • DTW_LASTPOS (1285)
  • DTW_LENGTH (1287)
  • DTW_LOWERCASE (1289)
  • DTW_POS (1291)
  • DTW_REPLACE (1292)
  • DTW_REVERSE (1294)
  • DTW_STRIP (1296)
  • DTW_SUBSTR (1299)
  • DTW_TRANSLATE (1301)
  • DTW_UPPERCASE (1303)
  • MBCS support (1269)
  • strings
  • conditional processing (974), (1018)
  • description (929)
  • numeric comparisons (973), (1017)
  • of values, delimited (1048)
  • subsytem ID, connecting to DB2 subsystem (1135)
  • supported features table (1482)
  • System language environment, passing parameters (957)
  • T
  • table functions
  • DTW_TB_APPENDROW (1323)
  • DTW_TB_COLS (1325)
  • DTW_TB_DELETECOL (1327)
  • DTW_TB_DELETEROW (1329)
  • DTW_TB_DLIST (1331)
  • DTW_TB_DUMPH (1333)
  • DTW_TB_DUMPV (1335)
  • DTW_TB_GETN (1337)
  • DTW_TB_GETV (1339)
  • DTW_TB_HTMLENCODE (1341)
  • DTW_TB_INPUT_CHECKBOX (1343)
  • DTW_TB_INPUT_RADIO (1345)
  • DTW_TB_INPUT_TEXT (1347)
  • DTW_TB_INSERTCOL (1350)
  • DTW_TB_INSERTROW (1352)
  • DTW_TB_LIST (1353)
  • DTW_TB_QUERYCOLNONJ (1355)
  • DTW_TB_ROWS (1357)
  • DTW_TB_SELECT (1359)
  • DTW_TB_SETCOLS (1361)
  • DTW_TB_SETN (1363)
  • DTW_TB_SETV (1365)
  • DTW_TB_TABLE (1366)
  • DTW_TB_TEXTAREA (1368)
  • table processing variables
  • description (1060)
  • Nn (1062)
  • NLIST (1067)
  • NUM_COLUMNS (1071)
  • NUM_ROWS (1075)
  • ROW_NUM (1079)
  • specifying for SQL language environment (1148)
  • TOTAL_ROWS (1082)
  • Vn (1092)
  • VLIST (1089)
  • V_columnName (1086)
  • TABLE statement (1052)
  • description (1006)
  • syntax (1008)
  • table variables
  • description (1053)
  • example (1058)
  • tables
  • Net.Data, specifying number of rows (1111)
  • results in HTML (1107)
  • TOTAL_ROWS (1081)
  • TRANSACTION_SCOPE (1176)
  • U
  • upper case, specifying (1127)
  • upper limit (1011)
  • UTF-8 format
  • date (1222)
  • V
  • variable name (924)
  • variable reference (926)
  • variables
  • conditional (1024)
  • environment (1028)
  • executable (1032)
  • hidden (1038)
  • language environment (1118)
  • list (1044)
  • miscellaneous (1179)
  • Net.Data, overview (1023)
  • report (1094)
  • table (1054), (1059)
  • VLIST (1088)
  • Vn (1091)
  • V_columnName (1085)
  • W
  • Web registry functions
  • DTWR_ADDENTRY (1439)
  • DTWR_CLEARREG (1441)
  • DTWR_CLOSEREG (1442)
  • DTWR_CREATEREG (1445)
  • DTWR_DELENTRY (1447)
  • DTWR_DELREG (1449)
  • DTWR_LISTREG (1451)
  • DTWR_LISTSUB (1453)
  • DTWR_OPENREG (1454)
  • DTWR_RTVENTRY (1457)
  • DTWR_UPDATEENTRY (1459)
  • WHILE block
  • description (1012)
  • syntax (1014)
  • word functions
  • DTW_DELWORD (1308)
  • DTW_SUBWORD (1310)
  • DTW_WORD (1312)
  • DTW_WORDINDEX (1314)
  • DTW_WORDLENGTH (1316)
  • DTW_WORDPOS (1318)
  • DTW_WORDS (1320)
  • MBCS support (1305)
  • X
  • XML block
  • description (1020)
  • syntax (1022)

  • [ Top of Page | Previous Page | Next Page | Index ]