RE:Using SELECT AS to Create Column Heading

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