RE: Compound SQL in iNav Run SQL Scripts

A compound statement starts with BEGIN and ends with END.
The SQL Source code can consist of different statements, including
declaration, continue and error handling and additional statements of the
SQL programming language.
This source code is embedded between BEGIN and END.

A dynamic compound statement is not a part of a stored procedure or user
defined function.

It exists only in your script.
When executing a dynamic compound statement, it is compiled into a stored
procdure in the qtemp. If the procedure is successfully generated and
deleted after the execution.

That's why dynamic compound statement cannot be debugged.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Brian
Johnson
Sent: Freitag, 9. Februar 2018 16:46
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Compound SQL in iNav Run SQL Scripts

What is a "compound SQL statement"?

On Thu, Feb 8, 2018 at 7:40 PM, <dlclark@xxxxxxxxxxxxxxxx> wrote:

OK, so we can develop compound SQL statements in iNav Run SQL
Scripts. But, can we debug them there?

--
Brian Johnson
brian.johnson.mn@xxxxxxxxx
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD