Administration and Programming Guide for OS/400

Index

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

access rights

for language environments (1018)

for Net.Data files (800)

accessing DB2 (1058)

authentication, security (812)

authorization

security (815)

specifying access rights to Net.Data files (802)

BLOBs (1066), (1069)

blocks, macro (875)

caching macros, cache size (737)

calling (1044), (1049), (1089), (1097), (1140)

functions (953)

Java applications (1037)

language environments (1010)

programs, Direct Call (1024)

programs, System (1141)

REXX programs (1045), (1050)

stored procedures (1090), (1098)

CGI-BIN library, copying Net.Data program object (714)

CLOBs (1067)

common errors when passing parameters (1030), (1084)

conditional

logic, IF blocks (1000)

variables (916)

configuration variable statements

configuring in the initialization file (731)

description (730)

DTWR_CLOSE_REGISTRIES (765)

DTW_MACRO_CACHE_SIZE (735)

DTW_PAD_PGM_PARMS (739)

DTW_SHOWSQL (743)

DTW_SMTP_CCSID (746)

DTW_SMTP_CHARSET (750)

DTW_SMTP_SERVER (754)

DTW_SQL_ISOLATION (757)

DTW_SQL_NAMING_MODE (761)

configuring Net.Data

access rights to Net.Data files (805)

initialization file

configuration variable statements (728)

creating (720)

description (717)

ENVIRONMENT statements (783)

path statements (768)

updating (719)

overview (710)

setting up language environments (797)

copying Net.Data program object

to CGI-BIN library (712)

to multiple libraries (715)

creating initialization file (727)

data types (1070), (1079), (1093)

DATALINK (1080)

for Direct Call (1028)

for stored procedures (1094)

LOBs (1071)

DATALINK data type (1076), (1081)

DataLink File Manager (1077)

Encoding URLs (1082)

DBCLOBs (1068)

declaration part, macro structure (869)

default reports (1113), (1125)

printing (988)

specifying for stored procedures (1114), (1126)

DEFINE block

defining variables (903)

description (876)

defining variables

DEFINE statement or block (902)

HTML form SELECT, INPUT, and TEXTAREA tags (904)

query string data (906)

Direct Call language environment

calling programs (1023)

common errors when passing parameters (1029)

overview (1021)

passing parameters (1025)

returning values from programs (1031)

supported data types (1027)

DTWR_CLOSE_REGISTRIES (767)

DTW_DEFAULT_REPORT (995)

DTW_DIRECTCALL (1022)

DTW_JAVAPPS (1034)

DTW_JAVA_CLASSPATH (782)

DTW_MACRO_CACHE_SIZE (736)

DTW_PAD_PGM_PARMS (740)

DTW_REXX (1046)

DTW_SHOWSQL (744)

DTW_SMTP_CCSID (747)

DTW_SMTP_CHARSET (751)

DTW_SMTP_SERVER (755)

DTW_SQL (1059)

DTW_SQL_ISOLATION (759)

DTW_SQL_NAMING_MODE (763)

DTW_SYSTEM (1136)

dynamically generating variable names (912)

encoding DataLink URLs in result sets (1078)

encryption, network (810)

ENVIRONMENT statements

configuring in the initialization file (786), (790)

description (785)

example (795)

for user-defined language environments (725)

language environment type (792)

parameter list (794)

service program (793)

syntax (791)

environment variables (918)

error conditions, language environments (1012)

executable variables (920)

executing commands (1135)

executing SQL statements (1057)

FFI_PATH (778)

files, specifying access rights to Net.Data (803)

firewalls (808)

flat file functions (966)

footer information, REPORT block (984)

formatting data output (981)

forms (836), (855)

in Web pages to invoke Net.Data (856)

invoking Net.Data (837), (860), (1152)

FUNCTION block

calling functions (950)

description (878)

formatting output (982)

identifier scope (895)

function calls

built-in (954)

syntax (952)

functions (1087)

calling (949)

calling stored procedures (1088)

defining (937)

description (936)

flat file (965)

FUNCTION block syntax (939)

general purpose (955)

MACRO_FUNCTION block syntax (941)

math (957)

persistent (969)

string (959)

table (963)

user-defined (938)

Web Registry (967)

word (961)

general purpose functions (956)

global identifier scope (891)

glossary (1164)

header information, REPORT block (985)

hidden variables

conceal variable names (922)

protecting assets (819)

HTML (833), (840), (847), (852)

blocks

description (880)

example (975)

invoking Net.Data (973)

processing (978)

FORM Submit button (977)

forms (841), (853)

about (854)

invoking Net.Data (842), (862), (1154)

SELECT, INPUT, and TEXTAREA tags, defining variables (905)

generating in a macro (971)

links (834), (848)

about (849)

invoking Net.Data (835), (859), (1151)

tags for tables (986)

unrecognized data as (976)

HTML_PATH (780)

identifier scope (890)

IF blocks (1003)

improving performance (1157)

INCLUDE_PATH (776)

initialization file

configuration variable statements (729)

creating (722), (726)

description (718)

ENVIRONMENT statements (784)

format (723)

path statements (769)

updating (721)

invoking Net.Data (824), (831), (838), (845)

forms (839), (861), (1153)

HTML blocks (974)

links (832), (858), (1150)

overview (821)

URLs (846), (864), (1156)

using CGI (822)

with a macro (825)

Java Application language environment

calling programs (1036)

overview (1033)

passing parameters (1038)

setting up (798)

language environments (1040), (1131)

calling (1009)

configuring ENVIRONMENT statements (787)

configuring in the initialization file (788)

Direct Call (1020)

examples (789)

handling error conditions (1011)

Java Application (1035)

REXX (1041)

security (1015)

setting up (796)

SQL (1055)

