Re: Operation Navigator V5R1

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

I think you just put it 'inline' in the select statement or whatever.

I don't think cursor means to me what it does to you. On AS/400 it's a
part of the DBMS. Do you mean a loop control variable of some kind?

I'm only going from the manual here. But I've seen various examples of
proedure-like code in select statements. But there's no concept of an
anonymous one that's in effect for awhile, only embedded in a statement,
like

select begin .... end from file

or some such. Right now I know we can use

select case ... endcase from file

HTH

Billy Rowe wrote:
>
> Besides being able to run an SQL statement(s) in the window, I would like to
> be
> able to create a block(i.e. begin,end) with cursor for loop,etc. but
> not have to create a procedure and then call it.
>
> |You can put any of the procedure/function stuff inline in an SQL
> |statement, I think. Is that what you mean, or is an anonymous block
> |reusable outside of the context where you put it first?
>
> |>
> |> I have upgraded to V5R1 of Client Express.
> |>
> |> 2. How do you create an anonymous block, like you can do
> |>    on Oracle with SQL Plus, SQL Navigator, etc. without
> |>    having to create or replace a procedure?
> |>
> |>     ex:     Begin
> |>
> |>             .......
> |>
> |>             End
> |>
> |> TIA
> |>
> |
> |
> |--
>
--
Vern Hamberg

Would you like to see a challenging little arithmetic puzzle
that might get you or your kids or grandkids more interested
in math? Go to <http://cgi.wff-n-proof.com/MSQ-Ind/I-1E.htm>

Sillygism--

Something is better than nothing.
Nothing is better than a ham sandwich.
Ergo
Something is better than a ham sandwich.