Global temporary table error

[bmcc]

I get the following error message when I create a funtion to test Global temporary table. DB2 version is 5.x
Many thanks for your help.

SQL0199 - Keyword TABLE not expected. Valid tokens: NOT DEFAULT.

Here is my program:

CREATE function testtemptable()
returns integer
LANGUAGE SQL
BEGIN
DECLARE GLOBAL TEMPORARY TABLE session.x (
a integer not null,
b char(20) not null );
insert into session.x values (14,'test');
return 5;
End;

 

[sathyarams]

Have you checked your version 5 manuals to check if GTT was supported in that version ...

Also, it was only in version 8 that sql udfs could modify data ... So, I guess, you are out of luck ..

Sorry

cheers
Sathyaram



For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp