Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Administrator's GuideThe HCL OneDB™ Administrator's Guide provides the information required to administer HCL OneDB™.
Disk, memory, and process management
Moving data with external tablesYou can use external tables to load and unload database data.
Load data from and unload to a named pipeYou can use a named pipe, also called a first-in-first-out (FIFO) data file, to load from and unload to a nonstandard device, such as a tape drive.
Loading data with named pipesYou can use a named pipe to load data from external tables.

Loading data with named pipes

You can use a named pipe to load data from external tables.

About this task

To use a named pipe to load data from an external table, follow these steps:

Specify the named pipes in the DATAFILES clause of the CREATE EXTERNAL TABLE statement in SQL.
Create the named pipes that you specified in the DATAFILES clause.
Use operating-system commands to create the named pipes.
Use the mknod UNIX™ command with the -p option to create a named pipe. To avoid blocking open problems for pipes on UNIX, start separate UNIX processes for pipe-readers and pipe-writers or open the pipes with the O_NDELAY flag set.
Open the named pipes with a program that reads the named pipe.

Execute the INSERT statement in SQL.

INSERT INTO employee SELECT * FROM emp_ext;

Important: If you do not create and open the named pipes before you execute the INSERT statement, the INSERT succeeds, but no rows are loaded.