Jd/Ops create

From J Wiki
Jump to: navigation, search
Jd | Overview | General | Docs | Ops | Admin | Replicate | Guide | Technical | Release | License | Support


createcol table col type
createcol table col byte [trailing-shape]
createcol table col type data
createcol table col byte [trailing-shape] data

creates new col with default values or data



valid only after a dropdb
creates filefolder, initial files, and gets lock


createdcol table col type verb
createdcol table col byte [trailing-shape] verb

creates a derived col
derived col data is not from a mapped file
derived col data is the result of verb derived_verb defined in custom.ijs

a derived byte 3 col could be derived from the category part of a byte 20 col
a derived int col could be derived from the year in an edatetime col

tutorial createdcol


createtable [/a ...] table [coldefs]
createtable /pairs [/types] [/a ...] table ; pairs

/a min_rows multiplier extra_rows
when insert requires mapped col file resize, new size is:
default is 2000 1.5 0
/types - pairs have types in parens - cola(edate)

createtable with 0 or more cols

coldefs - col type [trailing-shape]
string arg coldefs separated by , or LF
boxed arg coldefs in separate boxes


createptable table pcol

allowed pcol types: int edate edatetime date datetime

table must have 0 rows

tutorial ptable