DB2中等效的VARRAY [英] Equivalent of VARRAYs in DB2
问题描述
大家好,
我有一个应用程序,我们使用oracle 8i作为数据库,我们有使用VARRAY的
编写的程序。现在,需要在DB2 UDB上迁移它。任何人都可以告诉我在DB2中是否有替代VARRAYs的等价物或
?
提前致谢,
Praveen
Hi All,
I have an application for that we used oracle 8i as the db and we have
written procedures using VARRAYs. Now, the requirement came to migrate
it on DB2 UDB. Can anyone pls tell me is there any equivalent or
alternative to VARRAYs in DB2?
Thanks in advance,
Praveen
推荐答案
" Praveen" < SP ********** @ yahoo.com>在消息中写道
news:98 ************************** @ posting.google.c om ...
"Praveen" <sp**********@yahoo.com> wrote in message
news:98**************************@posting.google.c om...
大家好,
我有一个应用程序,我们使用oracle 8i作为数据库,我们有使用VARRAY编写的程序。现在,需要在DB2 UDB上迁移它。任何人都可以告诉我在DB2中是否有替代VARRAY的替代品?
提前致谢,
Praveen
Hi All,
I have an application for that we used oracle 8i as the db and we have
written procedures using VARRAYs. Now, the requirement came to migrate
it on DB2 UDB. Can anyone pls tell me is there any equivalent or
alternative to VARRAYs in DB2?
Thanks in advance,
Praveen
你能告诉我们VARRAY的作用吗?
Can you tell us what VARRAY does?
你可以使用NOT LOGGED ON COMMIT RETAIN的全局临时表
ROWS选项。如果阵列不是太大,你最终将在缓冲池中固定一页
。所以它将是I / O免费的。
如果你正在进行智能迁移,这表现得非常好(聪明的我
意味着你迁移功能和不是逐行(仿真))。
理想情况下,您希望将数组上的循环转换为选择和搜索
更新。
干杯
Serge
-
Serge Rielau
DB2 SQL编译器开发
IBM多伦多实验室
You can use global temporary tables with NOT LOGGED ON COMMIT RETAIN
ROWS option. If the array is not too big you will end up with one page
pinned in the bufferpool. So it''s going to be I/O free.
If you are doing a smart migration this performs very well (with smart I
mean you migrate the function and not line by line (emulation)).
Ideally you want to turn loops over the array into selects and seached
updates.
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Mark A写道:
" Praveen" < SP ********** @ yahoo.com>在消息中写道
新闻:98 ************************** @ posting.google.c om ...
"Praveen" <sp**********@yahoo.com> wrote in message
news:98**************************@posting.google.c om...
大家好,
我有一个应用程序,我们使用oracle 8i作为数据库,我们有使用VARRAY编写的程序。现在,需要在DB2 UDB上迁移它。任何人都可以告诉我,DB2中的VARRAY是否有任何替代或替代?
提前致谢,
Praveen
Hi All,
I have an application for that we used oracle 8i as the db and we have
written procedures using VARRAYs. Now, the requirement came to migrate
it on DB2 UDB. Can anyone pls tell me is there any equivalent or
alternative to VARRAYs in DB2?
Thanks in advance,
Praveen
可以你告诉我们VARRAY的作用吗?
Can you tell us what VARRAY does?
用户定义的数据类型对应一个可变长度数组。
http://www.psoug.org/reference/varray.html
-
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(将''x''替换为''u''来回复)
A user defined data type corresponding to a variable length array.
http://www.psoug.org/reference/varray.html
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace ''x'' with a ''u'' to reply)
这篇关于DB2中等效的VARRAY的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!