SqlDbx Forum

Carl_Heller

Member

Running scripts concurrently

Is it a limitation in the personal edition that I cannot run multiple scripts concurrently?

Thank you,

Carl.

sqldbxhelp

Administrator

Re: Running scripts concurrently

If you mean to run concurrently scripts from different tabs then it's not possible,
because they use same connection.
You can run scripts concurrently when multiple connections opened

gworona

Member

Re: Running scripts concurrently

When I try to open a concurrent connection using file, new Connection, it blows away my sqldbx window that I was running  (and the 10 scripts that I was  working on   ) and replaces it with a brand new window.  All I want to do is run a second script.  What steps do you do to do that?

sqldbxhelp

Administrator

Re: Running scripts concurrently

Personal Edition does not allow multiple connections. I do not understand what you mean by "blows away window".
You should see message box with message "You can have only one Active Connection in Personal Edition" and that's it.

gworona

Member

Re: Running scripts concurrently

I am running professional edition (paid for it).

"Blow away" scenario:

1. sqldbx is up and running
2. execute a script that takes a long time to run
3. while first script is running, click file, new connection
4. sqldbx server login dialog box appears with my remembered server settings, click ok
4. sqldbx program window (the one that had the script running in it) is replaced with a new sqldbx program window with a single blank script tab.  The query that was running is no longer running and is not in a script tab.   Its as if I closed the sqldbx application and clicked on my sqldbx desktop icon to start sqldbx anew.

I wouldn't think its supposed to work that way.  Am I doing something wrong to get a second connection running so that I can run a second query/script?

sqldbxhelp

Administrator

Re: Running scripts concurrently

It can not be replaced. It opens new one.
What about combo box on a main toolbar?
It should show two connections to the same database.
Are you sure that other window is not behind the new one?

gworona

Member

Re: Running scripts concurrently

>>It can not be replaced.
That is not my experience.

>> It opens new one.
I wish that were true in my case.

>>What about combo box on a main toolbar?
What does that look like?  I see no icon with the label "combo box"

>>Are you sure that other window is not behind the new one?
Quite.  Task Manager shows only one sqldbx application running.  This is a screenshot of sqldbx with taskmanager sitting on top of it right after I clicked file, new connection, ok (to server login info).   https://dl.dropboxusercontent.com/u/420 … hot016.jpg

sqldbxhelp

Administrator

Re: Running scripts concurrently

You have connection window maximized inside main SqlDbx window.
That is why when you open new connection it looks like the window replaced.
It is not. It is behind.
Connection combo box shows connection to "ibmposdb32, ibmpsdb, gworona".
If you click on arrow you will see that you have multiple connections.
Why you use ODBC connection to IBM DB2?
ODBC is very limited compare to native connection

gworona

Member

Re: Running scripts concurrently

Thank you!  I didn't know the connections were managed like that. 

I don't know why I am using ODBC to connect to my Informix database.  I will ask the database manager.

What are the advantages of using a native connection?