RE: Create a missing table in SQL ?

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Phil, it appears that compound statements like this are only possible 
inside an SQL procedure, which, as you probably know, is callable via JDBC. 
I was thinking you could do this and debug for testing - iSeries is 
supposed to have stuff to handle that now.

Oh, well, eh?

Vern

At 02:32 PM 10/7/2003 -0500, you wrote:
> 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?