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

Generic Columns

Associated Types

type Rep Columns :: * -> *

Methods

from :: Columns -> Rep Columns x

to :: Rep Columns x -> Columns

PersistableWidth Columns

Methods

persistableWidth :: PersistableRecordWidth Columns

TableDerivable Columns

Methods

derivedTable :: Table Columns

ShowConstantTermsSQL Columns

Methods

showConstantTermsSQL' :: Columns -> DList StringSQL

HasProjection "avgcollen" Columns Int32

Methods

projection :: PiLabel "avgcollen" -> Pi Columns Int32

HasProjection "codepage" Columns Int16

Methods

projection :: PiLabel "codepage" -> Pi Columns Int16

HasProjection "colcard" Columns Int64

Methods

projection :: PiLabel "colcard" -> Pi Columns Int64

HasProjection "colname" Columns String

Methods

projection :: PiLabel "colname" -> Pi Columns String

HasProjection "colno" Columns Int16

Methods

projection :: PiLabel "colno" -> Pi Columns Int16

HasProjection "compact" Columns String

Methods

projection :: PiLabel "compact" -> Pi Columns String

HasProjection "generated" Columns String

Methods

projection :: PiLabel "generated" -> Pi Columns String

HasProjection "hidden" Columns String

Methods

projection :: PiLabel "hidden" -> Pi Columns String

HasProjection "identity" Columns String

Methods

projection :: PiLabel "identity" -> Pi Columns String

HasProjection "inlineLength" Columns Int32

Methods

projection :: PiLabel "inlineLength" -> Pi Columns Int32

HasProjection "length" Columns Int32

Methods

projection :: PiLabel "length" -> Pi Columns Int32

HasProjection "logged" Columns String

Methods

projection :: PiLabel "logged" -> Pi Columns String

HasProjection "nmostfreq" Columns Int16

Methods

projection :: PiLabel "nmostfreq" -> Pi Columns Int16

HasProjection "nquantiles" Columns Int16

Methods

projection :: PiLabel "nquantiles" -> Pi Columns Int16

HasProjection "nulls" Columns String

Methods

projection :: PiLabel "nulls" -> Pi Columns String

HasProjection "numnulls" Columns Int64

Methods

projection :: PiLabel "numnulls" -> Pi Columns Int64

HasProjection "scale" Columns Int16

Methods

projection :: PiLabel "scale" -> Pi Columns Int16

HasProjection "tabname" Columns String

Methods

projection :: PiLabel "tabname" -> Pi Columns String

HasProjection "tabschema" Columns String

Methods

projection :: PiLabel "tabschema" -> Pi Columns String

HasProjection "typename" Columns String

Methods

projection :: PiLabel "typename" -> Pi Columns String

HasProjection "typeschema" Columns String

Methods

projection :: PiLabel "typeschema" -> Pi Columns String

HasProjection "default_" Columns (Maybe String)

Methods

projection :: PiLabel "default_" -> Pi Columns (Maybe String)

HasProjection "dlFeatures" Columns (Maybe String)

Methods

projection :: PiLabel "dlFeatures" -> Pi Columns (Maybe String)

HasProjection "high2key" Columns (Maybe String)

Methods

projection :: PiLabel "high2key" -> Pi Columns (Maybe String)

HasProjection "keyseq" Columns (Maybe Int16)

Methods

projection :: PiLabel "keyseq" -> Pi Columns (Maybe Int16)

HasProjection "low2key" Columns (Maybe String)

Methods

projection :: PiLabel "low2key" -> Pi Columns (Maybe String)

HasProjection "partkeyseq" Columns (Maybe Int16)

Methods

projection :: PiLabel "partkeyseq" -> Pi Columns (Maybe Int16)

HasProjection "remarks" Columns (Maybe String)

Methods

projection :: PiLabel "remarks" -> Pi Columns (Maybe String)

HasProjection "scopeTabname" Columns (Maybe String)

Methods

projection :: PiLabel "scopeTabname" -> Pi Columns (Maybe String)

HasProjection "scopeTabschema" Columns (Maybe String)

Methods

projection :: PiLabel "scopeTabschema" -> Pi Columns (Maybe String)

HasProjection "sourceTabname" Columns (Maybe String)

Methods

