RE: Benefits of Quantum DB

Ewout,

For me the best thing is being able to view the results of multiple query 
results in the table view tab.  Close to that is being able to drill down to 
the fields in a table in the bookmark view.  These two things mean that I'm not 
switching between green screens, using the attn key or some other trick to 
compare date of determine the field name in a file.  I could prompt the 
statement but sometime that was more trouble than it was worth.

Another nice feature is being able to export the result set to an Excel 
spreadsheet.  Sure beats CVS files and copying to the IFS.

Recently used statements folder lets me look at past queries if I need one 
again.

Because Quantum isn't an iSeries tool I doubt it will understand *SYS naming.  
I changed my STRSQL settings to use SQL naming so they are consistent.

Mostly I use it as a query tool and not to interrogate the database so I can't 
speak to triggers and things like that.  We don't use them much so it isn't an 
issue.

About all I use STRSQL for these days is to verify complex SQL statements 
before placing them into Quantum.

Just my $.02.

Rick

-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx
[mailto:wdsci-l-bounces@xxxxxxxxxxxx]On Behalf Of Ewout N Boter
Sent: Tuesday, October 11, 2005 8:18 AM
To: wdsci-l@xxxxxxxxxxxx
Subject: [WDSCI-L] Benefits of Quantum DB


I have just installed the Quantum DB plugin, triggered by the recent posts
on this mailing list. It sure looks nice. At the moment, I am still
exploring the features of the plugin. I have not yet found a way to
display the triggers that are defined for a file. Constraints can be
displayed by using Properties - References, but I have not seen an option
that will show the triggers. Does anyone know how to do this?

Another question: is there a way to use the *SYS naming convention, i.e.
specifying lib/file instead of lib.file? I am used to using the *SYS
naming convention.

And still another question: if I have entered an SQL statement in the
Quantum SQL Query Editor, I would like to use the keyboard to start the
execution of the statement (instead of moving the mouse pointer to the
arrow in the upper right corner of the view). Is there some kind of
shortkey?

In general: what do you think are the benefits of using Quantum DB instead
of the green screen? In other words: what do you consider to be 'the
unique selling point' of Quantum DB?

Ewout

Privileged and Confidential.  This e-mail, and any attachments there to, is 
intended only for use by the addressee(s) named herein and may contain 
privileged or confidential information.  If you have received this e-mail in 
error, please notify me immediately by a return e-mail and delete this e-mail.  
You are hereby notified that any dissemination, distribution or copying of this 
e-mail and/or any attachments thereto, is strictly prohibited.