A column structure information file is specified in the following cases:
Item | Format of input data file | Explanation |
---|
DAT format | Fixed-size data format | pdrorg-generated binary format |
---|
Storing data with a column sequence different from input data file and table | Y | Y | Y | 1 |
Storing data with a column count different from input data file and table | Y | Y | Y | 2 |
Storing data in the input data file after converting it to the data type of the column in the table | ![[Figure]](figure/zueng033.gif) | Y | NS | 3 |
Storing a column value in the input data file that matches the null comparison value as the null value | ![[Figure]](figure/zueng033.gif) | Y | Y | 4 |
Specifying a constructor function that generates values to be stored in abstract data type | Y | Y | NS | 5 |
The number of elements for repetition columns in the input data file is less than the maximum number of elements in table definition | Y | Y | * | 6 |
Y: Specifiable.
NS: Not specifiable.
: Not applicable
* If the arrayed data format is VV, you cannot specify the number of elements.
- Explanation:
- Specify column name statements in the order of corresponding input data.
- If some of the input data is not to be stored in the table, specify a skipdata statement for such data. If there is no input data to be stored in the table, omit the column name statement.
- Specify the data type of the table column in the corresponding column name statement.
- Specify the comparison value (input data) to be treated as the null value in the column name statement.
- Specify the constructor function name and parameter type in the column name statement. If the name of the constructor function that generates the data to be stored in the abstract data type is different from the name of the column data type, or if there are multiple functions with the same name, be sure to specify the column structure information file. For the fixed-size data format, also specify the data type of the input parameter and the null comparison value.
- Specify the number of input data elements in the column name statement. For details about the column name statement, see 5.7.1 Column name statement; for details about the skipdata statement, see 5.7.2 skipdata statement.
- Rules
- If an input data file is in the fixed-size data format, be sure to specify a column structure information file. For an input data file in the DAT format or the pdrorg-generated binary format, you can specify a column structure information file as required.
For an input data file in the pdrorg-generated binary format, you can specify a column structure information file only for a non-FIX table. Specifying a column structure information file for a FIX table results in an error. To reorganize the column structure of a FIX table using a column structure information file, handle the input data file as being in the fixed-size data format.
- Specify each column name statement and skipdata statement on a single line. If you need more than one line and the last character in the line is a comma (,) for separating operands, specify at least one byte of space or tab between the comma and the continuation character ($), and specify a continuation character at the end of the line. In this manner, you can specify information over more than one line.
- When specifying a column structure information file, also specify the -c option.
- If you are creating a LOB column structure base table separately from LOB columns and specify a column structure information file during the creation of the LOB column structure base table, you need to specify a column structure information file containing the same information also during the creation of the LOB columns. Otherwise, the LOB column creation process may result in an error.
- Organization of this section
- 5.7.1 Column name statement
- 5.7.2 skipdata statement
- 5.7.3 Specification examples