Topic
No replies
rggnanaraj
rggnanaraj
2 Posts
ACCEPTED ANSWER

Pinned topic Handling Informix SET data type in DB2 SQL PL

‏2013-02-13T08:59:34Z |
In Informix we have SET data type. This is an unordered collection type that stores unique elements. The number of elements in a SET data type can vary, but no nulls are allowed.

An example or a table & row contents are given below:

>>>> Table DDL

CREATE TABLE employee
(
name char(30),
address char(40),
children SET (varchar(30) NOT NULL)
);
>>>> Table data contents

Muriel|5555 SW Merry
Sailing Dr.|02/06/1926|SET{'Karen','Lauren','Andrea'}|
Larry|1234 Indian Lane|07/31/1927|SET{'Martha',
'Melissa','Craig','Larry'}|

We see above that data is delimited by | and the first row has set with 3 elements (Karen, Lauren, and Andrea), the second with 4 elements (Martha, Melissa, Craig and Larry).

Now, how do we handle this Informix SET data type in DB2 LUW?

Thanks in advance.