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




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.