RE: Creating Tables

LABEL ON mylib/myfile (myfield IS 'My something field')
LABEL ON mylib/myfile (myfield TEXT IS 'My something field')

First one will set column headings and second will set text description.

Elvis

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
daparnin@xxxxxxxxxxxxxx
Sent: Monday, October 03, 2005 2: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