We are finding out that the hsql command is unable to download larger files than 2000 characters? Is this the case or perhaps we are missing some options that would make this work?
CA Harvest SCM all versions and platforms
Oracle 11g or 12c DBMS
Instead of using hsql, you might need to go directly to the database using SQL Plus or a pl/sql script. If you are wanting to extract versions of text files from the HARVERSIONDATA table, or form type templates from the HARFORMTEMPLATE table, you can set up a loop to extract 2000 characters at a time and concatenate (or write) the results.