Re: Running SQL scripts

On 10/30/2014 2:10 PM, Edmund Reinhardt wrote:

There is a small subset of IBM Data Studio which is shipped with RDi. Now
that IBM Data Studio itself is free, you can get the full features of the
product. The SQL running/editing/diagramming is relevant to IBM i. The
query tuning is not since it is geared to LUW DBW (not IBM i).

I am thinking about developing better integration with RDi eventually, so I
am following this thread with interest.

So if there was an easy way to get embedded SQL into an SQL script editor
in IBM Data Studio would this help write, test queries?

Mad utopian dreamer alert!

Given:
select SYSTEM_COLUMN_NAME, DATA_TYPE, "LENGTH", NUMERIC_SCALE,
COLUMN_TEXT, IS_NULLABLE, "CCSID", SYSTEM_TABLE_NAME,
SYSTEM_TABLE_SCHEMA, COLNO
from SYSCOLUMNS
where SYSTEM_TABLE_NAME = :REF_FILE and
SYSTEM_TABLE_SCHEMA = :REF_LIBR;

I would love to have the test/debug tool/IDE be able to 'declare'
variables :REF_FILE and :REF_LIBR as well as populate them with values
and then execute this code as-is. Once my SQL is working properly, I
could then cut / paste it back into my HLL as-is without having to
remove literals and replace them with host variables.

Similar to the ability SDA has to populate fields for testing (STRSDA
option 3).