Copyright: , 1995 INTERSOLV


	DataDirect ODBC  DB2/2 Driver
Logon to DB2/2

Catalog Remote Database

DB2/2 ODBC Setup

Copyright


Copyright
Copyright 1995 INTERSOLV Inc. All rights reserved. INTERSOLV is a registered trademark, and DataDirect is a trademark of INTERSOLV, Inc. Other company or product names mentioned herein may be trademarks or registered trademarks of their respective companies.


DB2/2 ODBC Setup
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.

When you select Preserve, the driver returns SQL_CB_PRESERVE from SQLGetInfo (SQL_CURSOR_COMMIT_BEHAVIOR). But only Select statements and prepared Update or Delete . . . Where Current of Cursor statements are preserved when the transaction ends. All other prepared statements are closed and deleted.

Catalog:  You must catalog any database you wish to access. To do so, click Catalog. The Catalog Remote Database 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.


Logon to DB2/2

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.


Catalog Remote Database

Catalog the remote database you wish to access.

Alias Name:  Enter an alias name for the remote database.

Database Name:  Enter the name of the remote database.

Remote Node Name:  Enter the name of the remote node (the node where the server is installed).

Comment:  Optionally, enter a comment.

Click Add to catalog the entry.

Click Delete to uncatalog the entry.