Re: Interactive SQL in WDSC 6.0

Got it working......guess it helps if you use the

AS/400 Toolbox for Java JDBC Driver 

And use jdbc:as400://<systemname> for the connection string.

I can see the tables, do queries and all that fun stuff.

Couple of questions?

1) does it allow you to "prompt" for field names someway
   Or does it assume that you pretty much know what your doing?

2) if I drag/drop fields from a table into the interactive session
   If it's an ambigious field (i.e. vendor) which is in table a and also
in
   Table b it just put's in vendor  (not a.vendor,b.vendor)
   Is that just the way it works or is there an option to have it put
the
   Table prefix in there by default so you don't get those nasty errors
   That says "vendor is an ambigious field"

TIA

-----------------------------------
Jim Norbut
Systems Administrator
Grubb & Ellis Company
500 West Monroe
Chicago, IL 60661
(312) 698-5620

-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
On Behalf Of Norbut, Jim
Sent: Thursday, January 11, 2007 4:32 PM
To: Websphere Development Studio Client for iSeries
Subject: Re: [WDSCI-L] Interactive SQL in WDSC 6.0

Okay....so I have the Quantum plug-in downloaded

And I thought I have the bookmark setup correctly
For DB2 but all my queries are coming back with 

I'm using jdbc:odbc:lawdbf8 for my connection string  

(lawdbf8 is an odbc setting I have setup using iSeries Access ODBC
Driver)

I can see my schema, see my tables, view the table details
But when I do a "view table"

It gives me an error saying "No Data Found"
SQL EXCEPTION 


-----------------------------------
Jim Norbut
Systems Administrator
Grubb & Ellis Company
500 West Monroe
Chicago, IL 60661
(312) 698-5620
-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
On Behalf Of Rick.Chevalier@xxxxxxxxxxxxxxx
Sent: Thursday, January 11, 2007 1:28 PM
To: wdsci-l@xxxxxxxxxxxx
Subject: Re: [WDSCI-L] Interactive SQL in WDSC 6.0


Jim,

The hands down favorite of this list appears to be a plug-in by Quantum.
Check the archives for more information about others experiences.
Personally, I use it almost exclusively now.

If you google quantum plug-in you should be able to find their site as
well.

HTH,

Rick

-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx
[mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Norbut, Jim
Sent: Thursday, January 11, 2007 1:18 PM
To: Websphere Development Studio Client for iSeries
Subject: [WDSCI-L] Interactive SQL in WDSC 6.0

Hi,

Just digging into WDSC and getting my feet wet So forgive me
if this is a "newbie" question.

Is there a way to do interactive sql (like in ops navigator)
via the WDSC ?

-----------------------------------
Jim Norbut
Systems Administrator
Grubb & Ellis Company
500 West Monroe
Chicago, IL 60661
(312) 698-5620

--
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.

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.