Hi, I am using db2. I am wondering if it is possible to save a list of strings to one column of a table? I can create another table which stores a list of rows containg individual strings and a foreign key to its parent table.But I think its overkill to do so. It would be much simpler just to save a list of strings to one column. Is it possible? thanks
Use a nested table or an object column type or concatenate the strings with an abitrary delimiter. Then, use a StringTokenizer to get the individual strings when retrieved.
SCJP, SCWCD, SCBCD, IBM CSD WebSphere v5, <br />A+, MCP 2000 and 2000 server, CST, and few incompleted certification tracks.<br /> <br />Ivory Coast<br /> <br />Analyze your web Request/Response @ <a href="http://webtools.servehttp.com" target="_blank" rel="nofollow">http://webtools.servehttp.com</a> down for a while...
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com