session table

caroll · #1 (**permalink**) 07-03-11, 03:41

Hi pal,

I don't have any idea about the session table in DB2.I need to create a session table in DB2 so please can any one let me know the process.

Thanks in advance.....

n_i · #2 (**permalink**) 07-03-11, 10:27

I guess what you really mean is a declared global temporary table. Look it up in the manual.

caroll · #3 (**permalink**) 07-03-11, 13:13

please give me material or else link to download tutorial about temporary table as well as session table.

Marcus_A · #4 (**permalink**) 07-03-11, 13:28

You can get the documentation here.
https://www-304.ibm.com/support/docv...id=swg27009474

You can use the online InfoCenter, or download the PDF manuals. In the PDF manuals, you probably want to look at the SQL Reference Vol 2, CREATE TABLE statement.

caroll · #5 (**permalink**) 07-04-11, 01:30

thanks:-)i got the notes to study.

stolze · #6 (**permalink**) 07-06-11, 05:10

If you just want to store a single value, you can use session variables, too.

Internet Services

Web Development

Digital Marketing

Consumer Tech