Re: SQL Scripts iNav DANGER DANGER

[Luis Rodriguez <luisro58@xxxxxxxxx>]

David,

Please be aware that there are several options when you execute a script. As
per V5R4:

CTRL+Y - Only selected (current) statement.
CTRL+T -  From selected (current) statement and then, subsequent staments.
CTRL+R - All statements.

So, even if you have several statements in your script, CTRL+Y would execute
only the current one (where the cursor is).

HTH,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Mon, Jan 31, 2011 at 8:53 AM, David FOXWELL <David.FOXWELL@xxxxxxxxx>wrote:

> A warning to all who have not yet had this :
>
> Place your cursor in the sql script you want to execute.
> Select execute the selection. After execution, if there is another script,
> it is automatically selected, so you have to be careful. Is there a way of
> illiminating this behaviour?
>
> But worse, ctrl z undoes the last change in the script as you would
> expect... ctrl y does not redo as you might expect.. It executes the
> selection!!!!!
>
>
> --
> 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: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.