*skipdata* [{,length=bytes-count|,type=data-type[,element=elements-count]}] |
~<unsigned integer> ((1-32000))
For an input data file in the fixed-size data format, this operand specifies in bytes the length of the column that is to be skipped.
Specifies the data type of columns that are to be skipped when the input data file is a pdload unload file.
The table below shows the data type specification method and whether the data type can be specified.
Table 5-47 Data type specification method and whether the data type can be specified
Data type of parameter | Data type specification method | Whether pdload unload file can be specified | |
---|---|---|---|
Classification | Data type | ||
Numeric data | INTEGER | integer | Y |
SMALLINT | smallint | Y | |
DECIMAL | dec(precision[,decimal-places]) | Y | |
adec(precision[,decimal-places]) | N | ||
bdec(n) | N | ||
FLOAT | float | Y | |
SMALLFLT | smallflt | Y | |
Character string data | CHARACTER | char(n) | Y |
VARCHAR | varchar(n) | Y | |
National character data | NCHAR | nchar(m) | Y |
NVARCHAR | nvarchar(m) | Y | |
Mixed character string data | MCHAR | mchar(n) | Y |
MVARCHAR | mvarchar(n) | Y | |
Date data | DATE | date | Y |
yy-mm-dd | N | ||
yymmdd | N | ||
Time data | TIME | time | Y |
Timestamp data | TIMESTAMP | timestamp(p) | Y |
Date interval data | INTERVAL YEAR TO DAY | interval-year-to-day | Y |
Time interval data | INTERVAL HOUR TO SECOND | interval-hour-to-second | Y |
Large object data | BLOB | blob | Y |
blobprm | N | ||
Binary data | BINARY | binary(n) | Y |
binaryprm | N |
If a table with an abstract data type column is output to a binary-format input data file by pdrorg's unload processing, data in the abstract data type column in the file is converted to the data type of the constructor function's argument by the constructor parameter reverse creation function that was specified during unloading. Therefore, specify in the type operand the data type that is created by the constructor parameter reverse creation function. For details about the data type that is created by the constructor parameter reverse creation function, see the documentation for the applicable plug-in.
In the case of an input data file in pdrorg-output binary format, if a repetition column is to be skipped, this operand specifies the maximum number of elements for the repetition column.
This operand must follow the type operand.
Operand | Format of input data file | ||
---|---|---|---|
DAT format | Fixed-size data format | pdrorg-output binary format | |
length | -- | Y | -- |
type | -- | -- | Y |