The Relational Database Query Utility (hsql) utility lets you generate reports from a client computer. Output is generated in a form that you can import to spreadsheet or word-processing programs. To generate this type of SQL, you must understand the relationships among the various CA Harvest SCM tables.
When you execute hsql from the command line (not as a user-defined process), it requires a CA Harvest SCM server process to perform the required transaction with the relational database.
If no input and output options are specified, hsql reads input from the standard input and writes output to the standard output. On Windows, input and output files are required. The hsql utility is limited to executing SQL SELECT queries, and cannot alter the contents of the CA Harvest SCM database.
To simplify the documenting of SQL input files, hsql supports a comment feature. Any line that begins with a pound sign (#) in column one is treated as a comment and ignored at execution time.
Note: For detailed descriptions of the hsql command options, see the Command Line Reference Guide.
|
Copyright © 2013 CA.
All rights reserved.
|
|