DB2 临时表：不存储或不检索信息

发布于 2024-07-21 08:11:00 字数 489 浏览 7 评论 0原文

我是一个 MSSQL 人员，但我正在处理一个 DB2 查询，该查询需要创建一个临时表，插入其中，并用它做一些事情。作为一个大大缩短的测试，我使用以下查询，它提供相同的结果。

declare global temporary table tt_testingSyntax (id int);
insert into session.tt_testingSyntax (id) values (1);
insert into session.tt_testingSyntax (id) values (2);
insert into session.tt_testingSyntax (id) values (3);
insert into session.tt_testingSyntax (id) values (4);
select * from session.tt_testingSyntax;

返回零行。为什么会这样呢？我已经创建了表空间并验证了该表在整个查询的范围内。

原文

I'm an MSSQL guy, but I'm working on a DB2 query that needs to create a temp table, insert into it, and do stuff with it. As a much-shortened test, I'm using the following query, which is providing the same result..

declare global temporary table tt_testingSyntax (id int);
insert into session.tt_testingSyntax (id) values (1);
insert into session.tt_testingSyntax (id) values (2);
insert into session.tt_testingSyntax (id) values (3);
insert into session.tt_testingSyntax (id) values (4);
select * from session.tt_testingSyntax;

Zero rows are returned. Why would that be? I've created the tablespace and verified the table is in scope throughout the query.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

笑忘罢 2024-07-28 08:11:00

尝试：

declare global temporary table tt_testingSyntax (id int) 
ON COMMIT PRESERVE ROWS NOT LOGGED;

insert into session.tt_testingSyntax (id) values (1);
insert into session.tt_testingSyntax (id) values (2);
insert into session.tt_testingSyntax (id) values (3);
insert into session.tt_testingSyntax (id) values (4);
select * from session.tt_testingSyntax;

有两个选项...ON COMMIT DELETE ROWS（默认）或ON COMMIT PRESERVE ROWS。

Try:

declare global temporary table tt_testingSyntax (id int) 
ON COMMIT PRESERVE ROWS NOT LOGGED;

insert into session.tt_testingSyntax (id) values (1);
insert into session.tt_testingSyntax (id) values (2);
insert into session.tt_testingSyntax (id) values (3);
insert into session.tt_testingSyntax (id) values (4);
select * from session.tt_testingSyntax;

There are two options...ON COMMIT DELETE ROWS (the default) or ON COMMIT PRESERVE ROWS.

回复收藏 0 原文