Re: Running SQL scripts

Buck,

Create a dynamic cursor:
exec sql
declare CURSOR1 cursor for cursor1select

and in your program create the dynamic cursor statement into
cursor1statement and then:
exec sql
prepare cursor1select from cursor1statement

jon

date: Thu, 30 Oct 2014 15:10:56 -0400
from: Buck Calabro <kc2hiz@xxxxxxxxx>
subject: Re: [WDSCI-L] Running SQL scripts

On 10/30/2014 2:56 PM, Jon Everton wrote:

Create a stored procedure using input parameters with the table and
schema name. Use the SQL function REPLACE to put your variables into
the SQL statement. Send me an email and I'll send you an example if
this rather poor explanation confuses you.

That's clear Jon, thanks. This thread is morphing into a discussion on
integrating Data Studio with RDi. Imagine you have an existing SQLRPGLE
program with a DECLARE CURSOR as below. You'd like to make some changes to
that SQL statement, what does one do?

Rectangle select, copy, tab to Data Studio, paste. Replace the host
variables with literals, test. Edit, test, repeat. When happy with the new
SQL statement, copy in Data Studio, tab to RDi, select, paste.
Adjust formatting. Save, compile, test. Forgot to replace literals, wonder
why program doesn't work. Replace literals with host variables.
Save, compile, test.

It's better than a sharp stick in the eye, but that's a low bar :-)