拆分每条记录的字段内容并存储在另一个表中 [英] split a contents of a field of each record and store in another table

问题描述

海大家......！

我这里有问题。希望我可以通过答案得到帮助..


我有一张桌子A

ID DATA

1 aa; bb

2 aa; bb; cc

3 aa; cc

4 bb; cc


我希望得到一张桌子B好像


ID ABC

1 aa bb null

2 aa bb cc

3 aa null cc

4 null bb cc


我想通过使用DB2 UDF获得表B的结果，

希望获得create function&的详细信息。如何调用它..

我是DB2的新手......等待帮助..！


提前谢谢...

解决方案

你必须编写自己的字符串拆分功能。幸运的是，有人已经这样做并在此解释了这个过程： http://www.ibm.com/developerworks/da...03stolze1.html

感谢您的回复..

我之前尝试过那个..它抛出[错误] - & ;; WHERE序数。 SQLCODE = -7，SQLSTATE = 42601，DRIVER = 3.53.71


我正在使用DB2 Aqua Data Studio 8.0.8


所以等待进一步说明..

这将是非常有用的..

再次提前感谢..

你做了什么代码你去那个错误时执行？

Hai everybody...!
I have a problem here .. Hope I can get help by answers..

I have a table A
ID DATA
1 aa;bb
2 aa;bb;cc
3 aa;cc
4 bb;cc

I wish to get a table B like

ID A B C
1 aa bb null
2 aa bb cc
3 aa null cc
4 null bb cc

I would like get table B a result by using DB2 UDF,,
wish have details of create function & how to call it ..
I am new to DB2.. waiting for Help..!

Thanks in advance...

解决方案

You''d have to write your own string split function. Luckily someone has already done that and explained the process here:http://www.ibm.com/developerworks/da...03stolze1.html

Thanks for your response..
I have tried that one earlier.. it throws [Error] - &;WHERE ordinal. SQLCODE=-7, SQLSTATE=42601, DRIVER=3.53.71

I am using DB2 Aqua Data Studio 8.0.8

so waiting for further clarification..
It would be very helpful ..
Thanks once again in advance..

What code did you execute when you go that error?

这篇关于拆分每条记录的字段内容并存储在另一个表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！