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 |