PSDDLMODEL_VW

index back

DDL Model Statement


SELECT B.STATEMENT_TYPE , A.XLATSHORTNAME , B.SIZING_SET , B.PLATFORMID , B.PARMCOUNT , B.MODEL_STATEMENT FROM PSXLATITEM A , PSDDLMODEL B WHERE A.FIELDVALUE = B.PLATFORMID AND A.FIELDNAME = 'PLATFORMID' AND A.FIELDVALUE <> '0' AND A.FIELDVALUE <> '5' AND A.FIELDVALUE <> '8'

PeopleSoft Field NameField TypeColumn TypeDescription
STATEMENT_TYPENumber(1,0)SMALLINT NOT NULLStatement Type
1=Table
2=Index
3=Tablespace
XLATSHORTNAMECharacter(10)VARCHAR2(10) NOT NULLTranslate Value Short Name
SIZING_SETNumber(3,0)SMALLINT NOT NULLSizing Set
PLATFORMIDNumber(2,0)SMALLINT NOT NULLPlatform ID
0=SQLBase
1=DB2
2=Oracle
3=Informix
4=DB2/Unix
5=ALLBASE
6=Sybase
7=Microsoft
8=DB2/400
PARMCOUNTNumber(3,0)SMALLINT NOT NULLParameter Count
MODEL_STATEMENTLong CharacterCLOB NOT NULLModel SQL Statement
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19