home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 8 Other
/
08-Other.zip
/
odbcpa22.zip
/
IBING408.HLP
(
.txt
)
< prev
next >
Wrap
OS/2 Help File
|
1998-04-20
|
5KB
|
122 lines
ΓòÉΓòÉΓòÉ 1. Configuring an INGRES 6.4/04 Data Source ΓòÉΓòÉΓòÉ
Data Source Name:
A string that identifies this INGRES data source configuration in
ODBC.INI. Examples include "Accounting" or "INGRES-Serv1."
Description:
An optional long description of a data source name. For example, "My
Accounting Database" or "INGRES on Server number 1."
Server Name:
The name of the virtual node that you defined using the INGRES NETU
utility. This virtual node tells INGRES which system to call, how to
call it, and the user's name and password.
Database Name:
The name of the database to which you want to connect by default.
The following values are optional:
Server List:
The list of servers (virtual nodes) that will be available in the
Logon dialog box. Separate the server names with commas.
Database List:
The list of databases that will be available in the logon dialog box.
Separate the names with commas.
Default User Name:
The default user name used to connect to your INGRES database. A
user name 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.
Options:
Any flag allowed on the INGRES SQL command line. Some examples are
Γûá -l (locks the database exclusively)
Γûá -u (logs on as username)
Γûá +w or -w (waits/doesn't wait for the database if a user has already
opened it exclusively)
Γûá +U or -U (enables/disables user updating of the system tables and locks
the database exclusively)
Γûá +Y or -Y (enables/disables user updating of the system tables but does
not lock the database exclusively)
Yield Proc:
This attribute is not available in OS/2. A numeric value that
determines whether you can work in other applications when INGRES is
busy.
Repeated Cache Size
A number that determines whether all Update and Insert statements are
to be executed as repeated statements. This attribute improves the
performance of applications that repeat the same SQL statement. When
set to 0, the initial default, no statements are repeated. The
recommended setting for this attribute is 100
(RepeatedCacheSize=100).
To repeat a single statement rather than all statements, use the
INGRES REPEATED syntax.
Repeated Selects
A number that determines whether the driver optimizes Select
statements or executes them as repeated queries. When set to 0, the
initial default, the driver executes all Select statements as it did
in previous versions of the product. When set to 1, the driver
optimizes Select statements that return only one result row. When set
to 2, the driver executes all Select statements as repeated queries.
If this attribute is set to 1 or 2, the RepeatedCacheSize attribute
must be set to greater than zero. Setting this option to 1 or 2 has
no effect on Select statements containing a For Update clause. These
settings also limit the driver to one active statement and one active
connection.
Value Replacement for Repeated Selects
A number that determines whether the driver substitutes parameters
for hardcoded values in repeated statements. This option is
convenient in applications that do not use dynamic parameters.
When set to 0, the initial default, the driver does not substitute
parameters. When set to 1, the driver substitutes parameters for
hardcoded values and the RepeatedCacheSize attribute must be greater
than zero or the REPEATED INGRES keyword must be used.
This option has no effect upon Select statements that contain a For
Update clause that requires a cursor or upon statements that already
use parameter markers.
This attribute supports only a subset of standard ODBC SQL grammer.
It is intended for performance and does not utilize a full SQL
parser. For example, subselects are not supported and use of "is
NULL" for columns other than character columns is not supported.
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 INGRES ΓòÉΓòÉΓòÉ
Dialog Box Options
Server Name:
Enter the server name of the computer containing the INGRES database
you wish to access or select the name from the Server Name box, which
displays the server names you specified in the Setup dialog box.
Server Name must be a valid Virtual Node that has been added using
the INGRES NETU utility.
Database Name:
Enter the name of the database to which you want to connect or select
the name from the Database Name box, which displays the names you
specified in the Setup dialog box.
User Name:
Enter your user name.