The following DB2 SQL preprocessor options are supported by the Open PL/I driver program, mfplx:
- -bind or -nobind
- Determines whether or not a bind file is created. The bind file's name is specified by the
-bindname option, if that option is used. Otherwise, the name defaults to the name of the input source file with the suffix
.bnd.
- -bindname
b
- Specifies the bind file name,
b, if one is created.
- -block
t
- Specifies the type of record blocking,
t, to be used and how ambiguous cursors are to be treated. The valid types are:
| unambig
|
Blocking occurs for read-only cursors, those that are not specified as FOR UPDATE OF, have no static DELETE WHERE CURRENT OF statements, and have no dynamic statements. Ambiguous cursors can be updated.
|
| all
|
Blocking occurs for read-only cursors, those that are not specified as FOR UPDATE OF, and for which no static DELETE WHERE CURRENT OF statements are executed. Ambiguous and dynamic cursors are treated as read-only.
|
| no
|
No blocking is done on any cursors in the package. Ambiguous cursors can be updated.
|
- -datetime
d
- Determines the date and time format used when date and time fields are assigned to string representations in host variables. The possible formats are:
| def
|
Use the date/time format associated with the country code of the database. This is also the default if -datetime is not specified.
|
| usa
|
IBM standard for United States form:
mm/ddlyyyy hh:mm xM (AM or PM).
|
| eur
|
IBM standard for European form:
dd.mm.yyyy hh.mm.ss.
|
| iso
|
International Standards Organization form:
yyyy–mm–dd hh.mm.ss.
|
| jis
|
Japanese Industrial Standards form:
yyyy–mm–dd hh:mm:ss.
|
| loc
|
Local form, not necessarily equal to def.
|
- -db2
- Specifies that the DB2 version of SQL is to be used.
- -dbname
d
- Specifies the original or alias name of a database. This option directs the preprocessor to process SQL statements against the specified database,
d. If you omit this option, the preprocessor uses the default database. The default database is specified by the environment variable
DB2DBDFT.
- -E
- Allows you to run the DB2 SQL preprocessor without running the Open PL/I compiler. The preprocessor output is saved using the file specified by the
-ppdb2 option, if that option is used. Otherwise, the name defaults to the name of the input source file with the suffix
.pp2. This option is useful for a faster syntax and semantic checking of your SQL statements.
- -isolation
I
- Specifies the isolation level at which your program runs. The values of
Iare:
| cs
|
Cursor stability
|
| rr
|
Repeatable read
|
| ur
|
Uncommitted read
|
- -optimize or -nooptimize
- If you specify
-optimize, SQLDA initialization is optimized for SQL statements that use host variables. Do not specify this option when using AUTOMATIC host variables or in other situations when the address of a host variable might change during execution of the program.
-nooptimize is the default.
- -plan or -noplan
- Determines whether or not an access plan is created.
- -ppdb2
[f]
- Specifies the DB2 SQL preprocessor output file. This is useful when using the
-E option.
- -sqltwop
- It is good programming practice to declare all SQL host variables before using them in SQL statements. However, if you are not able to do this,
-sqltwop provides support for declarations of host variables subsequent to their use. This is done by making a preliminary pass over the source to detect all declarations, followed by a second pass to process the remaining SQL statements. In general, you should not need to use this option and incur the extra overhead it entails.
