Using Keywords in the Connection String
This section discusses keywords that you can use in a connection string when you write your own database applications.
You can use C programming language to write database applications that directly invoke SQL APIs that are supported by ODA, such as SQLDriverConnect and SQLBrowseConnect. This table lists keywords that you use in the connection string when you write your own database applications:
Key |
Value |
Description |
Input Connection String |
Output Connection String |
---|---|---|---|---|
CONVERTUDC |
Y or N (default value is N) |
Convert UDC or not |
Optional. If not in the connection string, load from INI/registry settings (JD Edwards EnterpriseOne ODA DSN settings). |
From the input string or INI/registry settings. |
CONVERT CURRENCY |
Y or N (default value is N) |
Convert currency or not |
Optional. If not in the connection string, load from INI/registry settings (JD Edwards EnterpriseOne ODA DSN settings). |
From the input string or INI/registry settings. |
SHIFTDECIMALS |
Y or N (default value is Y) |
Use decimal shift or not |
Optional. If not in the connection string, load from INI/registry settings (JD Edwards EnterpriseOne ODA DSN settings). |
From the input string or INI/registry settings. |
CONVERTJULIAN DATES |
Y or N (default value is Y) |
Convert Julian dates or not |
Optional. If not in the connection string, load from INI/registry settings (JD Edwards EnterpriseOne ODA DSN settings). |
From the input string or INI/registry settings. |
DISPLAYOPTIONS |
0/1/2 (no default value) |
Display TBLE, BSFN or both |
Optional. If not in the connection string, load from INI/registry settings (JD Edwards EnterpriseOne ODA DSN settings). |
From the input string or INI/registry settings. |
LONGTABLE NAMES |
Y or N (default value is Y) |
Use long names for tables or not |
Optional. If not in the connection string, load from INI/registry settings (JD Edwards EnterpriseOne ODA DSN settings). |
From the input string or INI/registry settings. |
LONGCOLUMN NAMES |
Y or N (default value is Y) |
Use long names for columns or not |
Optional. If not in the connection string, load from INI/registry settings (JD Edwards EnterpriseOne ODA DSN settings). |
From the input string or INI/registry settings. |
UID |
<string> |
User ID |
Required by JDEDriverConnect (SQL_DRIVER_NOPROMPT). |
The same as the input if not overwritten by OW login. |
PWD |
<string> |
Password |
Required by JDEDriverConnect (SQL_DRIVER_NOPROMPT). |
The same as the input if not overwritten by OW login. |
ENVIRONMENT |
<string> |
Environment |
Required by JDEDriverConnect (SQL_DRIVER_NOPROMPT). |
The same as the input if not overwritten by OW login. |
DBQ |
<string> |
The same as the ENVIRONMENT |
Work as ENVIRONMENT, if ENVIRONMENT not specified. |
Removed if ENVIRONMENT exists. |
DSN |
<string> |
Data source |
Optional. Uses DEFAULT if invalid. |
Overwritten by login. |
If you use the Microsoft Analysis Service tool, you can use connection string keywords to create a new data source. This example shows how to write a connection string:
DSN=OneWorld ODA;DBQ=ADEVHP02;