PSDDLMODEL

index back

DDL Model Statement


  • Parent record of DDLDEFPARMS_VW PSDDLDEFPARMS PSDDLDEFPARM_VW
  • PeopleSoft Field NameField TypeColumn TypeDescription
    STATEMENT_TYPENumber(1,0)SMALLINT NOT NULLStatement Type
    1=Table
    2=Index
    3=Tablespace
    PLATFORMIDNumber(2,0)SMALLINT NOT NULLPlatform ID
    0=SQLBase
    1=DB2
    2=Oracle
    3=Informix
    4=DB2/Unix
    5=ALLBASE
    6=Sybase
    7=Microsoft
    8=DB2/400
    SIZING_SETNumber(3,0)SMALLINT NOT NULLSizing Set
    PARMCOUNTNumber(3,0)SMALLINT NOT NULLParameter Count
    MODEL_STATEMENTLong CharacterCLOB NOT NULLModel SQL Statement
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19