PSREMOTEDBDEFN

index back

Remote Database Table

Stores the information needed by the Remote Database feature to connect to both remote and the local database.

PeopleSoft Field Name Field Type Column Type Description
REMOTEDB_ID Character(30) VARCHAR2(30) NOT NULL Remote DB Name
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
DESCR Character(30) VARCHAR2(30) NOT NULL Description
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: N

REMOTEDBCONNTYPE Character(1) VARCHAR2(1) NOT NULL Remote DB Connection type
S=Specific Oracle Conn Parms
T=Oracle TNSNames

Default: T

REMOTEDBNAME Character(128) VARCHAR2(128) NOT NULL Remote Database Name
DBSERVER Long Character(255) VARCHAR2(255) NOT NULL Database Host Server Name
DB_PORT Number(5,0) INTEGER NOT NULL Database Server Port Number
INFORMIXSERVERNAME Character(254) VARCHAR2(254) NOT NULL Informix Server Name
USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
PASSWORD Character(254) VARCHAR2(254) NOT NULL Password
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19