DDLMODEL_VW

index back

DDL Model Statement View


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

PeopleSoft Field Name Field Type Column Type Description
STATEMENT_TYPE Number(1,0) SMALLINT NOT NULL Statement Type
1=Table
2=Index
3=Tablespace
PLATFORMID Number(2,0) SMALLINT NOT NULL Platform ID
0=SQLBase
1=DB2
2=Oracle
3=Informix
4=DB2/Unix
5=ALLBASE
6=Sybase
7=Microsoft
8=DB2/400
SIZING_SET Number(3,0) SMALLINT NOT NULL Sizing Set
PARMCOUNT Number(3,0) SMALLINT NOT NULL Parameter Count
MODEL_STATEMENT Long Character CLOB NOT NULL Model SQL Statement
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19