Db2 Sql

[PatelRam]

I am new to db2. I have couple of questions about db2 sql:

1) How to select first 100 records from the Query set.

For eg. Oracle : select * from table_name where rownum < 100
Db2 : ???


2) In Oracle We have spool command to create output txt file for query result

for eg. Oracle : spool c:\filename.txt
select * from table_name
spool off
Db2 : ???


3) How do I know List of tables in Schema

For eg. Oracle : select * from cat;
db2 : ???

Thanks,

 

[sathyarams]

1) select * from table_name fetch first 100 rows only
2) No equivalent
3) list tables for schema

Cheers
Sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8