Hi Folks,

Please clarify the following :

1) In DB2 8.1, I have heard of 'IN tablespace_name' , but Is there anything called 'IN DATABASE tablespace_name' ? If so in which version of DB2, this syntax exists ?

2) How to create a tablespace in prior to a create table statement ?

3) Is there any keyword 'AUDIT' in DB2 ? If so Please explain the same.

Eg :

create table test(sno int) IN DATABASE tablespace1 AUDIT NONE DATA CAPTURE NONE

Please explain the above if you have come across the syntax.

Thanks,
Sam

That is syntax on DB2 for OS/390 and z/OS. You can download the SQL Reference here:
http://www-306.ibm.com/software/data...s/library.html

Note that a database is a completely different object on mainframe DB2 compared to a database on other DB2 versions.