Reference

Index

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

absolute paths, for flat files (1386)

accessing flat files (1369)

ALIGN (1093)

alternate text, Web browsers (1137)

APPLET tag, alternate text (1138)

authorization requirement, FFI_PATH (1398)

built-in functions (1204)

calling

external programs (940)

functions (957)

calling FFI language environment (1373)

case, specifying for SQL commands (1122)

COMMENT block

description (928)

syntax (930)

conditional string processing (969), (1015)

conditional variables

description (1022)

example (1047)

with LIST statements (1024)

with variable references (1023)

configuring the FFI language environment (1391)

connecting to a database, DATABASE variable (1119)

connecting to DB2 subsystem

DB2 plan (1129)

location (1151)

subsystem ID (1133)

DTW_GETCOOKIE (1224)

DTW_PRINT_HEADER (1197)

DTW_SETCOOKIE (1238)

sending (1198)

current directory, determining for flat files (1379)

DATABASE (1117)

database consistency, transaction scope (1173)

date formats, UTF-8 (1218)

date variables (1177)

DB2 WWW Connection, language constructs (1466)

DB2PLAN (1126)

DB2SSID (1130)

DB_CASE (1120)

declaration part, macro (914)

DEFINE block

description (931)

syntax (934)

DEFINE statement

description (932)

syntax (935)

delimited string of values (1044)

delimiters, FFI language environment

ASCIITEXT (1401)

DELIMITED (1402)

DTWF_APPEND (1410)

DTWF_CLOSE (1409), (1412)

DTWF_DELETE (1414)

DTWF_INSERT (1416)

DTWF_OPEN (1408), (1418)

DTWF_READ (1420)

DTWF_REMOVE (1422)

DTWF_SEARCH (1424)

DTWF_UPDATE (1426)

DTWF_WRITE (1428)

DTWR_ADDENTRY (1431)

DTWR_CLEARREG (1433)

DTWR_CLOSEREG (1436)

DTWR_CREATEREG (1437)

DTWR_DELENTRY (1439)

DTWR_DELREG (1441)

DTWR_LISTREG (1443)

DTWR_LISTSUB (1445)

DTWR_OPENREG (1448)

DTWR_RTVENTRY (1449)

DTWR_UPDATEENTRY (1451)

DTW_ACCEPT (1455)

DTW_ADD (1246)

DTW_ADDQUOTE (1211)

DTW_APPLET_ALTTEXT (1135)

DTW_ASSIGN (1062), (1266), (1267)

DTW_CACHE_PAGE (1214)

DTW_CHARTOHEX (1270)

DTW_COMMIT (1457)

DTW_CONCAT (1272)

DTW_CURRENT_FILENAME (1179)

DTW_CURRENT_LAST_MODIFIED (1180)

DTW_DATE (1215)

DTW_DEFAULT_MESSAGE (1182)

DTW_DEFAULT_REPORT (1096)

DTW_DELSTR (1273)

DTW_DELWORD (1302)

DTW_DIVIDE (1248)

DTW_DIVREM (1250)

DTW_EDIT_CODES (1139)

DTW_FORMAT (1252)

DTW_GETCOOKIE (1223)

DTW_GETENV (1225)

DTW_GETINIDATA (1227)

DTW_HEXTOCHAR (1275)

DTW_HTMLENCODE (1229)

DTW_HTML_TABLE (1100)

DTW_INSERT (1277)

DTW_INTDIV (1254)

DTW_LASTPOS (1279)

DTW_LENGTH (1281)

DTW_LOG_LEVEL (1185)

DTW_LOWERCASE (1283)

DTW_MACRO_FILENAME (1186)

DTW_MACRO_LAST_MODIFIED (1187)

DTW_MBMODE (1189)

DTW_MP_PATH (1191)

DTW_MP_VERSION (1193)

DTW_MULTIPLY (1256), (1257)

DTW_PAD_PGM_PARMS (1141)

DTW_POS (1285)

DTW_POWER (1259)

DTW_PRINT_HEADER (1195)

DTW_QHTMLENCODE (1231)

DTW_REMOVE_WS (1199)

DTW_REPLACE (1288)

DTW_REVERSE (1290)

DTW_ROLLBACK (1459)

DTW_RTVHANDLE (1461)

DTW_SAVE_TABLE_IN (1143)

DTW_SENDMAIL (1234)

DTW_SETCOOKIE (1237)

DTW_SETENV (1239)

DTW_SET_TOTAL_ROWS (1146)

DTW_STATIC (1463)

DTW_STRIP (1292)

DTW_SUBSTR (1293)

DTW_SUBTRACT (1261)

DTW_SUBWORD (1304)

