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

[Figure]<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

For an input data file in the pdrorg-generated binary format, this operand specifies the data type of the column to be skipped.

For details about how to specify the data types, see (3) in section 5.7.1 Column name statement. Note that you cannot specify yy-mm-dd or yymmdd. blobprm is applicable only to an input data file in the pdrorg-generated binary format.

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

For an input data file in the pdrorg-generated 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-generated binary format
    length[Figure]Y[Figure]
    type[Figure][Figure]Y

Y: Mandatory

[Figure]: Not specifiable