c-treeACE V11.0 Update Guide

c-treeACE SQL Deployment Utilities for Stored Procedures, UDF, and Triggers

In V11 and later, c-treeACE SQL stored procedure dump and deploy utilities render it unnecessary to require both a Java compiler (JDK) and run-time engine (JRE) on every server. A single utility is now provided allowing deployments to dump stored procedures (SP), user defined functions (UDF), and triggers created on one c-treeACE SQL installation. A second utility deploys procedures, etc. to other remote c-treeACE SQL installations.

• A JDK is still required to develop and compile SPs, UDFs, and triggers on one server, but is not required on remote deployed servers.
• A JRE is still required on each deployed c-treeACE SQL installation that will execute SPs, UDFs, and triggers.

dbschema

After developing a SP, UDF, or trigger, call the dbschema utility with the new -b option to dump your procedure routines such that they can be deployed with the new dbdeploy utility.

Usage

dbschema [-d] [-b] [-u username] [-a authentication] [-o outputfile]

[-t tablenamelist] [-p procedure_name_list]

[-f function_name_list] [-T trigger_name_list]

[dbsegment_name]

• -d - Dump the data
• -b - Dump stored procedures, user-defined functions, or triggers in binary format so they can be deployed using dbdeploy
• -o - Output file (default: screen)

dbdeploy

The SP, UDF, or trigger in the output file generated using dbschema -b can be deployed to other c-treeACE SQL installations with the dbdeploy utility.

Usage

dbdeploy [-u username] [-a authentication] [-i inputfile]

[dbsegment_name]

• -u - Username identifiable to the DBMS
• -a - Password for authentication
• -i - Input file.