Directing query output from loadercli

[Former Member]

I would like to execute a query from a command file or on the command line with loadercli and get the results of the query piped to an output file or the console.

The query is a simple select statement to select a value. When I execute it from loadercli, I can get the results from the loadercli session to the console or I can re-direct it to a file with the -ow option but is there a way I can get the results of the query execution?

For example:

loadercli -n <server> -d maxdb1 -u user,pw -b command.dat

Results in

Loader protocol: 'C:\Documents and Settings\troyp\My Documents\sdb\loader\log\l

ader.log'

Loader packages: 'C:\Documents and Settings\troyp\My Documents\sdb\loader\packa

es'

User TROYP connected to database MAXDB1 schema TROYP on server.

SELECT CONCAT('SCHEMA_VERSION=', SCHEMAVERSION) AS SCHEMA_VERSION FROM TABLE LIMIT 1

Successfully executed

exit

Successfully executed

If I add -ow output.txt then this same content goes to output.txt.

Thanks,

Troy

[Former Member]

I just found the sqlcli utility and it looks like that will be a better solution.