CREATING COLUMN HEADERS IN EXCEL 2016 HOW TO

You can use the LABEL ON COLUMN to change the Column Headings for any file or table, not just outfiles produced by Query. When I use the RUNQRY command to view the contents of the output file I see the new column headings: First field Second field Date First field Second field Date When I repeat the SQL query over SYSCOLUMNS I see the change: RUNSQL SQL('LABEL ON COLUMN MYLIB/OUTFILE (+ My RUNSQL command uses the 'LABEL ON' with the 'IS' to change the Column Headings:

CREATING COLUMN HEADERS IN EXCEL 2016 HOW TO

If you are not familiar with this command you really ought to learn how to use it, to learn more read Run SQL statements in your CL. I could execute this SQL statement in embedded in RPG, a Query Management Query, use RUNSQLSTM, but I chose to do it in a CL program using the RUNSQL command. In my example I want to change all of the headings. SYSTEM_TABLE_NAME SYSTEM_COLUMN_NAME CAST functionĪs I mentioned at the start of this post I can change the Column Headings. SELECT SYSTEM_TABLE_NAME,SYSTEM_COLUMN_NAME,ĬAST(COLUMN_HEADING AS CHAR(50) CCSID(37)

If you are not familiar with using this View you ought to read Getting field definitions using SYSCOLUMNS. Or I can retrieve the Column Headings for the outfile by using the SYSCOLUMNS View.

Convert the seven long date, FDATE, to the recognizable eight long.

Join the file to itself on the field F2.

Let me start with the example file I am gong to use: You can use the LABEL ON COLUMN to change the Column. I could email myself/download the file and change the column headings in Microsoft Excel, but there must be an easy way to do it? Fortunately there is using SQL. When I use the RUNQRY command to view the contents of the output file I see the new column headings: First field Second field Date First field Second field Date AAA AAA AAA BBB BBB BBB AAA FIRST 20,120,405 BBB FIRST 20,120,305 AAA SECND 20,080,914 BBB SECND 20,150,630. Even if I go into the option to 'Specify report column formatting' and change the Column Headings, I still get the original column headings in the outfile. If for example I join a file to itself and/or 'define a result field' the Column Heading produced is unclear or outright confusing. One of the drawbacks of using Query are the Column Headings it produces for outfiles. Yes, I know I could use SQL to do the same, but sometimes it is just, in my opinion, quicker and easier to use Query. While I do not use it for 'production' reports, I do use it is a quick and easy way to check data, or even to generate a quick 'one off' output file.

I am sure there are some who are going to criticize me for saying this, but I do use Query.

Creating column headers in excel 2016