Physical Modeling › Columns › Define Database Column Properties › Define iSeries Database Column Properties

Define iSeries Database Column Properties

In a model based on an iSeries target server, you use the two iSeries tabs in the Columns dialog to manage the datatype, null option, default value, and other properties for the selected column.

Note: An asterisk next to any property indicates that the property value is derived from domain inheritance or a macro.

To define iSeries column properties

1. Click Columns on the Model menu.

   The Columns dialog opens.

2. Click both iSeries tabs, select from the following options in each one, and click OK:

   (First iSeries tab)

   iSeries Datatype

   Lets you select a datatype from the list to change the datatype of the selected column. If the selected datatype requires a value for precision, scale, or both, enter the value inside the datatype parentheses. For example, you can select the DECIMAL() datatype and specify a precision of 2 and a scale of 10 inside the parentheses, to assign the datatype DECIMAL(2,10) to the selected column. If you select either the VARCHAR() or VARGRAPHIC() datatype, then you have the following option:

   Alloc

   Lets you enter a value in characters that defines the space you want to allocate for the column in each row.

   Type

   Lets you select a subdatatype option to use along with the iSeries datatype.

   Null Option

   Lets you specify a null option for the selected column.

   Average Width

   Lets you enter an estimated average width for the column if the option is available (not dimmed). You can later use the Volumetrics dialog to calculate table and database size estimates based on these and other values.

   Percent NULL

   Lets you enter the estimated percentage of nulls used for that column if the option is available. For example, you can estimate a variable width ADDRESS 2 column assigned a width of 50 characters, to be NULL about 30 percent of the time. Use whole numbers. You can later use the Volumetrics dialog to calculate table and database size estimates based on these and other values.

   (Second iSeries tab)

   Label

   Lets you enter the name of a label that appears opposite the column value in iSeries applications.

   Heading

   Lets you enter the name of a heading for column values when they appear as a table.

   System Name

   Lets you enter a name to override the alias name that iSeries automatically assigns to each column. Leave this field empty if you want the iSeries database to automatically truncate the column name to show only the first 10 characters.

   iSeries column properties are defined and the Columns dialog closes.