5.7.2 skipdata statement

Organization of this subsection
(1) Format
(2) Operands
(3) Notes

(1) Format

*skipdata* [{,length=bytes-count|,type=data-type[,element=elements-count]}]

(2) Operands

(a) length=bytes-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.

Rules
  1. There is no need to specify this operand for a DAT-format file.
  2. To skip a linefeed code, if the linefeed code consists of linefeed code (\n) and carriage return code (\r), specify as length=2.
(b) type=data-type

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 parameterData type specification methodWhether pdload unload file can be specified
ClassificationData type
Numeric dataINTEGERintegerY
SMALLINTsmallintY
DECIMALdec(precision[,decimal-places])Y
adec(precision[,decimal-places])N
bdec(n)N
FLOATfloatY
SMALLFLTsmallfltY
Character string dataCHARACTERchar(n)Y
VARCHARvarchar(n)Y
National character dataNCHARnchar(m)Y
NVARCHARnvarchar(m)Y
Mixed character string dataMCHARmchar(n)Y
MVARCHARmvarchar(n)Y
Date dataDATEdateY
yy-mm-ddN
yymmddN
Time dataTIMEtimeY
Timestamp dataTIMESTAMPtimestamp(p)Y
Date interval dataINTERVAL YEAR TO DAYinterval-year-to-dayY
Time interval dataINTERVAL HOUR TO SECONDinterval-hour-to-secondY
Large object dataBLOBblobY
blobprmN
Binary dataBINARYbinary(n)Y
binaryprmN
Legend:
Y: Can be specified.
N: Cannot be specified.

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.

(c) element=elements-count

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.

(3) Notes

  1. If an input data file in the fixed-size data format is a text file, specify the skipdata statement to avoid storing the linefeed code at the end of a line.
  2. The skipdata statement is specifiable for a column, but not for a function argument.
  3. The following table shows whether or not each operand is specifiable by the type of input data file:
    OperandFormat of input data file
    DAT formatFixed-size data formatpdrorg-output binary format
    length--Y--
    type----Y
    Y: Mandatory
    --: Not specifiable