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 NameField TypeColumn TypeDescription
REMOTEDB_IDCharacter(30)VARCHAR2(30) NOT NULLRemote DB Name
DBTYPECharacter(1)VARCHAR2(1) NOT NULLDatabase Type
0=SQLBase
1=DB2
2=Oracle
3=Informix
4=DB2/UNIX
5=AllBase
6=Sybase
7=Microsoft
8=DB2/400
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
LOCAL_CONNECT_FLAGCharacter(1)VARCHAR2(1) NOT NULLThis 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

REMOTEDBCONNTYPECharacter(1)VARCHAR2(1) NOT NULLRemote DB Connection type
S=Specific Oracle Conn Parms
T=Oracle TNSNames

Default: T

REMOTEDBNAMECharacter(128)VARCHAR2(128) NOT NULLRemote Database Name
DBSERVERLong Character(255)VARCHAR2(255) NOT NULLDatabase Host Server Name
DB_PORTNumber(5,0)INTEGER NOT NULLDatabase Server Port Number
INFORMIXSERVERNAMECharacter(254)VARCHAR2(254) NOT NULLInformix Server Name
USERIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
PASSWORDCharacter(254)VARCHAR2(254) NOT NULLPassword
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19