Connect CDC SQData

Parsing and Starting the Engine is a two step process, each consisting of a single command that can be run at the command line or more frequently using  separate scripts or a single (parse and run) shell script.

The SQData Parser (SQDPARSE) creates a compiled or parsed command script from a source script file.

Syntax

SQDPARSE  <engine>.sqd  <engine>.prc [LIST=ALL|SCRIPT] [ <parm1>  <parm2> …<parmn>] [>  <engine>.prt]

 

Example

A shell script containing a single line similar to the following is frequently used to execute the parser:

sqdparse ./ENGINE/UDBTOUDB.sqd ./ENGINE/UDBTOUDB.prc ENGINE=UDBTOUDB HOST=udbsvr1 PORT=2626 > ./ENGINE/UDBTOUDB.prt

 

Note: In the Parser example above the working directory is one level up from the "ENGINE" directory containing the actual engine script. References in the script to the location of DDL table descriptions, called procedures, etc must be sensitive to their location in the directory hierarchy, ie: ./<directory_name>/<file_name>. In this case probably ./UDBDDL (note the single dot).

The SQData Engine uses the parsed command script. The engine can be either executed directly at the command line or using a batch script or started using the Daemon.

 

Syntax

SQDATA <engine>.prc > <engine>.out

 

or using the sqdmon utility start command along with a properly configured daemon:

SQDMON start ///<engine_alias> --service=2626

 

Example

A simple shell script is frequently used to execute the engine:

sqdata ./ENGINE/UDBTOUDB.prc > UDBTOUDB.out

 

or using the sqdmon start command;

sqdmon start ///UDBTOUDB --service=2626

 

along with a properly configured daemon:

 

[UDBTOUDB]

type=engine

program=sqdata

args=./ENGINE/UDBTOUDB.prc

working_directory=/home/sqdata/demo

stdout_file=/UDBTOUDB.rpt

stderr_file=/UDBTOUDB.rpt

auto_start=no