The following examples show ENVIRONMENT statements for language environments that Net.Data supplies. These examples illustrate how to specify parameters. The variables you include in the ENVIRONMENT statements are ones that you want to allow Net.Data macro writers to define or override in their macros. See the operating system-specific information in the appendixes in Net.Data Reference or in your Net.Data README file or Program Directory for additional examples.
The following examples show ENVIRONMENT statements for the Net.Data-provided langauge environment using the syntax for OS/2, AIX, and Windows NT.
ENVIRONMENT (DTW_SQL) DTWSQL ( IN DATABASE, LOGIN, PASSWORD, TRANSACTION_SCOPE, SHOWSQL, ALIGN, START_ROW_NUM, DTW_SET_TOTAL_ROWS) ENVIRONMENT (DTW_SYB) DTWSYB ( IN DATABASE, LOGIN, PASSWORD, TRANSACTION_SCOPE, SHOWSQL, ALIGN, START_ROW_NUM, DTW_SET_TOTAL_ROWS) ENVIRONMENT (DTW_ORA) DTWORA ( IN LOGIN, PASSWORD, TRANSACTION_SCOPE, SHOWSQL, ALIGN, START_ROW_NUM, DTW_SET_TOTAL_ROWS) ENVIRONMENT (DTW_ODBC) DTWODBC ( IN DATABASE, LOGIN, PASSWORD, TRANSACTION_SCOPE, SHOWSQL, ALIGN, DTW_SET_TOTAL_ROWS) ENVIRONMENT (DTW_APPLET) DTWJAVA () ENVIRONMENT (DTW_JAVAPPS) () CLIETTE "DTW_JAVAPPS" ENVIRONMENT (DTW_PERL) DTWPERL () ENVIRONMENT (DTW_REXX) DTWREXX () ENVIRONMENT (DTW_SYSTEM) DTWSYS () ENVIRONMENT (HWS_LE) DTWHWS ()
ENVIRONMENT statement can vary on each operating systems; for example OS/390 differs slightly for SQL and ODBC access:
ENVIRONMENT (DTW_SQL) DTWSQL ( IN LOCATION, DB2SSID, DB2PLAN, TRANSACTION_SCOPE) ENVIRONMENT (DTW_ODBC) DTWODBC ( IN LOCATION, TRANSACTION_SCOPE)