The table below shows the options and control statements that are specified during reorganization using a UOC.

Table 8-29 Options and control statements that are specified during reorganization using UOC

Type			Option		Control statement		Output to file
			-k	-W	unload statement	unlduoc statement	pdrorg	UOC
Deleting unneeded data#1	Table reorganization		rorg	N	Y#3	Y	Output	Optional
	Table unload + reload operation	Unload operation	unld	--	Y#3	Y	Output	Optional
		Reload operation	reld	--	Y#3	--	--	--
Updating data for use by applications#2	File output by pdrorg		unld	Y	Y#3	Y	Output	Optional
	File output by UOC		unld	N	Y#4	Y	Not applicable	Required

Legend:

Y: Specify.

N: Cannot be specified (results in an error if specified).

--: Ignored, if specified.

#1: If the table contains columns of an abstract data type, data is passed to the UOC only for the abstract data type columns for which the constructor parameter reverse creation function has been specified in the unld_func statement. In this case, the null value is passed to the UOC, but the retrieved data is stored in the unload data file. Therefore, the UOC cannot determine whether or not the data is needed.

#2: If the table contains columns of an abstract data type, specify the unld_func statement for all such abstract data type columns. If the unld_func statement is not specified, an error results.

#3: Specify the name of the unload data file in the unload statement.

#4: Specify (uoc) in the unload statement.

The following are the option specification rules for reorganization using a UOC:

1. You can use a UOC for reorganization during table reorganization (-k rorg) or a table unload operation (-k unld).
2. If the table contains a column of large object data type or an abstract data type with the large object data attribute, you must specify the -j option. An error results if the -j option is omitted.
3. dic (data dictionary table is to be processed) cannot be specified in the -c option. Specifying dic results in an error.
4. If you specify (uoc) in the unload statement, you cannot specify the -W option. Specifying the -W option results in an error.
5. If you specify (uoc) in the unload statement, specifying the -f option results in an error.

The following are the control statement specification rules for reorganization using a UOC:

1. To use a UOC for reorganization, you must always specify the following two control statements:
   
   • unlduoc statement
   • unload statement
2. The lobunld statement cannot be specified.

Table 8-28 describes the relationship between the host and the server that calls the UOC. You must provide the shared library that contains the applicable UOC on the appropriate host, as indicated in the table below.

Table 8-30 Relationship between the host and the server that calls the UOC

Execution environment				Server	Host
HiRDB single server configuration	-g omitted			Single server	Host where the single server is located
	-g specified			Utility server (pdrorgm)	Host specified in the unload statement
HiRDB parallel server configuration	-g omitted	In units of tables	Non-partitioned table	Back-end server	Host where the server containing the table is located
			Partitioned table		All hosts where the servers specified in the unload statement are located
		In units of RDAREAs			Host where the server containing the specified RDAREA is located
	-g specified			Utility server (pdrorgm)	Host specified in the unload statement

pdrorg provides a function for converting the data according to specified options and control statements. Reorganization using a UOC can also use this function. This data conversion function passes unconverted data to the UOC and converts data before saving the data in the unload data file. The table below describes the data to be passed to the UOC and pdrorg's data conversion timing.

Table 8-31 Data that is passed to the UOC and pdrorg's data conversion timing

Type	Option or control statement available for data conversion	Data passed to UOC	Data conversion timing
Deleting unneeded data (table reorganization)	-S	Data with spaces	When unload data file is output
	-W	--	--
	-W dat,sup or -W extdat,sup	--	--
	spacelvl in option statement	Data without space conversion	When table is reloaded
	blobtovarchar statement	--	--
Deleting unneeded data (table unload + reload operations)	-S	Data with spaces	When unload data file is output
	-W	--	--
	-W dat,sup or -W extdat,sup	--	--
	spacelvl in option statement	Data without space conversion	When table is reloaded
	blobtovarchar statement	--	--
Updating data for use by applications (file output by pdrorg)	-S	--	--
	-W	Data before being converted to DAT or binary format	When unload data file is output#
	-W dat,sup or -W extdat,sup	Data with spaces	When unload data file is output#
	spacelvl in option statement	Data without space conversion	When unload data file is output#
	blobtovarchar statement	Data in the BLOB format	When unload data file is output#
Updating data for use by applications (file output by UOC)	-S	Data with spaces	--
	-W	--	--
	-W dat,sup or -W extdat,sup	--	--
	spacelvl in option statement	Data without space conversion	--
	blobtovarchar statement	--	--
Converting character codes	charset in the option statement	Data converted to the specified character codes	When unload data is acquired (before the UOC is called)

Legend:

--: Not applicable

Note

If the table contains a column of DECIMAL type for which SUPPRESS was specified in the table definition, the data obtained after expansion is passed to the UOC. The data is converted when the table is reloaded.

#: The data obtained after editing by the UOC is converted.