RE: Creating Tables

Dave,

Check out the LABEL ON COLUMN command.

LABEL ON COLUMN mylib/myfile (field1 is 'field1 header', field2 is 'field2
header', ... )

or

LABEL ON COLUMN mylib/myfile (field1 text is 'field1 text', field2 text is
'field2 text', ... )


If you run STRSQL, then type "LABEL ON COLUMN" and press <F4>, the system
will prompt you from there.

Have fun!
Richard




-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of
daparnin@xxxxxxxxxxxxxx
Sent: Monday, October 03, 2005 3:02 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Creating Tables

I've used SQL for years to do UPDATE's and DELETE's but today I tried
CREATE TABLE for the first time as a quick way to avoid DDS for a one-shot
fix-it project.  It worked pretty good and I got the file that I was
expecting.  The only thing is that there is no field text description for
each field.  Is there a way to add that with ALTER TABLE or something?


Dave Parnin
--
Nishikawa Standard Company
Topeka, IN  46571
daparnin@xxxxxxxxxxxxxx