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



This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].