projection :: PiLabel "sourceTabname" -> Pi Columns (Maybe String)

HasProjection "sourceTabschema" Columns (Maybe String)

Methods

projection :: PiLabel "sourceTabschema" -> Pi Columns (Maybe String)

HasProjection "specialProps" Columns (Maybe String)

Methods

projection :: PiLabel "specialProps" -> Pi Columns (Maybe String)

HasProjection "targetTypename" Columns (Maybe String)

Methods

projection :: PiLabel "targetTypename" -> Pi Columns (Maybe String)

HasProjection "targetTypeschema" Columns (Maybe String)

Methods

projection :: PiLabel "targetTypeschema" -> Pi Columns (Maybe String)

HasProjection "text" Columns (Maybe String)

Methods

projection :: PiLabel "text" -> Pi Columns (Maybe String)

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

type Rep Columns

type Rep Columns = D1 (MetaData "Columns" "Database.Relational.Schema.DB2Syscat.Columns" "relational-schemas-0.1.6.1-DoN55Q5HCm8FUcXlxZp8a3" False) (C1 (MetaCons "Columns" PrefixI True) ((:*:) ((:*:) ((:*:) ((:*:) ((:*:) (S1 (MetaSel (Just Symbol "tabschema") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 String)) (S1 (MetaSel (Just Symbol "tabname") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 String))) ((:*:) (S1 (MetaSel (Just Symbol "colname") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 String)) (S1 (MetaSel (Just Symbol "colno") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 Int16)))) ((:*:) ((:*:) (S1 (MetaSel (Just Symbol "typeschema") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 String)) (S1 (MetaSel (Just Symbol "typename") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 String))) ((:*:) (S1 (MetaSel (Just Symbol "length") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 Int32)) ((:*:) (S1 (MetaSel (Just Symbol "scale") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 Int16)) (S1 (MetaSel (Just Symbol "default_") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe String))))))) ((:*:) ((:*:) ((:*:) (S1 (MetaSel (Just Symbol "nulls") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 String)) (S1 (MetaSel (Just Symbol "codepage") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 Int16))) ((:*:) (S1 (MetaSel (Just Symbol "logged") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 String)) (S1 (MetaSel (Just Symbol "compact") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 String)))) ((:*:) ((:*:) (S1 (MetaSel (Just Symbol "colcard") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 Int64)) (S1 (MetaSel (Just Symbol "high2key") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe String)))) ((:*:) (S1 (MetaSel (Just Symbol "low2key") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe String))) ((:*:) (S1 (MetaSel (Just Symbol "avgcollen") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 Int32)) (S1 (MetaSel (Just Symbol "keyseq") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe Int16)))))))) ((:*:) ((:*:) ((:*:) ((:*:) (S1 (MetaSel (Just Symbol "partkeyseq") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe Int16))) (S1 (MetaSel (Just Symbol "nquantiles") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 Int16))) ((:*:) (S1 (MetaSel (Just Symbol "nmostfreq") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 Int16)) (S1 (MetaSel (Just Symbol "numnulls") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 Int64)))) ((:*:) ((:*:) (S1 (MetaSel (Just Symbol "targetTypeschema") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe String))) (S1 (MetaSel (Just Symbol "targetTypename") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe String)))) ((:*:) (S1 (MetaSel (Just Symbol "scopeTabschema") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe String))) ((:*:) (S1 (MetaSel (Just Symbol "scopeTabname") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe String))) (S1 (MetaSel (Just Symbol "sourceTabschema") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe String))))))) ((:*:) ((:*:) ((:*:) (S1 (MetaSel (Just Symbol "sourceTabname") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe String))) (S1 (MetaSel (Just Symbol "dlFeatures") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe String)))) ((:*:) (S1 (MetaSel (Just Symbol "specialProps") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe String))) (S1 (MetaSel (Just Symbol "hidden") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 String)))) ((:*:) ((:*:) (S1 (MetaSel (Just Symbol "inlineLength") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 Int32)) (S1 (MetaSel (Just Symbol "identity") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 String))) ((:*:) (S1 (MetaSel (Just Symbol "generated") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 String)) ((:*:) (S1 (MetaSel (Just Symbol "text") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe String))) (S1 (MetaSel (Just Symbol "remarks") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe String))))))))))

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