How do I Create an Updateable Global Temp Table?

[jlockwo]

We have several updateable global temp tables in our system, but do not know how they were originally created. Does anyone know how to create these global temp tables? They are not Declared Temp tables, since they appear in our Sysibm.systables with a type of 'G'. This is quite urgent. Any help would be greatly appreciated!!!! We have DB2 V7.

 

[sathyarams]

Is this the one you are looking for

DECLARE GLOBAL TEMPORARY TABLE

Cheers
Sathyaram

More DB2 questions answered at

http://www.dbforums.com/f8

 

[jlockwo]

Well, since these tables appear in sysibm.systables, I am assuming that they are CREATED temporary tables, not DECLARED ones. Am I understanding this wrong? I thought declared temp tables don't exist outside of the program they are in and therefore do not appear in Sysibm.systables.

 

[sathyarams]

Not sure what G means .. Atleast I can't find a refernece in SYSCAT.TABLES

Sorry for not being of much help

Cheers
Sathyaram

More DB2 questions answered at

http://www.dbforums.com/f8

 

[staland]

I guess your global temp tables was created with a

CREATE GLOBAL TEMPORARY TABLE statement

You can read much more about created temporary tables in "DB2 SQL Reference"

Helle Stålander

 

[gregsimpson]

jlockwo,

this is a way of creating temporary tables upfront which your programmers don't have to declare each time they use them. They are simply there to be used by the application program like any other table, saving them having to be declared each time they are used.

The only difference between these and an ordinary table are only your UOW can see the data you insert to these tables and the entires you place on there effectively disappear at either commit or rollback.

I agree with Staland as to how they have been created.

Cheers
Greg