DTW_TB_APPENDROW (1317)

DTW_TB_COLS (1319)

DTW_TB_deleteCOL (1321)

DTW_TB_DELETEROW (1323)

DTW_TB_DLIST (1325)

DTW_TB_DUMPH (1327)

DTW_TB_DUMPV (1329)

DTW_TB_GETN (1331)

DTW_TB_GETV (1333)

DTW_TB_HTMLENCODE (1335)

DTW_TB_INPUT_CHECKBOX (1337)

DTW_TB_INPUT_RADIO (1339)

DTW_TB_INPUT_TEXT (1341)

DTW_TB_INSERTCOL (1344)

DTW_TB_INSERTROW (1346)

DTW_TB_LIST (1343)

DTW_TB_QUERYCOLNONJ (1349)

DTW_TB_ROWS (1351)

DTW_TB_SELECT (1353)

DTW_TB_SETCOLS (1355)

DTW_TB_SETN (1357)

DTW_TB_SETV (1359)

DTW_TB_TABLE (1362)

DTW_TB_TEXTAREA (1364)

DTW_TERMINATE (1465)

DTW_TIME (1241)

DTW_TRANSLATE (1295)

DTW_UPPERCASE (1297)

DTW_URLESCSEQ (1243)

DTW_WORD (1306)

DTW_WORDINDEX (1308)

DTW_WORDLENGTH (1310)

DTW_WORDPOS (1312)

DTW_WORDS (1314)

environment variables

description (1026)

ENVVAR statement (939)

example (1028)

ENVVAR statement (1027)

description (936)

syntax (937)

error handling (996)

EXEC block

description (943)

syntax (946)

EXEC statement (1031)

description (941)

syntax (942)

executable variables

as a variable reference (1033)

description (1030)

example (1032)

with parameters (1034)

EXEC_PATH (945)

EXEC_SQL (1468)

FFI functions

DTWF_APPEND (1411)

DTWF_CLOSE (1413)

DTWF_DELETE (1415)

DTWF_INSERT (1417)

DTWF_OPEN (1419)

DTWF_READ (1421)

DTWF_REMOVE (1423)

DTWF_SEARCH (1425)

DTWF_UPDATE (1427)

DTWF_WRITE (1429)

freeing files (1405)

locking files (1404)

FFI language environment

accessing files (1371)

authorization requirement (1397)

configuration rules (1390)

current directory (1381)

delimiters (1400)

file location (1377)

security recommendations (1394)

FFI_PATH

accessing flat files (1370)

configuration rules (1389)

flat file location (1374)

matching paths with filename parameter (1387)

security recommendations (1393)

syntax (1372)

file location variables (1176)

flat files

absolute paths (1385)

accessing (1368)

authorization requirement (1396)

configuration rules (1388)

creating in current directory (1383)

data sources (1367)

definition (1366)

delimiters (1399)

location

current directory (1376), (1380)

FFI_PATH (1375)

locking files (1403)

matching the FFI_PATH (1384)

recommendations for access (1382)

security recommendations (1392)

footers (977)

freeing files, FFI functions (1407)

FUNCTION block

description (947)

syntax (949)

function calls

description (958)

formatting output (1000)

processing table rows (1005)

syntax (960)

use of INOUT variables (961)

functions

description (1203)

flat file interface (FFI) (1365)

general (1209)

math (1245)

naming conventions (1205)

passing groups of values (1053)

persistent (1453)

string (1263)

table (1316)

Web registry (1430)

word (1299)

general functions (1210)

DTW_ADDQUOTE (1212)

DTW_CACHE_PAGE (1213)

DTW_DATE (1216)

DTW_EXIT (1219)

DTW_GETCOOKIE (1222)

DTW_GETENV (1226)

DTW_GETINIDATA (1228)

DTW_HTMLENCODE (1230)

DTW_QHTMLENCODE (1232)

DTW_SENDMAIL (1233)

DTW_SETCOOKIE (1236)

DTW_SETENV (1240)

DTW_TIME (1242)

DTW_URLESCSEQ (1244)

glossary (1479)

headers (976)

hidden variables

description (1036)

example, in an HTML form (1040)

steps (1039)

hiding variable names (1037)

HTML

displaying table results in (1103)

form, entering passwords (1163)

form, entering user IDs (1156)

hiding variable names (1038)

HTML block

description (963)

syntax (965)

HTML_INPUT block (1469)

HTML_REPORT block (1470)

IF block

description (966)

syntax (968)

IN keyword (950), (989), (1206)

include files (978)

INCLUDE statement

description (973)

syntax (975)

INCLUDE_PATH (979)

INCLUDE_URL statement

description (980)

syntax (982)

