Configuring a Net.data INI file

Net.data runs by default without an INI file.

An INI file is required only to make use of or change the default settings for one of
the configurable directives supported by Net.data.

The directives that can be configured are documented in Chapter 2 of the
Net.Data Administration and Programming Guide for OS/400

The INI file is just a source physical file which may be edited via SEU or EDTF.
It must contain a member named INI and should exist in the same libary which
has been specified on the ScriptAlias directive of the HTTP Apache configuration.

If your Apache configuration specifies MYDEMO as the library name then:

CRTSRCPF FILE(MYDEMO/INI) RCDLEN(240) MBR(INI)

The most likely reason to initailly require an INI file is to change the default naming
convention for the SQL environment from SQL naming to SYSTEM naming.
SQL naming uses a dot for qualified names whereas SYSTEM naming uses a slash.
The other difference with SQL naming is that, it assumes that an unqualified file
name will be found in an SQL collection (or library) whose name defaults to the name
of the user profile who is running the SQL request. For the HTTP server this defaults
to the user profile of QTMHHTP1.

SYSTEM naming convention can be configured by editing the INI source file to add
the following statement:

DTW_SQL_NAMING_MODE SYSTEM_NAMING

It is normally useful to switch off commitment control (default is on)
This can be achieved with the satement:

DTW_SQL_ISOLATION = DTW_SQL_NO_COMMIT

While not strictly essential, the INI can prove quite useful, particularly for allowing
for multiple source repositories. However, it is mandatory if you wish to take
advantage of the Net.data email feature. It can also be used to register values for
global variables that can be retrieved by any Net.data script (macro).

To provide for the use of the built-in Net.data email function DTW_SENDMAIL the
following INI statement is required, given the domain name of your mail server.

DTW_SMTP_SERVER domain name of mail server