Create a stored procedure using input parameters with the table andschema
name. Use the SQL function REPLACE to put your variables into the SQLpoor
statement. Send me an email and I'll send you an example if this rather
explanation confuses you.
date: Thu, 30 Oct 2014 14:30:16 -0400i).
from: Buck Calabro <kc2hiz@xxxxxxxxx>
subject: Re: [WDSCI-L] 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 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!
select SYSTEM_COLUMN_NAME, DATA_TYPE, "LENGTH", NUMERIC_SCALE,
COLUMN_TEXT, IS_NULLABLE, "CCSID", SYSTEM_TABLE_NAME,
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
then execute this code as-is. Once my SQL is working properly, I couldthen
cut / paste it back into my HLL as-is without having to remove literalsand
replace them with host variables.option
Similar to the ability SDA has to populate fields for testing (STRSDA
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.