RE:Using SELECT AS to Create Column Heading

["Bob Schwartz" <rschwartz@xxxxxxxxxxxxxxx>]

Elvis, thank you for all the help, very informative. Let us know when you
publish the command to run SQL from CL! Bob

message: 8
date: Tue, 23 Oct 2007 17:08:13 -0500
from: "Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>
subject: RE: Using SELECT AS to Create Column Heading

Correct. Another QM query then?  It could be generic and take 2 parms, i.e.:

LABEL ON COLUMN &FIELD IS &COLHEADING

Then you'd have to run it for each column... ugly, but doable.

BTW, you can put the label on multiple columns in one swoop:

LABEL ON COLUMN XCADVICE                            
(                                                   
  SCHOOL     IS 'Elementary          School', 
  GRADE      IS 'Student             Grade', 
  HOMEROOM   IS 'Student             Classroom',
  TEACHER_ID IS 'Teacher             Identification'
)

But making a QM query for multicolumn LABEL command would be cumbersome.
I'm planning to publish a command that lets user run SQL from CL, if you're
interested (might make things a bit easier).

Good luck.

Elvis

2007 System i Fall Technical Conference | Orlando | November 4-7
Celebrating 10-Years of SQL Performance Excellence on IBM i5/OS and OS/400

-----Original Message-----
Subject: RE: Using SELECT AS to Create Column Heading

Elvis, Thanks for the tip, but I need to pass variables and I don't think I
can do that with RUNSQLSTM? Bob