In this step, you code either a procedure or a function in C, and then you compile the resulting C program. Compilation produces an object file. You then link multiple object files to create a C library file.

In this step, you register the new C library file in HiRDB.

Registration by a HiRDB administrator:

The HiRDB administrator uses the pdclibsync command.

Registration by the UAP developer:

The programmer codes the INSTALL CLIB or REPLACE CLIB statement of the SQL in the UAP, and then executes it.

You use the CREATE PROCEDURE or CREATE FUNCTION statement to define an external C stored routine.

As in the case of executing a stored procedure or a stored function, you execute the SQL by specifying either a CALL statement or a function call. The CALL statement causes a C function to be executed as a C stored procedure. The function call causes a C function to be executed as a C stored function.