INOUT keyword (952), (991), (1208)

INOUT variable

example (962)

language constructs

COMMENT block (929)

common syntax elements (920)

DB2 WWW Connection (1467)

DEFINE block or statement (933)

ENVVAR statement (938)

EXEC block or statement (944)

FUNCTION block (948)

function calls (959)

HTML block (964)

IF block (967)

INCLUDE statement (974)

INCLUDE_URL statement (981)

LIST statement (984)

macro

description (927)

syntax (908)

MACRO_FUNCTION block (987)

MESSAGE block (994)

REPORT block (998)

ROW block (1003)

strings (925)

TABLE statement (1007)

variable name (922)

variable reference (924)

WHILE block (1013)

language environment variables

DATABASE (1118)

DB2PLAN (1127)

DB2SSID (1131)

DB_CASE (1121)

description (1116)

DTW_APPLET_ALTTEXT (1136)

DTW_EDIT_CODES (1140)

DTW_MBMODE (1190)

DTW_PAD_PGM_PARMS (1142)

DTW_SAVE_TABLE_IN (1144)

DTW_SET_TOTAL_ROWS (1147)

LOCATION (1149)

NULL_RPT_FIELD (1159)

PASSWORD (1161)

SHOWSQL (1166)

SQL_STATE (1169)

TRANSACTION_SCOPE (1172)

line length limits, macros (918)

LIST statement

description (983)

syntax (985)

list variables

description (1042)

example (1046)

value separators (1048)

listing delimited strings (1043)

local DB2 subsystem, ID (1134)

LOCATION (1148)

location, connecting to DB2 subsystem (1150)

location, flat files (1378)

locking files, FFI functions (1406)

looping (1016)

lower case, specifying (1125)

macros

common syntax elements (919)

declaration part (911)

format (915)

global syntax (910)

language constructs (909)

line length limits (917)

presentation part (912)

sample (916)

stop processing (1221)

MACRO_FUNCTION block

description (986)

syntax (988)

math functions

DTW_ADD (1247)

DTW_DIVIDE (1249)

DTW_DIVREM (1251)

DTW_FORMAT (1253)

DTW_INTDIV (1255)

DTW_MULTIPLY (1258)

DTW_POWER (1260)

DTW_SUBTRACT (1262)

MBCS support for functions

string functions (1265)

word functions (1301)

MESSAGE block

description (993)

syntax (995)

messages, default text (1184)

miscellaneous variables

description (1175)

DTW_CURRENT_FILENAME (1178)

DTW_CURRENT_LAST_MODIFIED (1181)

DTW_DEFAULT_MESSAGE (1183)

DTW_MACRO_LAST_MODIFIED (1188)

DTW_MP_PATH (1192)

DTW_MP_VERSION (1194)

DTW_PRINT_HEADER (1196)

DTW_REMOVE_WS (1200)

RETURN_CODE (1202)

Nn (1058)

Net.Data tables

defining (1009)

upper limit (1010)

Next button, RPT_MAX_ROWS (1113)

NLIST (1063)

Notices (1478)

NULL_RPT_FIELD (1158)

numeric comparison of strings (972), (1019)

NUM_COLUMNS (1067)

NUM_ROWS (1071)

operating system reference (1475)

OUT keyword (951), (990), (1207)

parameters, passing (956)

passing groups of values (1052)

passing parameters, System language environment (955)

PASSWORD (1160)

performance, DTW_EXIT (1220)

Persistent macro functions

DTW_ACCEPT (1454)

DTW_COMMIT (1456)

DTW_ROLLBACK (1458)

DTW_RTVHANDLE (1460)

DTW_STATIC (1462)

DTW_TERMINATE (1464)

plan, connecting to DB2 subsystem (1128)

platform support reference (1477)

presentation part, macro (913)

Previous button, RPT_MAX_ROWS (1114)

remote DB2 subsystem, location (1152)

REPORT block

ALIGN (1095)

description (997)

DTW_DEFAULT_REPORT (1098)

DTW_HTML_TABLE (1102)

Nn (1060)

NLIST (1065)

NUM_COLUMNS (1069)

NUM_ROWS (1073)

RPT_MAX_ROWS (1107)

START_ROW_NUM (1111)

syntax (999)

table variables (1054)

TOTAL_ROWS (1081)

report variables

ALIGN (1094)

description (1092)

DTW_DEFAULT_REPORT (1097)

DTW_HTML_TABLE (1101)

RPT_MAX_ROWS (1106)

START_ROW_NUM (1110)

reports

formatting (1001)

overriding Net.Data default (1099)

restricting database access (1157), (1164)

RETURNS keyword (953), (992)

RETURN_CODE (1201)

