IBM DB2 Iseries Field Names and Field Descriptions

Question

Just started using Alteryx this week.  My input data source is IBM DB2 tables on a AS400.  I can use either OleDB or ODBC driver to access the tables to build queries with the Visual Query Builder.  However, the field names which are 6 digit names are shown (below).  Wondering if anyone has a method for displaying the longer field descriptions instead of just the cryptic field name?

Field Names (example)

patrick_digan · Accepted Answer

@bchunn01 I run these 2 queries every night to save out the table descriptions and column descriptions:

Table descriptions: 
Select SYSTEM_TABLE_SCHEMA, TABLE_NAME, varchar(TABLE_TEXT, 50) As TABLE_DESC From QSYS2.SYSTABLES

Column descriptions: 
Select SYSTEM_TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, varchar(COLUMN_TEXT, 50) As COLUMN_DESC From QSYS2.SYSCOLUMNS