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

PersistableWidth Columns

TableDerivable 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)

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