home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 8 Other
/
08-Other.zip
/
odbcpa22.zip
/
IBDB208.HLP
(
.txt
)
< prev
next >
Wrap
OS/2 Help File
|
1998-04-20
|
5KB
|
148 lines
ΓòÉΓòÉΓòÉ 1. Configuring a DB2/2 Data Source ΓòÉΓòÉΓòÉ
Data Source Name:
A string that identifies this DB2/2 data source configuration in
ODBC.INI. Examples include "Accounting" or "DB2/2-Serv1."
Description:
An optional long description of a data source name. For example, "My
Accounting Database" or "DB2/2 on Server #1."
Database Name:
The name of the database to which you want to connect by default.
The following values are optional:
Owner of Catalog Tables:
On most DB2/2 systems, SYSIBM is the owner of the catalog system
tables. If you have read access to the system tables, you do not
need to change this option.
If you do not have read access, the system administrator must create
a view of the system tables in another account and give you
permission to use that view. In this case, specify the Authorization
ID for the account that owns the views of the system tables.
If you are using DDCS/2 to connect to a SQL/400 database, specify a
comma-separated list of the Collection IDs to which you want to have
access in your ODBC application.
If you are using DDCS/2 to connect to a SQL/DS database, specify
SYSTEM as the owner.
Groups:
A value to determine which tables you can access. Your system
administrator may have placed you in a "group" of users and granted
table access to the entire group. If this is the case, specify the
names of any groups to which you belong; separate each name with a
comma. Alternatively, specify the word ALL so that you see all table
names even if you cannot access the table.
Default Authorization ID:
The default Logon ID used to connect to your DB2/2 database. A Logon
ID is required only if security is enabled on your database. Your
ODBC application may override this value or you may change this value
in the logon dialog box.
Cursor Behavior:
Select Preserve if you want cursors to be held at the current
position when the transaction ends. Otherwise, leave this set to
Close. Selecting Preserve may impact the performance of your
database operations. This setting does not apply to SQL/DS.
Catalog Db
You must catalog any database you wish to access. To do so, click Catalog. The
Catalog Remote Database dialog box appears.
Catalog Node
To provide information about the remote site for DB2/2 databases, click Catalog
Node. The Catalog Node dialog box appears.
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 DB2/2 ΓòÉΓòÉΓòÉ
Dialog Box Options
Database Name:
Enter the name of the remote database or select the name of the
remote database from the Database Name box.
You must have cataloged any database you wish to access from the
client.
Authorization ID:
Enter your user name (authorization ID).
Password:
Enter your password.
If you leave your user name and password blank, the ODBC application
assumes you have previously logged on using SQLLOGN2 under DOS or
using User Profile Management under OS/2. If you have not, the
application returns an error. You must either enter your user name
and password in the dialog box or log on using SQLLOGN2 and STARTDRQ
under DOS or using User Profile Management under OS/2. See the IBM
Extended Services for OS/2 Guide to DB2/2 Clients for information
regarding these two statements.
ΓòÉΓòÉΓòÉ 3. Catalog Remote Database ΓòÉΓòÉΓòÉ
In this dialog box, catalog the remote database you wish to access.
Click Add to catalog the entry.
Click Delete to uncatalog the entry.
Alias Name:
Enter an alias name for the remote database.
Database Name:
Enter the name of the remote database.
Node Name:
Enter a name, like an alias for the node. The node name could
describe the remote node name and the communication protocol used to
access it.
Comment:
Optionally, enter a comment.
ΓòÉΓòÉΓòÉ 4. Catalog Node ΓòÉΓòÉΓòÉ
In this dialog box, provide information about the remote site for DB2/2
databases.
Click Add to catalog the entry.
Click Delete to uncatalog the entry.
Node Name:
Select a node name. Only names of previously cataloged nodes are
available.
Server/Adapter:
Enter the name of the server or the number of the adapter (for
NetBIOS nodes).
Remote Node Name:
Enter the name of the remote node (the node where the server is
installed).
Node Type:
Enter the type of communication protocol to use to access the node.
Comment:
Optionally, enter a comment.