Don,
I have never used the Data Perspective so I don't know the benefits but
Quantum DB allows me to create a connection for each database that I
need to access, i.e. System i DB2, Oracle 9i (or is it 10i now), and MS
SQL. It will also allow me to drill down into the schema to discover a
table's columns, unfortunately this was broke at V5R3 on DB2 for me. It
can also export a result set so that I have a quick and dirty way to
provide an excel spreadsheet to someone without having to go through a
lot of hoops. I can execute basically any SQL I need to do, i.e. Select,
update, delete, etc.
It comes with basic but good help and is fairly easy to setup if you are
familiar with creating ODBC connections, and if not there are a number
of people on this message board that can help.
Douglas Belcher
KV Pharmaceutical
St Louis, MO
Opinions expressed are not necessarily those of my employer
-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [
mailto:wdsci-l-bounces@xxxxxxxxxxxx]
On Behalf Of dnitke
Sent: Friday, June 08, 2007 9:13 AM
To: wdsci-l@xxxxxxxxxxxx
Subject: [WDSCI-L] Data Perspective vs Quantum DB
Hey All,
I have just started delving into using the data perpsective of WDSCi 6.0
and had a couple of questions.
1. When running stored procedures how can I find out what QZDASOINIT job
its using. If I want to debug the RPGIV stored procedure its calling I
would need this normally.
2. What advantages are there in loading Quantum DB plugin over the
existing Data Perspective.
Thanks for any pointers
Don Nitke
Sr. Programmer/Analyst
Friedman Corp.
--
This is the Websphere Development Studio Client for iSeries (WDSCI-L)
mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
midrange.com
