Forum

General discussion on using the Kognitio Analytical Platform.
Single Poster
Offline
User avatar
Posts: 1
Joined: Wed Oct 19, 2016 10:19 am

WXSUBMIT query output in shell variable.

by DEV1023 » Wed Oct 19, 2016 11:56 am

Hi , I want to get the output into shell variable of query triggered via WXSUBMIT command in shell into shell variable.

for example :- WXSUBMIT -s "select count(*) from emp;"; This is the command i have used in linux command line , how can i get count(*) value in shell variable.?
Reply with quote Top
Contributor
Offline
User avatar
Posts: 386
Joined: Thu May 23, 2013 4:48 pm

Re: WXSUBMIT query output in shell variable.

by markc » Wed Oct 19, 2016 3:43 pm

If you are trying to run SQL in conjunction with scripting, I'd recommend using wxbashtools rather than submit.

Do "man wxbashtools" from the Linux command line to see how to use wxbashtools, including some example code.
Reply with quote Top

Who is online

Users browsing this forum: No registered users and 1 guest

cron