Database.Relational.Schema.DB2Syscat.Columns

Generate template of SYSCAT.columns system catalog table.

Documentation

data Columns

Constructors

Columns

Fields

• tabschema :: !String
• tabname :: !String
• colname :: !String
• colno :: !Int16
• typeschema :: !String
• typename :: !String
• length :: !Int32
• scale :: !Int16
• default_ :: !(Maybe String)
• nulls :: !String
• codepage :: !Int16
• logged :: !String
• compact :: !String
• colcard :: !Int64
• high2key :: !(Maybe String)
• low2key :: !(Maybe String)
• avgcollen :: !Int32
• keyseq :: !(Maybe Int16)
• partkeyseq :: !(Maybe Int16)
• nquantiles :: !Int16
• nmostfreq :: !Int16
• numnulls :: !Int64
• targetTypeschema :: !(Maybe String)
• targetTypename :: !(Maybe String)
• scopeTabschema :: !(Maybe String)
• scopeTabname :: !(Maybe String)
• sourceTabschema :: !(Maybe String)
• sourceTabname :: !(Maybe String)
• dlFeatures :: !(Maybe String)
• specialProps :: !(Maybe String)
• hidden :: !String
• inlineLength :: !Int32
• identity :: !String
• generated :: !String
• text :: !(Maybe String)
• remarks :: !(Maybe String)

Instances

Show Columns

Methods

showsPrec :: Int -> Columns -> ShowS

show :: Columns -> String

showList :: [Columns] -> ShowS

PersistableWidth Columns

Methods

persistableWidth :: PersistableRecordWidth Columns

TableDerivable Columns

Methods

derivedTable :: Table Columns

ProductConstructor (String -> String -> String -> Int16 -> String -> String -> Int32 -> Int16 -> Maybe String -> String -> Int16 -> String -> String -> Int64 -> Maybe String -> Maybe String -> Int32 -> Maybe Int16 -> Maybe Int16 -> Int16 -> Int16 -> Int64 -> Maybe String -> Maybe String -> Maybe String -> Maybe String -> Maybe String -> Maybe String -> Maybe String -> Maybe String -> String -> Int32 -> String -> String -> Maybe String -> Maybe String -> Columns)

Methods

productConstructor :: String -> String -> String -> Int16 -> String -> String -> Int32 -> Int16 -> Maybe String -> String -> Int16 -> String -> String -> Int64 -> Maybe String -> Maybe String -> Int32 -> Maybe Int16 -> Maybe Int16 -> Int16 -> Int16 -> Int64 -> Maybe String -> Maybe String -> Maybe String -> Maybe String -> Maybe String -> Maybe String -> Maybe String -> Maybe String -> String -> Int32 -> String -> String -> Maybe String -> Maybe String -> Columns

remarks' :: Pi Columns (Maybe String)

text' :: Pi Columns (Maybe String)

generated' :: Pi Columns String

identity' :: Pi Columns String

inlineLength' :: Pi Columns Int32

hidden' :: Pi Columns String

specialProps' :: Pi Columns (Maybe String)

dlFeatures' :: Pi Columns (Maybe String)

sourceTabname' :: Pi Columns (Maybe String)

sourceTabschema' :: Pi Columns (Maybe String)

scopeTabname' :: Pi Columns (Maybe String)

scopeTabschema' :: Pi Columns (Maybe String)

targetTypename' :: Pi Columns (Maybe String)

targetTypeschema' :: Pi Columns (Maybe String)

numnulls' :: Pi Columns Int64

nmostfreq' :: Pi Columns Int16

nquantiles' :: Pi Columns Int16

partkeyseq' :: Pi Columns (Maybe Int16)

keyseq' :: Pi Columns (Maybe Int16)

avgcollen' :: Pi Columns Int32

low2key' :: Pi Columns (Maybe String)

high2key' :: Pi Columns (Maybe String)

colcard' :: Pi Columns Int64

compact' :: Pi Columns String

logged' :: Pi Columns String

codepage' :: Pi Columns Int16

nulls' :: Pi Columns String

default' :: Pi Columns (Maybe String)

scale' :: Pi Columns Int16

length' :: Pi Columns Int32

typename' :: Pi Columns String

typeschema' :: Pi Columns String

colno' :: Pi Columns Int16

colname' :: Pi Columns String

tabname' :: Pi Columns String

tabschema' :: Pi Columns String

insertQueryColumns :: forall p. Relation p Columns -> InsertQuery p

insertColumns :: Insert Columns

columns :: Relation () Columns

tableOfColumns :: Table Columns

columnOffsetsColumns :: Array Int Int