I am doing a lot of queries and like to use the data in a MS Excel table. These Excel tables are used also by non-IT personnel. When transferring the data, the header is taking the field names, which are not very self-explanatory sometimes. Is there any possibility to get the describing text into the header of the columns?
It really depends on the interface that they're using to do your queries. The newly announced IBM DB2 Web Query for System i product does support query results being stored in Excel files. You can find more
about this new product at IMB's Web site.
Dig Deeper on DB2 UDB (universal databases)
Create a host variable of the where in statement on the fly with dynamic SQL.
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ...
When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC ...