Forum

Discussions specific to version 8.1
Single Poster
Offline
User avatar
Posts: 1
Joined: Thu Jun 13, 2013 5:20 pm

v8 new feature for wxsubmit: execute multiple commands

by kesarwam » Wed Jan 22, 2014 8:32 pm

Command line utility wxsubmit in version 8 allows to run multiple commands using –x option (pls. see an example below)
wxsubmit -s localhost sys -x "select * from sys.ipe_ftable; select sysdate;"
Amit Kesarwani
Reply with quote Top
Contributor
Offline
Posts: 185
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Re: v8 new feature for wxsubmit: execute multiple commands

by MikeAtkinson » Thu Jan 23, 2014 1:34 pm

You can use KogScript to do this:

kogscript -s latest -u sys -p <password> -e "sqldebug=3;select * from sys.ipe_ftable; select sysdate;"

The sqldebug variable controls the amount of output, without it set the script does not output. However there is a small problem with KogScript which means that the results from the first query are merged with the results from the next query as they are all on one line (new results are normally created for new lines in the script), I've now corrected this bug.
Reply with quote Top

Who is online

Users browsing this forum: No registered users and 1 guest

cron