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/ORATOORA.sqd ./ENGINE/ORATOORA.prc ENGINE=ORATOORA HOST=udbsvr1 PORT=2626 > ./ENGINE/ORATOORA.prtNote: 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 ./ORADDL (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>.outor using the sqdmon utility start command along with a properly configured daemon:
SQDMON start ///<engine_alias> --service=2626Example
A simple shell script is frequently used to execute the engine:
sqdata ./ENGINE/ORATOORA.prc > ORATOORA.outor using the sqdmon start command;
sqdmon start ///ORATOORA --service=2626along with a properly configured daemon:
[ORATOORA]
type=engine
program=sqdata
args=./ENGINE/ORATOORA.prc
working_directory=/home/sqdata/demo
stdout_file=/ORATOORA.rpt
stderr_file=/ORATOORA.rpt
auto_start=no