The DB Format is for viewing / editing DB2-UDB delimited table exports files. A file can be created with the following SQL:
1:EXPORT TO "C:\Bruce\RecordEditor\Db2Fields.txt" OF DEL MESSAGES "C:\export.txt" 2:SELECT 'DB_DVMT_' || c.TABSCHEMA, c.TABNAME, c.COLNAME, c.COLNO, c.TYPENAME, c.LENGTH, c.SCALE 3: FROM SYSCAT.COLUMNS AS c 4: where c.TABSCHEMA = 'ETB' 5: ORDER BY c.TABSCHEMA ASC, c.TABNAME ASC, c.COLNO ASC 6:
Or alternatively the following SQL will generate SQL to create a copybook files for each table.
1:SELECT 'EXPORT TO "C:\Data\RecordEditor\CsvCopybooks\' || TabName || '.Csv" OF DEL MESSAGES "C:\export.txt" ' 2: || 'SELECT ''DB_DVMT_'' || c.TABSCHEMA, c.TABNAME, c.COLNAME, c.COLNO, c.TYPENAME, c.LENGTH, c.SCALE ' 3: || ' FROM SYSCAT.COLUMNS AS c ' 4: || ' where c.TABSCHEMA = ''' || TABSCHEMA || ''' and c.TABNAME = ''' || TabName || ''' ' 5: || ' ORDER BY c.TABNAME ASC, c.COLNO ASC; ' 6:FROM SYSCAT.TABLES where TABSCHEMA = 'ETB';; 7: 8: