PSDDLDEFPARMS

(SQL Table)
 Index Back

DDL Model Parameter

  • Parent record: PSDDLMODEL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STATEMENT_TYPE Number(1,0) SMALLINT NOT NULL Statement Type
    3=Tablespace
    2 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
    3 SIZING_SET Number(3,0) SMALLINT NOT NULL Sizing Set
    4 PARMNAME Character(8) VARCHAR2(8) NOT NULL DDL Parameter Name
    5 PARMVALUE Character(128) VARCHAR2(128) NOT NULL DDL Parameter Value