DDLDEFPARMS_VW

index back

DDL Model Parameter View


select statement_type, platformid, sizing_set, parmname, parmvalue from psddldefparms

  • Parent record: 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
    PARMNAME Character(8) VARCHAR2(8) NOT NULL DDL Parameter Name
    PARMVALUE Character(128) VARCHAR2(128) NOT NULL DDL Parameter Value
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19