Specifications

20 – Using PlantScape Data in Other Applications
424 R400
Checking Commands
SQLCHK Utility
The Input Reference file can be checked for PlantScape server database reference
syntax errors by using a command-line utility, SQLCHK. Each command is read
and if there is an embedded PlantScape server database reference before the
end-of-command marker (“;”) it is resolved and data substituted. Embedded
references occurring after the “;” are checked for consistency but data is not
substituted. Any errors are flagged and a total error count is given after all
commands have been read. The commands plus substitutions and error messages
are printed to the workstation display and to an output file if one is specified.
Format
SQLCHK reference_file [-OUT output_file ][-OFFSET
record_offset ]
Where:
reference_file
Path of input SQL file
output_file
Optional path name of the file to receive checked data and error messages.
If this is not specified, the output is printed to the display only.
record_offset
Optional offset added to a negative record number in a reference to a
PlantScape server database file. This is optional and the default is zero.
Example sqlchk command.sql -out command.out -offset 3
ODBC Data Exchange Report Reference
The following sections provide details of how each type of database reference is
formatted.
plscpcg.book Page 424 Monday, May 28, 2001 10:11 AM