Can I use system variables in my HSQL select statement?

Document ID : KB000054679
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

Unlike other Harvest Command Line utilities, HSQL does not resolve system variables.

Solution

The HSQL command line utility enables user to execute SQL query with only SELECT Statement against the Harvest database. It reads from standard input or an input file which must contains the complete SQL query to be executed. Therefore, no Harvest system variables can be parsed as part of the SQL command.