This chapter discusses these data sources:
This chart lists the characteristics of the Business Data data source.
| Field | Valid Value for Client Access |
|---|---|
| Data Source Name (list includes possible sources) | Business Data - PROD
Business Data - CRP Business Data - TEST Business Data - PS910 |
| Data Source Use | DB |
| Data Source Type | I |
| Object Owner ID | Blank |
| Library Name (list includes possible libraries) | PRODDTA
TESTDTA CRPDTA PS910DTA |
| Library List Name | RDB name of the IBM i
Note: To find the IBM i RDB name, use the WRKRDBDIRE command. |
| Database Name (list includes possible databases) | Business Data - PROD
Business Data - TEST Business Data - CRPDTA Business Data - PS910 |
| Server Name | Name of the machine where your database resides |
| Platform | IBM i |
| Use Table Owner | Blank |
| Use Julian Dates | Selected |
| Use Decimal Shift | Selected |
| Support for Updates | Selected |
| OCM Data Source | Blank |
| LOB Data Source | Selected |
| IBM i BLOB Support | Blank |
This chart lists the characteristics of the Central Objects data source.
| Field | Client Access |
|---|---|
| Data Source Name (list includes possible sources) | Central Objects - PY910 (for CRP)
Central Objects - PS910 (for Prist) Central Objects - PD910 (for Prod) Central Objects - DV910 (for Dev) |
| Data Source Use | DB |
| Data Source Type | I |
| Object Owner ID | Blank |
| Library Name (list includes possible libraries) | COPD910 (for Prod)
COPY910 (for CRP) COPS910 (for Prist) CODV910 (for Dev) |
| Library List Name | RDB name of the IBM i
Note: To find the IBM i RDB name, use the WRKRDBDIRE command. |
| Database Name (list includes possible databases) | Central Objects - PY910
Central Objects - PS910 Central Objects - PD910 Central Objects - DV910 |
| Server Name | Name of the machine where your database resides |
| Platform | IBM i |
| Use Table Owner | Blank |
| Use Julian Dates | Selected |
| Use Decimal Shift | Selected |
| Support for Updates | Selected |
| OCM Data Source | Blank |
| LOB Data Source | Selected |
| IBM i BLOB Support | Blank |
This chart lists the characteristics of the Control Tables data source.
| Field | Client Access |
|---|---|
| Data Source Name (list includes possible sources) | Control Tables - Prod
Control Tables - CRP Control Tables - PS910 Control Tables - Test |
| Data Source Use | DB |
| Data Source Type | I |
| Object Owner ID | Blank |
| Library Name (list includes possible libraries) | PRODCTL
CRPCTL PS910CTL TESTCTL |
| Library List Name | RDB name of the IBM i
Note: To find the IBM i RDB name, use the WRKRDBDIRE command. |
| Database Name (list includes possible databases) | Control Tables - Prod
Control Tables - CRP Control Tables - PS910 Control Tables - Test |
| Server Name | Name of the machine where your database resides |
| Platform | IBM i |
| Use Table Owner | Blank |
| Use Julian Dates | Selected |
| Use Decimal Shift | Selected |
| Support for Updates | Selected |
| OCM Data Source | Blank |
| LOB Data Source | Selected |
| IBM i BLOB Support | Blank |
This chart lists the characteristics of the Data Dictionary data source.
| Field | Client Access |
|---|---|
| Data Source Name | Data Dictionary - 910 |
| Data Source Use | DB |
| Data Source Type | I |
| Object Owner ID | Blank |
| Library Name | DD910 |
| Library List Name | RDB name of the IBM i
Note: To find the IBM i RDB name, use the WRKRDBDIRE command. |
| Database Name | Data Dictionary - 910 |
| Server Name | Name of the machine where your database resides |
| Platform | IBM i |
| Use Table Owner | Blank |
| Use Julian Dates | Selected |
| Use Decimal Shift | Selected |
| Support for Updates | Selected |
| OCM Data Source | Blank |
| LOB Data Source | Selected |
| IBM i BLOB Support | Blank |
This chart lists the characteristics of the Logic data source.
| Field | Client Access |
|---|---|
| Data Source Name | Name of the machine where your database resides |
| Data Source Use | SVR |
| Data Source Type | I |
| Object Owner ID | Blank |
| Library Name | xMAP (where x is the release to which you are installing, such as 910) |
| Library List Name | RDB name of the IBM i
Note: Ensure the system value for QCCSID is 37. To find the IBM i RDB name, use the WRKRDBDIRE command. |
| Database Name | machinename - 910 Server Map |
| Server Name | Name of the machine where your database resides |
| Platform | IBM i |
| Use Table Owner | Blank |
| Use Julian Dates | Selected |
| Use Decimal Shift | Selected |
| Support for Updates | Selected |
| OCM Data Source | Blank |
| IBM i BLOB Support | Selected |
This chart lists the characteristics of the Object Librarian data source.
| Field | Valid Value for Client Access |
|---|---|
| Data Source Name | Object Librarian - 910 |
| Data Source Use | DB |
| Data Source Type | I |
| Object Owner ID | Blank |
| Library Name | OL910 |
| Library List Name | RDB name of the IBM i
Note: To find the IBM i RDB name, use the WRKRDBDIRE command. |
| Database Name | Object Librarian - 910 |
| Server Name | Name of the machine where your database resides |
| Platform | IBM i |
| Use Table Owner | Blank |
| Use Julian Dates | Selected |
| Use Decimal Shift | Selected |
| Support for Updates | Selected |
| OCM Data Source | Blank |
| IBM i BLOB Support | Blank |
| LOB Data Source | Selected |
This chart lists the characteristics of the Language data source, which applies to the Oracle tablespace on the Deployment Server.
| Field | Valid Value for Oracle |
|---|---|
| Data Source Name (list includes possible sources) | Language
Language – 910 For example, French – 910. |
| Data Source Use | DB |
| Data Source Type | N |
| Object Owner ID (list includes possible owner IDs) | Blank |
| Library Name | Blank |
| Library List Name | Blank |
| Database Name (list includes possible databases) | Language
JDELanguage_F910 |
| Server Name | Local |
| Platform | LOCAL |
| Use Table Owner | Blank |
| Use Julian Dates | Blank |
| Use Decimal Shift | Blank |
| Support for Updates | Blank |
| OCM Data Source | Blank |
| IBM i BLOB Support | Blank |
This chart lists the characteristics of the Local data source, which applies to the Oracle tablespace on the Deployment Server.
| Field | Valid Value for Oracle |
|---|---|
| Data Source Name (list includes possible sources) | Local
JDELocal - DV910 JDELocal - PS910 JDELocal - PD910 JDELocal - PY910 |
| Data Source Use | DB |
| Data Source Type | N |
| Object Owner ID (list includes possible owner IDs) | dbo |
| Library Name | Blank |
| Library List Name | Blank |
| Database Name (list includes possible databases) | JDELocal
JDEPlan910 JDECTL910 JDEDD910 JDESY910 JDEVL910 JDEOL910 JDEData910 |
| Server Name | Local |
| Platform | LOCAL |
| Use Table Owner | Selected |
| Use Julian Dates | Selected |
| Use Decimal Shift | Selected |
| Support for Updates | Selected |
| OCM Data Source | Blank |
| LOB Data Source | Blank |
This chart lists the characteristics of the Journal data source.
| Field | Valid Value for Client Access |
|---|---|
| Data Source Name (list includes possible sources) | OWJRNL |
| Data Source Use | DB |
| Data Source Type | I |
| Object Owner ID | Blank |
| Library Name | OWJRNL |
| Library List Name | RDB name of the IBM i
Note: To find the IBM i RDB name, use the WRKRDBDIRE command. |
| Database Name | OWJRNL |
| Server Name | Name of the machine where your database resides |
| Platform | IBM i |
| Use Table Owner | Blank |
| Use Julian Dates | Selected |
| Use Decimal Shift | Selected |
| Support for Updates | Selected |
| OCM Data Source | Blank |
| IBM i BLOB Support | Blank |
This chart lists the characteristics of the Server Map data source.
| Field | Valid Value for Client Access |
|---|---|
| Data Source Name | machinename - 910 Server Map |
| Data Source Use | DB |
| Data Source Type | I |
| Object Owner ID | Blank |
| Library Name | SVM910 |
| Library List Name | RDB name of the IBM i
Note: To find the IBM i RDB name, use the WRKRDBDIRE command. |
| Database Name | machinename - 910 Server Map |
| Server Name | Name of the machine where your database resides |
| Platform | IBM i |
| Use Table Owner | Blank |
| Use Julian Dates | Selected |
| Use Decimal Shift | Selected |
| Support for Updates | Selected |
| OCM Data Source | Selected |
| IBM i BLOB Support | Blank |
| LOB Data Source | Selected |
This chart lists the characteristics of the System data source.
| Field | Valid Value for Client Access |
|---|---|
| Data Source Name (list includes possible sources) | System - 910 |
| Data Source Use | DB |
| Data Source Type | I |
| Object Owner ID | Blank |
| Library Name | SY910 |
| Library List Name | RDB name of the IBM i
Note: To find the IBM i RDB name, use the WRKRDBDIRE command. |
| DLL Name | Blank |
| Database Name (list includes possible databases) | System - 910 |
| Server Name | Name of the machine where your database resides |
| Platform | IBM i |
| Use Table Owner | Blank |
| Use Julian Dates | Selected |
| Use Decimal Shift | Selected |
| Support for Updates | Selected |
| OCM Data Source | Selected |
| IBM i BLOB Support | Blank |
| LOB Data Source | Selected |
This chart lists the characteristics of the Versions data source.
| Field | Valid Value for Client Access |
|---|---|
| Data Source Name (list includes possible sources) | Versions - PD910
Versions - PY910 Versions - DV910 Versions - PS910 |
| Data Source Use | DB |
| Data Source Type | I |
| Object Owner ID | Blank |
| Library Name (list includes possible libraries) | COPD910
COPY910 CODV910 COPS910 |
| Library List Name | RDB name of the IBM i
Note: To find the IBM i RDB name, use the WRKRDBDIRE command. |
| DLL Name | Blank |
| Database Name (list includes possible databases) | Versions - PD910
Versions - PY910 Versions - DV910 Versions - PS910 |
| Server Name | Name of the machine where your database resides |
| Platform | IBM i |
| Use Table Owner | Blank |
| Use Julian Dates | Selected |
| Use Decimal Shift | Selected |
| Support for Updates | Selected |
| OCM Data Source | Blank |
| IBM i BLOB Support | Blank |
| LOB Data Source | Selected |