Fetching current date in IBM's DB2 database

The command to do it is -

select current date from sysibm.sysdummy1

Looking at all table names in IBM DB2

You can look at the name of all tables in your database through the tables table in the syscat schema. Its structure can be seen using -

describe table syscat.tables