Prepare engine shell script - connect_cdc_sqdata - Latest

Connect CDC (SQData) Change Data Capture
Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Change Data Capture
Copyright
2024
First publish date
2000
Last updated
2024-11-25
Published on
2024-11-25T15:05:48.570404

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