db2 Export Table SQL - No Data

I am wondering if someone knows how to expo开发者_Go百科rt only the table SQL from a db2 database. I want a file that has the SQL to recreate the table without the data in another database environment.

I need this a query. I know db2look has the capability but, I need a query I can run in the database to do this.

Because you don't have privileges to run db2look? You're going to need SELECT privileges on the system catalog tables anyway. And depending on what you try to do, you might also need sysadm, sysctrl, sysmaint, or dbadm.

Metadata is in the SYSIBM schema. The answers here should point you in the right direction.