× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



The one drawback of this tool is that it doesn't enhance your experience
with update/delete/add.  It would be nice if it worked similar to WRKDBF or
DBU (if you have used those).

Does anybody know if there are tools like that available for WDSc 5.0?

Aaron Bartell

-----Original Message-----
From: MWalter@xxxxxxxxxxxxxxx [mailto:MWalter@xxxxxxxxxxxxxxx]
Sent: Wednesday, May 28, 2003 9:09 AM
To: Websphere Development Studio Client for iSeries
Subject: RE: [WDSCI-L] SQL plugins for Eclipse



You know, if STRSQL did line wrapping like QCMD does, I'd have never looked
for another way to do scratchpad queries.

Thanks,

Mark

Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com


 

                    "Bartell, Aaron L.

                    (TC)"                     To:     "'Websphere
Development Studio Client for iSeries'" <wdsci-l@xxxxxxxxxxxx>

                    <ALBartell@xxxxxxx        cc:

                    orp.com>                  Subject:     RE: [WDSCI-L] SQL
plugins for Eclipse                                                   
                    Sent by:

                    wdsci-l-bounces@xx

                    drange.com

 

 

                    05/28/2003 09:51

                    AM

                    Please respond to

                    Websphere

                    Development Studio

                    Client for iSeries

 

 





Holy smokes!  That was easy to setup (with your instructions below)!  It is
as simple to do SQL's in here as it is from the green screen!  And it is
fast!

That is one less thing that I need to go back to the green screen for. . .

Good post Mark,
Aaron Bartell

-----Original Message-----
From: MWalter@xxxxxxxxxxxxxxx [mailto:MWalter@xxxxxxxxxxxxxxx]
Sent: Wednesday, May 28, 2003 8:28 AM
To: Websphere Development Studio Client for iSeries
Subject: Re: [WDSCI-L] SQL plugins for Eclipse



I use the Quantum SQL Plugin. It really rocks. I'm not familiar with the
ones you mention but here is some of the connection information I needed to
provide.

The connect string is - jdbc:as400://192.168.0.2; translate binary=true
(converts CCSID 65535)
The driver is - com.ibm.as400.access.AS400JDBCDriver
The path to the driver file for me is - c:\program files\ibm\client
access\jt400\lib\jt400.jar

Hope this helps.

Thanks,

Mark

Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com




                    "Peter Colpaert"

                    <Peter.Colpaert@xxx        To:     WDSCI-L@xxxxxxxxxxxx

                    da-eu.com>                 cc:

                    Sent by:                   Subject:     [WDSCI-L] SQL
plugins for Eclipse
                    wdsci-l-bounces@xxx

                    range.com





                    05/28/2003 09:18 AM

                    Please respond to

                    Websphere

                    Development Studio

                    Client for iSeries











Hi group,

I installed the newest and bestest version of WDSCI earlier this week (no
problem whatsoever during install or updates! Win2K on P4 2.5 GHz with
512MB ram) and I think it is ok, but definitely slower than CODE/400.

However, I noticed that there exist some plugins for SQL access to the
iSeries data, namely EasySQL and PHPEclipse SQL.

As this could be very interesting for us, I tried them, and they installed
ok, but now I am totally not able to connect to the iSeries.

Which driver and driver JAR file do I have to specify? ?The plugins have no
help related to this, and ?I could not find anything on the WWW.

Any help would be highly appreciated.

TIA,

Peter Colpaert
Application Developer
iSeries Team Leader
Honda Europe NV
Langerbruggestraat 104
B-9000 GENT
Belgium
Peter.Colpaert@xxxxxxxxxxxx
Tel: +32 9 2501 334
Fax: +32 9 2501 231
----------
Yoda of Borg are we: Futile is resistance. Assimilate you, we will.
----------



______________________________________________________________________
The information contained in this communication is confidential and may be
legally privileged. It is intended solely for the use of the individual or
the entity to whom it is addressed and others authorised to receive it. If
you have received it by mistake, please let the sender know by e-mail reply
and delete it from your system.
If you are not the intended recipient you are hereby notified that any
disclosure, copying, distribution or taking any action in reliance of the
contents of this information is strictly prohibited and may be unlawful.
Honda Europe NV is neither liable for the proper and complete transmission
of the information contained in this communication nor for any delay in its
receipt.



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





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

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





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


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.