REMOTEDB_ID0=SQLBase
1=DB2
2=Oracle
3=Informix
4=DB2/UNIX
5=AllBase
6=Sybase
7=Microsoft
8=DB2/400
N=Connection to Remote Database
Y=Connection to Local Database
Default Value: N
S=Specific Oracle Conn Parms
T=Oracle TNSNames
Default Value: T
PSREMOTEDBDEFN(SQL Table) |
Index Back |
|---|---|
Remote Database TableStores the information needed by the Remote Database feature to connect to both remote and the local database. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REMOTEDB_ID |
Character(30) | VARCHAR2(30) NOT NULL | Remote DB Name |
| 2 | DBTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Database Type
0=SQLBase 1=DB2 2=Oracle 3=Informix 4=DB2/UNIX 5=AllBase 6=Sybase 7=Microsoft 8=DB2/400 |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | LOCAL_CONNECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
This flag is set to 'Y' to indicate this connection information is for the local PeopleSoft database. If set to 'N', the connection is to a remote, potentially non-PeopleSoft database. There must be only one connection stored in the database with the flag set to 'Y'.
N=Connection to Remote Database Y=Connection to Local Database Default Value: N |
| 5 | REMOTEDBCONNTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Remote DB Connection type
S=Specific Oracle Conn Parms T=Oracle TNSNames Default Value: T |
| 6 | REMOTEDBNAME | Character(128) | VARCHAR2(128) NOT NULL | Remote Database Name |
| 7 | DBSERVER | Long Character(255) | VARCHAR2(255) NOT NULL | Database Host Server Name |
| 8 | DB_PORT | Number(5,0) | INTEGER NOT NULL | Database Server Port Number |
| 9 | INFORMIXSERVERNAME | Character(254) | VARCHAR2(254) NOT NULL | Informix Server Name |
| 10 | USERID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 11 | PASSWORD | Character(254) | VARCHAR2(254) NOT NULL | Password |