home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 8 Other
/
08-Other.zip
/
odbcpa22.zip
/
IBMDI08.HLP
(
.txt
)
< prev
next >
Wrap
OS/2 Help File
|
1998-04-20
|
5KB
|
94 lines
ΓòÉΓòÉΓòÉ 1. Configuring an MDI Data Source ΓòÉΓòÉΓòÉ
Data Source Name: A string that identifies this MicroDecisionware data source
configuration in ODBC.INI. Examples include "Accounting" or "MicroDecisionware
Serv1."
Description: An optional long description of a data source name. For example,
"My Accounting Database" or "MicroDecisionware on Server number 1."
Server Name: The name of the OS/2 server running the MicroDecisionware
Database Gateway. This value will appear as the initial default in the logon
dialog box.
The following values are optional:
Server List: The list of servers that will appear in the logon dialog box.
Separate the server names with commas.
Default Authorization ID: The default authorization ID used to connect to your
DB2 database. This ID is case-sensitive. An authorization ID is required only
if security is enabled on your database. Your ODBC application may override
this value or you may override this value in the logon dialog box.
Groups: A list of the groups to which you belong, used to determine which
tables you can access. Separate each group name with a comma. Alternatively,
enter the word ALL so that you can see all table names even if you cannot
access the table.
Application Name: The name used to identify your application.
Workstation ID: The workstation ID used by the MicroDecisionware Database
Gateway.
Cancel Behavior: A value to specify how a previously executed statement should
be canceled.
n0 fetches all remaining records if the statement was a Select.
n1 cancels the statement by calling dbcancel. This is the default.
n2 closes the connection to the server for the statement.
Yield Proc: A numeric value that determines whether you can work in other
applications when the gateway is busy. This attribute is useful to users of
ODBC applications. Valid values are:
n0 (peek and dispatch), which causes the driver to check the Windows message
queue and send any messages to the appropriate Windows application.
n1 (no yielding, the default), which does not let you work in other
applications.
n3 (dispatch via Windows Yield function), which turns control over to the
Windows kernel. The Windows kernel checks the message queue and sends any
messages to the appropriate application window.
It is recommended that you use the value 1. The values 0 and 3 do not work
with all Windows applications.
Owner of Catalog Tables: The owner of views of the system tables. The tables
themselves are owned by SYSIBM. If you have read access to the system tables,
this option does not have to be changed. If you do not have read access, the
database administrator must create a view of the system tables in another
account and give you permission to use the view. Enter the authorization ID
for the account that owns the views for the system tables.
Tablespace to Create Tables in: The name of the tablespace in which new tables
are stored. For example, DSNDB04.
DB2 Site Allows User to Log On More Than Once: A check box that specifies that
your site lets a user log on to DB2 more than once. Selecting this check box
may improve performance.
NETAPI.DLL Library Available: A check box that specifies that the driver can
use NETAPI.DLL to get the name of your workstation. Most major PC networks
support this feature. If your network does not support this capability,
deselect this option. If you supply a workstation ID, this setting is ignored.
Translate: Displays the Select Translator dialog box to allow you to perform a
translation of your data from one character set to another. Choose the
INTERSOLV OEM ANSI translator to translate your data from the IBM PC character
set to the ANSI character set.
ΓòÉΓòÉΓòÉ 2. Logon to MDI ΓòÉΓòÉΓòÉ
Server Name: Enter the name of the OS/2 server running the Database Gateway
you wish to access or select the name from the Gateway Server box, which
displays the server names specified in the Setup dialog box.
Login ID: Enter your Authorization ID (case-sensitive).
Password: Enter your password for the system (case-sensitive).