Using System Exec.vi for connecting a Panel on Linux

[LAVA 1.0 Content]

Hi there,

I am facing a problem.

I need to login to a Panel (running Linux on it) using plink.

I am using the "System Exec.vi" to open up a secure port using plink and getting the needed information, for example to list the "files" in one of the directory i would issue the command

plink 10.47.101.22

cd /opt/MAP/etc/db/

ls -al

exit

exit

And i am getting the response without any problems.(a new shell gets opened, and closes when the job is over)

Now the problem is there is a "database" in one of the folder and i would like to view/modify the same using "msql" commands. So I log in to the panel, go to the location where the database exists and issue the commands (this how i work manually)

But if i use LV and the System exec.vi to issue the command as shown below, A new "shell" opens (like u are opening a command prompt window) and it does not comes out. I have to manually go close this shell to gain the control back.

plink 10.47.101.22

cd /opt/MAP/etc/db/

msql -d Users.bdb -o guru.txt (to create text file called 'guru.txt)

select * from UserTable ;

.q

exit

exit

Now is there any solution to avoid this so that my vi can continue executing without any issues?

Is there any other tool or something is available to perform such operation?