Use this dialog box to set options that control the creation of the bind file or package.
General Options |
Lets you create a package or bind file with a specified name, or specify MIA Standards compliance.
|
Date/Time Format |
Determines the date and time format used when date/time fields are assigned to string representations.
|
Isolation Level |
Determines how data is locked or isolated from other processes while the data is being accessed. The isolation level becomes part of the bind file created by DB/Assist.
|
Blocking Options |
Specifies which record blocking to use and how to treat ambiguous cursors.
|
OK |
Applies the selections and closes the dialog box.
|
Cancel |
Closes the dialog box without performing any action.
|
Help |
Displays help for the dialog box.
|
General Options Group Box
The General Options group box is in the Bind Options dialog box.
Bind Filename |
Creates a bind file with the name in the associated entry field. The default name is the SQL Access Module (SAM) name with a .BND extension.
|
Create Package |
Creates a package with the name in the associated entry field. The default name is the SAM name. We recommend that you leave this option checked. Otherwise, you will have to manually bind the bind file to the target database.
|
MIA Standards Compliance |
If unchecked, DB/Assist requires compatibility with SAA Level 1 Database CPI only. If checked, DB/Assist requires compatibility with MIA specifications.
|
MIA Standards Compliance-Unchecked
The MIA Standards Compliance check box is in the Bind Options dialog box.
If this box is unchecked, DB/Assist requires compatibility with SAA Level 1 Database CPI only:
•The FOR UPDATE OF clause is required for all columns to be updated in a positioned UPDATE.
•C null-terminated strings are not terminated with a null if truncation occurs.
MIA Standards Compliance-Checked
The MIA Standards Compliance check box is in the Bind Options dialog box.
If this box is checked, DB/Assist requires compatibility with MIA specifications:
•The FOR UPDATE OF clause is optional for positioned updates.
•C null-terminated strings are always terminated with a null even if truncation occurs.
Date/Time Format Group Box
The Date/Time Format group box is in the Bind Options dialog box.
Option |
Comment |
Date format |
Time format |
Default |
Uses the date/time format associated with the country code of the database.
|
|
|
USA |
Uses the IBM standard for the U.S. form.
|
mm/dd/yyyy |
hh:mm (AM or PM) |
Japan |
Uses the Japanese Industrial Standard.
|
yyyy-mm-dd |
hh:mm:ss |
Europe |
Uses the IBM standard for the European form.
|
dd.mm.yyyy |
hh.mm.ss |
International |
Uses the International Standards Organization.
|
yyyy-mm-dd |
hh.mm.ss |
Local |
Uses the site-defined format, which is not necessarily equivalent to the Default format.
|
|
|
Isolation Level Group Box
The Isolation Level group box is in the Bind Options dialog box.
Cursor stability |
Locks any row accessed by a transaction of an application while the cursor is positioned on the row. The lock remains in effect until the next row is fetched or the transaction is terminated.
|
Repeatable read |
Locks all the rows an application retrieves within a unit of work. Using repeatable read, a SELECT statement issued by an application twice within the same unit of work gives the same result each time.
|
Uncommitted read |
Lets an application access uncommitted changes of other transactions. The application also does not lock other applications out of the row it is reading, unless the other application attempts to drop or alter the table.
|
Blocking Options Group Box
The Blocking Options group box is in the Bind Options dialog box.
Unambiguous |
Blocking occurs for cursors that: are read-only, are not specified as FOR UPDATE OF, have no static DELETE WHERE CURRENT OF statements, and have no dynamic statements. Ambiguous cursors are treated as updateable.
|
All |
Blocking occurs for cursors that: are read-only, are not specified as FOR UPDATE OF, and have no static DELETE WHERE CURRENT OF statements. Ambiguous and dynamic cursors are treated as read-only.
|
None |
No blocking is done on any cursors in the package. Ambiguous cursors are treated as updateable.
|