supported (1008)

System (1132)

variables (934)

large objects (LOBs) (1062), (1074)

description (1063)

valid formats (1075)

links (829), (850)

in Web pages to invoke Net.Data (851)

invoking Net.Data (830), (857), (1149)

list variables (924)

LOBs (large objects) (1064), (1072)

supported types (1073)

with SQL and ODBC language environments (1065)

looping, WHILE blocks (1004)

macro request (826)

examples (828)

syntax (827)

macros

anatomy (872)

blocks (874)

conditional logic (1001)

declaration part (867)

DEFINE block (877)

description (707)

developing (865)

FUNCTION block (879)

functions (935)

generating HTML (972)

HTML block (881)

identifier scope (893)

IF blocks (1002)

looping (1005)

navigation within and between (883)

persistent (1146)

presentation part (868)

sample (873)

variables (884)

WHILE blocks (1006)

MACRO_FUNCTION block

calling functions (951)

syntax (942)

MACRO_PATH (773)

math functions (958)

MESSAGE block

description (943)

example (948)

processing (944)

scope (947)

syntax (946)

miscellaneous variables (928)

multiple report blocks (990)

navigation, within and between macros (882)

Net.Data

configuring (711)

files, access rights (804)

invoking (823)

macros, developing (866)

overview (708)

security mechanisms (816)

Net.Data macros. See macros. (709)

Net.Data Program Object

copying to CGI-BIN libraries (713)

copying to multiple libraries (716)

Notices (1163)

parts of a macro

declaration (870)

presentation (871)

passing parameters (1053), (1101), (1144)

Direct Call language environment (1026)

Java Application language environment (1039)

REXX programs (1054)

stored procedures (1102)

System language environment (1145)

path statements

configuring in the initialization file (770)

DTW_JAVA_CLASSPATH (781)

EXEC_PATH (774)

FFI_PATH (777)

HTML_PATH (779)

INCLUDE_PATH (775)

MACRO_PATH (772)

protecting assets (818)

update guidelines (771)

performance

optimizing language environments (1158)

REXX language environment (1159)

SQL language environment (1160)

System language environment (1161)

persistent functions (970)

persistent macros (1147)

printing, disabling for default reports (987)

processing result sets, stored procedures (1105)

protecting assets (807)

referencing variables (909)

REPORT block (1117)

stored procedures (1118)

REPORT blocks (1129)

default reports (993)

description (979)

examples (996)

formatting data output (980)

guidelines for multiple (997)

header and footer information (983)

multiple (991)

restrictions (998)

scope (897)

stored procedures (1130)

report formats, customizing (989)

report variables (932)

reports

default (994)

generating multiple with one function call (992)

result sets (1106), (1111), (1122)

multiple (1123)

default reports (1124)

guidelines and restrictions (999)

processing, stored procedures (1107)

single (1112)

returning values from programs (1032)

RETURN_CODE variable (945), (1013)

REXX language environment (1042), (1047), (1051)

calling programs (1048)

overview (1043)

passing parameters (1052)

ROW block, identifier scope (899)

sample macro (1162)

scope, identifier

FUNCTION block (896)

global (892)

macro (894)

REPORT block (898)

ROW block (900)

security

authentication (813)

authorization (814)

firewall (809)

language environments (1016)

Net.Data mechanisms (817)

network encryption (811)

overview (806)

specifying access rights (801), (1017)

SQL

isolation configuration variable (758)

naming mode configuration variable (762)

SQL language environment

common errors when passing parameters (1083)

executing SQL statements (1060)

overview (1056)

setting up (799)

SQL statements, executing (1061)

SQLCODEs (1014), (1019)

starting Net.Data (820)

stored procedures (1085), (1091), (1095), (1099), (1103) , (1108), (1115), (1119), (1127)

calling from macro (1086)

default reports (1110), (1121)

multiple result sets (1120)

passing parameters (1100)

processing result sets (1104)

REPORT blocks (1116), (1128)

single result sets (1109)

steps (1096)

valid data types (1092)

string functions (960)

System language environment (1133), (1137), (1142)

calling programs (1138)

issuing commands (1139)

overview (1134)

passing parameters (1143)

table functions (964)

table processing variables (930)

table variables (926)

token sizes (888)

transaction processing (1148)

types, variable (914)

URLs (843)

defining variables (907)

invoking Net.Data (844), (863), (1155)

user-defined functions (940)

user-defined language environments, ENVIRONMENT statements (724)

variables

conditional (915)

configuration, statements

description (732)

disable SHOWSQL (DTW_SHOWSQL) (742)

e-mail SMTP CCSID (DTW_SMTP_CCSID) (745)

e-mail SMTP character set (DTW_SMTP_CHARSET) (748)

e-mail SMTP server (DTW_SMTP_SERVER) (752)

enable SHOWSQL (DTW_SHOWSQL) (741)

initialization file (733)

macro cache size (DTW_MACRO_CACHE_SIZE) (734)

padding parameters with blanks (DTW_PAD_PGM_PARMS) (738)

SMTP character sets (DTW_SMTP_CHARSET) (749)

SMTP server (DTW_SMTP_SERVER) (753)

SQL isolation (DTW_SQL_ISOLATION) (756)

SQL naming mode (DTW_SQL_NAMING_MODE) (760)

Web registry close (DTWR_CLOSE_REGISTRIES) (764)

defining (901)

description (885)

dynamically-generated references (910)

environment (917)

executable (919)

generating names dynamically (911)

hidden (921)

language environment (933)

list (923)

miscellaneous (927)

referencing (908)

report (931)

scope (889)

table (925)

table processing (929)

token sizes (887)

types (886), (913)

Web Registry functions (968)

Web registry, close variable (766)

WHILE blocks (1007)

word functions (962)

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