在UDB DB2 v8中创建全局临时表 [英] Creating Global Temp Table in UDB DB2 v8
问题描述
我无法运行语句CREATE GLOBAL TEMPORARY TABLE。在
unix版本的DB2上,它给出了以下错误
db2 =>创建全局临时表temp(OGI_SYS_NR char(8))
DB21034E该命令被处理为SQL语句,因为它是
而不是
有效的命令行处理器命令。在SQL处理期间它返回了
:
SQL0104N一个意外的令牌创建全局临时表temp(
OGI_S是
在BEGIN-OF-STATEMENT之后找到。预期的代币可能包括:
"< values>" ;.SQLSTATE = 42601
我们可以创建创建全局临时表n unix版本的DB2。我想要创建声明的全局临时表。
任何指针都会有很大的帮助
谢谢,
Ranga
I was unable to run the statement "CREATE GLOBAL TEMPORARY TABLE" on
unix version of DB2, it gave the follwing error
db2 => create global temporary table temp ( OGI_SYS_NR char(8) )
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0104N An unexpected token "create global temporary table temp (
OGI_S" was
found following "BEGIN-OF-STATEMENT". Expected tokens may include:
"<values>". SQLSTATE=42601
Can we create "Create Global Temporary Table" n unix version of DB2. I
donot want to create "Declared Global Temporary Table".
Any pointers on this would be of great help
Thanks,
Ranga
推荐答案
试试DECLARE ...参见SQL参考手册。
Larry Edelstein
Ranga写道:
Try DECLARE ... see the SQL Reference Manual.
Larry Edelstein
Ranga wrote:
我无法在DB2的unix版本上运行语句CREATE GLOBAL TEMPORARY TABLE,它给出了以下错误
db2 =>创建全局临时表temp(OGI_SYS_NR char(8))
DB2103 4E该命令作为SQL语句处理,因为它不是
有效的命令行处理器命令。在SQL处理期间它返回:
SQL0104N在BEGIN-OF-STATEMENT之后发现了一个意外的令牌创建全局临时表temp(
OGI_S)。预期的令牌可能包括:
"< values>" SQLSTATE = 42601
我们可以创建创建全局临时表n unix版本的DB2。我不想要创建声明全球临时表。
任何关于此的指示都会有很大的帮助
谢谢,
Ranga
I was unable to run the statement "CREATE GLOBAL TEMPORARY TABLE" on
unix version of DB2, it gave the follwing error
db2 => create global temporary table temp ( OGI_SYS_NR char(8) )
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0104N An unexpected token "create global temporary table temp (
OGI_S" was
found following "BEGIN-OF-STATEMENT". Expected tokens may include:
"<values>". SQLSTATE=42601
Can we create "Create Global Temporary Table" n unix version of DB2. I
donot want to create "Declared Global Temporary Table".
Any pointers on this would be of great help
Thanks,
Ranga
Ranga,
无法做到。为什么你不能使用声明的全球温度?
干杯
Serge
-
Serge Rielau
DB2 SQL编译器开发
IBM多伦多实验室
Ranga,
No can do. Why can''t you use a declared global temp?
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
仅参考链接...
http://www.craigsmullins.com/zjdp_004 .htm
声明的临时表,V7的新增功能,补充了创建
全局临时表的功能(在DB2 V5中引入)。 br />
用于比较两者的快速文档链接
http://publib.boulder.ibm.com/cgi-bi...RCHINDEX=INDEX
PM
" ; Serge Rielau < SR ***** @ ca.eye-be-em.com>一个écritdansle message de
news:c2 ********** @ hanover.torolab.ibm.com ...
Reference links only...
http://www.craigsmullins.com/zjdp_004.htm
Declared temporary tables, new to V7, complement the capability to create
global temporary tables (introduced in DB2 V5).
Quick doc link to compare both
http://publib.boulder.ibm.com/cgi-bi...RCHINDEX=INDEX
PM
"Serge Rielau" <sr*****@ca.eye-be-em.com> a écrit dans le message de
news:c2**********@hanover.torolab.ibm.com...
Ranga,
没有办法。为什么你不能使用一个声明的全球临时状态?
欢呼
Serge
-
Serge Rielau
DB2 SQL编译器开发
IBM多伦多实验室
Ranga,
No can do. Why can''t you use a declared global temp?
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
这篇关于在UDB DB2 v8中创建全局临时表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!