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 Name Field Type Column Type Description
STATEMENT_TYPE Number(1,0) SMALLINT NOT NULL Statement Type
1=Table
2=Index
3=Tablespace
XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
SIZING_SET Number(3,0) SMALLINT NOT NULL Sizing Set
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
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