PSDDLMODEL_VW

Platform	View Text
DB2	SELECT B.STATEMENT_TYPE , A.XLATSHORTNAME , B.SIZING_SET , B.PLATFORMID , B.PARMCOUNT , B.MODEL_STATEMENT FROM PSXLATITEM A , PSDDLMODEL B WHERE A.FIELDVALUE = strip(digits(B.PLATFORMID),L,'0') AND A.FIELDNAME = 'PLATFORMID' AND A.FIELDVALUE <> '0' AND A.FIELDVALUE <> '5' AND A.FIELDVALUE <> '8'
Oracle	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'
Informix	SELECT B.STATEMENT_TYPE , A.XLATSHORTNAME , B.SIZING_SET , B.PLATFORMID , B.PARMCOUNT , B.MODEL_STATEMENT FROM PSXLATITEM A , PSDDLMODEL B WHERE A.FIELDVALUE = SUBSTR(B.PLATFORMID,0) AND A.FIELDNAME = 'PLATFORMID' AND A.FIELDVALUE <> '0' AND A.FIELDVALUE <> '5' AND A.FIELDVALUE <> '8'
DB2/UNIX	SELECT B.STATEMENT_TYPE , A.XLATSHORTNAME , B.SIZING_SET , B.PLATFORMID , B.PARMCOUNT , B.MODEL_STATEMENT FROM PSXLATITEM A , PSDDLMODEL B WHERE A.FIELDVALUE = replace(ltrim(replace(digits(B.PLATFORMID),'0',' ')),' ','0') AND A.FIELDNAME = 'PLATFORMID' AND A.FIELDVALUE <> '0' AND A.FIELDVALUE <> '5' AND A.FIELDVALUE <> '8'
Sybase	SELECT B.STATEMENT_TYPE , A.XLATSHORTNAME , B.SIZING_SET , B.PLATFORMID , B.PARMCOUNT , B.MODEL_STATEMENT FROM PSXLATITEM A , PSDDLMODEL B WHERE A.FIELDVALUE = rtrim(CONVERT(CHAR,B.PLATFORMID)) AND A.FIELDNAME = 'PLATFORMID' AND A.FIELDVALUE <> '0' AND A.FIELDVALUE <> '5' AND A.FIELDVALUE <> '8'
Microsoft	SELECT B.STATEMENT_TYPE , A.XLATSHORTNAME , B.SIZING_SET , B.PLATFORMID , B.PARMCOUNT , B.MODEL_STATEMENT FROM PSXLATITEM A , PSDDLMODEL B WHERE A.FIELDVALUE = rtrim(CONVERT(CHAR,B.PLATFORMID)) AND A.FIELDNAME = 'PLATFORMID' AND A.FIELDVALUE <> '0' AND A.FIELDVALUE <> '5' AND A.FIELDVALUE <> '8'

PeopleSoft Field Name	Description
STATEMENT_TYPE	Statement Type 1=Table 2=Index 3=Tablespace
XLATSHORTNAME	Translate Value Short Name
SIZING_SET	Sizing Set
PLATFORMID	Platform ID 0=SQLBase 1=DB2 2=Oracle 3=Informix 4=DB2/Unix 5=ALLBASE 6=Sybase 7=Microsoft 8=DB2/400
PARMCOUNT	Parameter Count
MODEL_STATEMENT	Model SQL Statement

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010