Creating a custom data table
Issue 3.0 May 2002
135
6. Type a name of up to 18 characters for the column you are adding. If needed you can
use names of standard CMS database items only if you enter the name in lowercase
letters in the Dictionary subsystem. The Dictionary: Custom Items window accepts only
lowercase letters for custom item names that are the same as standard database
items. Press Return.
The
system displays the Add Type
screen:
7. Select the type of data that the field will store.
Data types table
Char
Character (CHAR) columns store any combination
of letters, numbers, and symbols.
Number
Numeric columns store numbers. The numbers
stored can be one of the following five types:
— Decimal. A decimal is a number that contains
a decimal point.
— Smallint. A Smallint column stores integers
from -32,767 to +32,767.
— Integer. An Integer column stores integers
from -2,147,483,647 to +2,147,483,647.
— Smallfloat. A Smallfloat column stores floating
point numbers with up to seven significant
digits.
— Float. A Float column stores floating point
numbers with up to 14 significant digits.
Serial
Serial columns store a unique sequence number in
each row of the table.
Date
Date columns store calendar dates with the format
mm/dd/yy
.
ADD TYPE c_workcode :
Char Number Serial Date Money date-Time Interval
Prints any combination of letters, numbers, and punctuation.
------ Page 1 of 1 --------- cms -------- Press CTRL-W for Help --------
Column Name
Type
Length
Index
Nulls
cwc
...........
.
.
...........