The Insert method adds a new Field method
to the end of the Fields Object.
- Syntax
- object.Insert( Name, Description, Type, Length, Scale,
CCSID, Default, Allocate, Padding, NullCapable );
- Parameters
- Name
- Data type: String
- The name of the Field method.
- Description
- Data type: String
- The optional
description of the field.
- Type
- Data type: Long
- The field type.
- Length
- Data type: Long
- The number of
digits or characters for the field.
- Scale
- Data type: Long
- The number of digits
after the decimal.
- CCSID
- Data type: String
- The host CCSID
for the field.
- Default
- Data type: String
- The default
value of the field when it is empty.
- Allocate
- Data type: Long
- The fixed length
space allocated for the field for VARCHAR and VARGRAPHICS.
- Padding
- Data type: Long
- Allows for extra
space in a CHARACTER or GRAPHIC field.
- NullCapable
- Data type: Long
- The field
can contain null values.
- Example
- Set Fields = bzlipi.Fields() Fields.Insert "F1", "", 1,
776, 0, "*DEFAULT", "*DEFAULT", 0, 0, 0