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

(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 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

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.

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:
   

   Operand	Format of input data file
   	DAT format	Fixed-size data format	pdrorg-output binary format
   length	--	Y	--
   type	--	--	Y

   Y: Mandatory
   --: Not specifiable