Keyword | Attribute Value Description |
|---|---|
ALLOWUPDATE | =Y Allows updates on sessions set to read-only. |
AUTH_TYPE | =1,2,3,4 Specifies the type of authentication used to connect to the database: Native User will use a traditional DBMS or operating system user name and password to connect to the database. Browser User will use the identity provider credentials to access Avalanche database through client tools or web console. These credentials can be part of the Actian default identity provider or an identity provider that persists in your organization. CLI User will use the identity provider credentials to access Avalanche database through client tools using command line instructions. These credentials can be part of the Actian default identity provider or an identity provider that persists in your organization. |
AUTH_SERVER | URL of the authenticating server, which is typically the same server that allows access to the Avalanche console. |
BLANKDATE | =NULL Indicates that the driver must return empty string DATE values as NULL. |
CATCONNECT | =Y Indicates that a second separate Ingres session must be used for catalog functions (SQLTables, and so on). |
CATSCHEMANULL | =Y Returns NULL for schema names from ODBC catalog functions. |
CONVERTINT8TOINT4 | =Y Coerces eight-byte (i8) integer values from the DBMS to four-byte (i4). |
DATABASE | Database name as defined on the server. |
DB | A synonym for DATABASE. |
DATE1582 | =NULL Indicates that the driver must return values of ‘1582-01-01’ as NULL. |
DATE | Same as DATE1582 keyword. |
DATEALIAS | Specifies the data type of columns created using the alias keyword DATE. Valid values are: ANSIDATE or INGRESDATE. The attribute can be left unset. Default value is unset. This setting overrides the date_alias setting in config.dat. If left unset, the date_alias setting in config.dat is used. If neither the ODBC nor config.dat specify a date alias, the default is INGRESDATE. |
DBMS_PWD | Database password. Database passwords are defined by the CREATE USER statement, Director, accessdb, or VDBA. Although supported as a connection string attribute, DBMS_PWD is not supported as a DSN configuration attribute. |
DEFAULTTOCHAR | =Y Treats Unicode strings as "standard" (multi-byte) strings. |
DISABLEUNDERSCORE | =Y Disables underscore wildcard search characters in catalog function. |
DRIVER | Driver description as returned by SQLDrivers(). |
DSN | Data source name. |
GROUP | Group identifier for the session. Equivalent to the -G flag of the Ingres command-line flags. |
IDENTIFIERDELIMITER | =BRACKET Allows brackets [ ] (and double quotes, the default) as identifier delimiters. |
MULTIBYTEFILLCHAR | =c Displays the specified character (c) for each character that fails to convert from Unicode. This option is for applications that display Unicode data as multi-byte. This attribute can be specified if no ODBC DSN is defined or to override the "Fill character for failed Unicode/multibyte conversions" setting in the ODBC DSN. |
NUMERIC_ OVERFLOW | =IGNORE Indicates that no error is issued if an arithmetic error of numeric overflow, underflow, or divide by zero occur. Equivalent to “-numeric_overflow=ignore” command line flag. |
PWD | Password to override vnode definition. If specified, UID must also be specified. |
ROLENAME | Role name to override vnode definition. |
ROLEPWD | Role password to override vnode definition. |
SELECTLOOPS | =N Indicates that Cursor Loops must be used. |
SENDDATETIMEASINGRESDATE | Specifies whether to send datetime values as INGRESDATE data type. Valid values are: false–Send values as ANSI TIMESTAMP WITH TIMEZONE type true–Send values as INGRESDATE type unset—Implicitly send ANSIDATE or INGRESDATE, depending on the DATEALIAS property: If DATEALIAS property is set to ANSIDATE, uses a value of false; otherwise uses a value of true. Unlike DATEALIAS, this property affects the way parameter data is handled. |
SERVER | Vnode name. |
SERVERTYPE | Server type (for example, INGRES, IDMS, or DB2). |
UID | User ID to override vnode definition. |