Re: SQL object development in WDSc

wdsci-l-bounces@xxxxxxxxxxxx wrote on 08/11/2004 01:20:35 PM:

> I enjoyed the overview on Eclipse and WDSc...
> 
> It prompted me do load up and try a few things.  We recently went to 
v5r3, so I
> loaded the new client on my PC and went to work.
> 
> My problem is that I am looking for a function within the framework 
similar to
> the "Run SQL Script" function within iSeries Navigator.  I'm sure it's 
there,
> but I can't find it! 
> 
> I have SQL source (table definitions, indexes, triggers, stored 
procedures,
> etc.) on a file share on the IFS.  I'd like to edit those files within 
Eclipse
> (er... WDSc) and compile them.  Just like I do with under Navigator. 
> 
> Can someone clue me in...

If you store them in source files, you could define RUNSQLSTM as the 
compile command, and then you could do it.  I do not think there is an 
OS/400 command that will run a script from an IFS file.

The database support in WDSC is not very good.  There are some decent free 
plugins for Eclipse that work well with the iSeries database though.

I have used JfaceDBC, and others recommend Quantum/SQL.

Mark


_____________________________________________________________________________
Scanned for SoftLanding Systems, Inc. by IBM Email Security Management Services 
powered by MessageLabs. 
_____________________________________________________________________________