DB CSV Copybook format

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: