In one tableset i have 200 tables .can i join all the 200 tables or can join all the tables inside the tableset

how can i find the unique variable to join

Can you give an example of what you are trying to achieve?
Are you asking suggestions for denormalizing data or are you asking about SQL ?


Also, give more details about DB2 you are using - version, fixpak, operating system etc.

If you are referring to NATURAL JOIN: no, DB2 does not support "automatic" selection of join columns. The concept of natural join is generally considered "dangerous" and "better not used".
Back to DB2: you will have to spell out all 200 table names, and also all (at least) 199 join conditions.

Apart from that, joins of up to 225 tables are possible (at least, with DB2 on z/OS from version 8 on).

let me brief out requirement . I am developing one tool in rexx . for that i am displaying all the tables from the tablespace to the user so that user selects few tables .so i need to join the selected tables (i.e join query have to executed ).i need to know the variable which will be used to join .In db2 .all the tables inside a tablespace will have relations between them right .how to retreive that

You can retrieve relationship between tables using SYSIBM.SQLFOREIGNKEYS procedure or by using the catalog tables (owner SYSIBM)

But, your assumption that the tables will have a relationship between them is not correct. There may be tables that do not have any relationship between them. Even, if a relationship actually exists (ie, business rule), they may not be defined in the database.