Elvis, Thanks for the tip, but I need to pass variables and I don't think I
can do that with RUNSQLSTM? Bob
Column heading is actually a LABEL in
<
http://archive.midrange.com/midrange-l/200710/msg01240.html#> SQL
terminology. So after you create
a table, you'd do something like:
LABEL ON COLUMN SCHOOL IS 'Elementary School District
535'
Notice that you can have up to 3 rows of column heading as each row will
hold up to 20 characters worth of data.
You can also add up to 50 characters descriptive text to the column by
another LABEL command, for example:
LABEL ON COLUMN SCHOOL IS 'Elementary school district 535 rocks the house'
I wouldn't use QMQRYs for this type of DDL work since it doesn't permit for
running multiple statements within the same source (well, I guess you can
use QM procedures but...).
RUNSQLSTM on the other hand allows for multiple statements in the same
source, separating them with semicolons.
HTH
Elvis
midrange.com