ROW block

description (1002)

Nn (1061)

NLIST (1066)

NUM_COLUMNS (1070)

NUM_ROWS (1074)

ROW_NUM (1077)

syntax (1004)

TOTAL_ROWS (1080)

Vn (1087), (1090)

V_columnName (1084)

ROW_NUM (1075)

RPT_MAX_ROWS (1105)

scrolling, with Next and Previous buttons (1112)

security

passwords (1162)

security recommendations, FFI_PATH (1395)

sending e-mail from the macro (1235)

SHOWSQL (1165)

SQL

commands, specifying case (1123)

hiding or displaying (1167)

SQL block (1471)

SQL state, displaying (1170)

SQL_CODE (1474)

SQL_MESSAGE block (1472)

SQL_REPORT block (1473)

SQL_STATE (1168)

START_ROW_NUM (1109)

string functions

DTW_ASSIGN (1268)

DTW_CHARTOHEX (1269)

DTW_CONCAT (1271)

DTW_DELSTR (1274)

DTW_HEXTOCHAR

DTW_HEXTOCHAR (1276)

DTW_INSERT

DTW_INSERT (1278)

DTW_LASTPOS (1280)

DTW_LENGTH (1282)

DTW_LOWERCASE (1284)

DTW_POS (1286)

DTW_REPLACE (1287)

DTW_REVERSE (1289)

DTW_STRIP (1291)

DTW_SUBSTR (1294)

DTW_TRANSLATE (1296)

DTW_UPPERCASE (1298)

MBCS support (1264)

strings

conditional processing (971), (1018)

description (926)

numeric comparisons (970), (1017)

of values, delimited (1045)

subsytem ID, connecting to DB2 subsystem (1132)

supported features table (1476)

System language environment, passing parameters (954)

table functions

DTW_TB_APPENDROW (1318)

DTW_TB_COLS (1320)

DTW_TB_DELETECOL (1322)

DTW_TB_DELETEROW (1324)

DTW_TB_DLIST (1326)

DTW_TB_DUMPH (1328)

DTW_TB_DUMPV (1330)

DTW_TB_GETN (1332)

DTW_TB_GETV (1334)

DTW_TB_HTMLENCODE (1336)

DTW_TB_INPUT_CHECKBOX (1338)

DTW_TB_INPUT_RADIO (1340)

DTW_TB_INPUT_TEXT (1342)

DTW_TB_INSERTCOL (1345)

DTW_TB_INSERTROW (1347)

DTW_TB_LIST (1348)

DTW_TB_QUERYCOLNONJ (1350)

DTW_TB_ROWS (1352)

DTW_TB_SELECT (1354)

DTW_TB_SETCOLS (1356)

DTW_TB_SETN (1358)

DTW_TB_SETV (1360)

DTW_TB_TABLE (1361)

DTW_TB_TEXTAREA (1363)

table processing variables

description (1057)

Nn (1059)

NLIST (1064)

NUM_COLUMNS (1068)

NUM_ROWS (1072)

ROW_NUM (1076)

specifying for SQL language environment (1145)

TOTAL_ROWS (1079)

Vn (1089)

VLIST (1086)

V_columnName (1083)

TABLE statement (1049)

description (1006)

syntax (1008)

table variables

description (1050)

example (1055)

tables

Net.Data, specifying number of rows (1108)

results in HTML (1104)

TOTAL_ROWS (1078)

TRANSACTION_SCOPE (1171)

upper case, specifying (1124)

upper limit (1011)

UTF-8 format

date (1217)

variable name (921)

variable reference (923)

variables

conditional (1021)

environment (1025)

executable (1029)

hidden (1035)

language environment (1115)

list (1041)

miscellaneous (1174)

Net.Data, overview (1020)

report (1091)

table (1051), (1056)

VLIST (1085)

Vn (1088)

V_columnName (1082)

Web registry functions

DTWR_ADDENTRY (1432)

DTWR_CLEARREG (1434)

DTWR_CLOSEREG (1435)

DTWR_CREATEREG (1438)

DTWR_DELENTRY (1440)

DTWR_DELREG (1442)

DTWR_LISTREG (1444)

DTWR_LISTSUB (1446)

DTWR_OPENREG (1447)

DTWR_RTVENTRY (1450)

DTWR_UPDATEENTRY (1452)

WHILE block

description (1012)

syntax (1014)

word functions

DTW_DELWORD (1303)

DTW_SUBWORD (1305)

DTW_WORD (1307)

DTW_WORDINDEX (1309)

DTW_WORDLENGTH (1311)

DTW_WORDPOS (1313)

DTW_WORDS (1315)

MBCS support (1300)

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