RE: Create a missing table in SQL ?

["Hall, Philip" <phall@xxxxxxxx>]

Thanks Vern.

I'd love to do it that way, but I need the SQL out of the database, not in a 
procedure. If I can't find this out (in other online fora) then I'll have to 
bit the bullet and have real differences for different DB's. Trust DB2 to be 
the black sheep again eh ?

--phil

> -----Original Message-----
> From: Vern Hamberg [mailto:vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx]
> Sent: Tuesday, October 07, 2003 2:12 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: Create a missing table in SQL ?
> 
> 
> Phil, maybe try to create a function or procedure of this 
> code, then call 
> it? Interactive SQL is pretty primitive and not current with 
> everything 
> that can be done.  :-(  They just put full F9 (retrieval) 
> capability into 
> it, after, what, 15, 20 years?
> 
> Vern
> 
> At 01:37 PM 10/7/2003 -0500, you wrote:
> >Thanks Bill.
> >
> >The problem I'm really having is that I can't seem to get 
> the interactive 
> >SQL tool to accept any SQL that uses DECLARE xxx
> >
> >In SQLServer & Oracle, I can type SQL as below into their respective 
> >interactive SQL tools (to test) and it gets executed.
> 
> 
> -snip-
> 
> 
> _______________________________________________
> 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.
> 
>