Advanced Report Design
CentreVu CMS Custom Reports
Creating a Custom Data Table
6-9
NULLS
Enter
y
if you want to allow the column to have
rows with no values (versus requiring values). For
example, if your table is a list of customer data and
the column you are adding is for the customer’s
employer, you might want to allow the
NULL
value
for the case where the person is unemployed.
Enter
n
if you want to require a value in each row.
NULLS
appears for all types except
Serial.
ADD STARTING
NUMBER
Enter the number that
INFORMIX should use as a
starting point for numbering rows.
INFORMIX
identifies the first row in the table with the number
you enter. As each new row of data is added to the
table,
INFORMIX assigns that row the next number
in the sequence.
ADD STARTING NUMBER
appears only for
Serial
.
NUMERIC
Type the first letter of the numeric you want: Integer,
Smallint, Decimal,
or Float.
LENGTH
Enter the number of digits the column will store for a
single piece of data.
LENGTH
appears for
Char
and
Decimal
types
SCALE
Enter the number of digits that should appear to the
right of the decimal point. The decimal digits, but not
the decimal point, occupy part of the field length you
specified in the
LENGTH
field.
SCALE
appears
after the
LENGTH
for
Decimal
.
Table 6-2: Prompts for
INFORMIX Data Types — Continued
Prompt
What to Do
2j. When you have added all columns,
press the
key until the
Create Table screen appears.
→
The
Create Table
menu
appears.
Return
Summary of Contents for CentreVu
Page 16: ...Preface CentreVu CMS R3V5 Custom Reports Related Documents P 10 ...
Page 44: ...Getting Started CentreVu CMS Custom Reports Deleting a Custom Report 2 10 ...
Page 140: ...Completing Your Custom Report CentreVu CMS Custom Reports Running Custom Reports 5 22 ...
Page 178: ...Database Items and Calculations CentreVu CMS Custom Reports General Information A 2 ...
Page 188: ...Glossary CentreVu CMS Custom Reports GL 10 ...
Page 198: ......