Re: WDSC as a complete work environment

Adam,

Are you talking about printing or emailing results from Quantum DB?  If
you are, then what I normally do on one-offs is to get the SQL right,
then right mouse click on the result set and export it to Excel and
email that.  It generally works pretty good for that but I wouldn't want
to use it for any kind of production use.  SQL is just not a printing
product.

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 AGlauser@xxxxxxxxxxxx
Sent: Wednesday, October 25, 2006 10:49 AM
To: Websphere Development Studio Client for iSeries
Subject: Re: [WDSCI-L] WDSC as a complete work environment

Hi Tim,

I find I'm using the green screen less and less.  I'll address some of
your points directly.

(some people call him .....) Tim wrote on 25/10/2006 11:19:35 AM:

[...] viewing and updating data via SQL and DBU,

I've found that using the Quantum DB plugin reduces my use of DBU and
SEQUEL quite a bit for this sort of thing.  I still use DBU once in a
while if I'm already on the green screen.  The only downside is that it
gets me hooked on some of the things SEQUEL doesn't do, like common
table expressions, but I haven't figured out how to print or email
results as easily as SEQUEL allows.

working with jobs

I still do this almost exclusively on green screen.

changing lib lists every 15 minutes depending on which company(we have

multiple on the same machine) I'm working with,

etc.

I don't have to do this as often, but the suggestions I've seen from the
WDSC team are to set up a connection for each 'task group', or in your
case, each company.  If you want to change your library list on the fly,
you can do that too.  This was one of the handiest things I picked up at
the WDSC roadshow - there is a Library List filter under iSeries
Objects, which works the same as ADDLIBLE/RMVLIBLE.


HTH,
Adam

P.S. - Hope you don't mind the Monty Python reference!  I'm sure you've
*never* heard that one before :)

########################################################################
#############
Attention:
The above message and/or attachment(s) is private and confidential and
is intended only for the people for which it is addressed. If you are
not named in the address fields, ignore the contents and delete all the
material. Thank you. Have a nice day.

For more information on email virus scanning, security and content
management, please contact administrator@xxxxxxxxxxxx
########################################################################
#############
--
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.