×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
