DDLMODEL_VW

index back

DDL Model Statement View


select statement_type, platformid, sizing_set, parmcount, model_statement from psddlmodel

PeopleSoft Field NameField TypeColumn TypeDescription
STATEMENT_TYPENumber(1,0)SMALLINT NOT NULLStatement Type
1=Table
2=Index
3=Tablespace
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
SIZING_SETNumber(3,0)SMALLINT NOT NULLSizing Set
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