IBM Mainframe Forum

[humble]

Hi, Is it possible to recreate the SQL used to define an existing table?
I need to do this because there is no documentation available on a table defined long ago.
Can I use any QMF options or other tools? please suggest.

I am starting by analyzing the Db2 catalogs.

[Akatsukami]

Start with the following query:

Select all

SELECT COLNO, NAME, COLTYPE, LENGTH, NULLS FROM SYSIBM.SYSCOLUMNS
WHERE TBNAME = 'table in question'
ORDER BY COLNO

[GuyC]

DataStudio