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

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.3.2-DZkQ50tJhtK8GpWz478oOl" 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