Re: what is worklight and data studio

DS will not show you tables that are created without DDS or DDL - where you use CRTPF with record length - that makes it a bit unhelpful. I know, some might say those are not tables! Sobeit!

I had tried an older version - it didn't handle stored procedures well, as I recall - but that was a few years ago.

I have decided not to use it - nor to use Squirrel - the component in IBM i Navigator is still my choice.

YMMV!

Vern

On 11/19/2013 12:45 PM, Jim Oberholtzer wrote:

Dale,

I think you may be misconstruing what was said. The only portion of
data studio that does not apply to IBM i is the query tuning features,
the rest of the tool works very well. IBM i has superior ability to
tune DB/2 and the tooling reflects that.

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On 11/19/2013 12:33 PM, dale janus wrote:

Worklight Studio is for mobile application development. It is free and
shell shares with RDi and as you discovered is shipped with the product.
For deployment there is a server portion which unfortunately is not
supported on the IBM i yet.

hmm, needs a server portion that is not supported yet

IBM Data Studio is IBM's tools for SQL development and tuning. This used
to cost money as was called Optim Development Studio. It is now free and
is shipped with the product. It integrates with RDi and gives enhanced SQL
development and database administration. The query tuning portion does not
apply to the DB2 for i database. You can still use IBM i Navigator for
that.

hmm, does not apply to DB2 for i.

Well, I can at least see what data studio does for SQL development and
administration on DB2 for i.


Thanks for explaining.


---Dale
--