Re: DB2 equivalent for Oracle Collection types

Re: DB2 equivalent for Oracle Collection types

 

  

There is no direct equivalent.
Typically DECLAREd GLOBAL TEMPORARY TABLEs are use to shuttle arrays back
and forth.
An alternative is to use comma separated strings which then need to be
parsed.

Cheers
Serge



"sridhar " <db2udbdba-ezmlmshield-x10137822.[Email address protected] wrote
on 09/28/2005 02:05:06 AM:

> Hi all,
>
> Is there an equivalent for Oracle's collection types like RECORD, VARRAY
> in DB2.
>
> Thanks for your help in advance.
>
> Cheers,
> Sri
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>


DB2 & UDB email list listserv db2-l LazyDBA home page