Re: Column Description on Create Table (SQL)

DDS TEXT() keyword replaced by the SQL
LABEL ON COLUMN MYTBALE (
MYCOL1 text is 'My Column';
...
);


DDS COLHDG() keyword replaced by the SQL
LABEL ON COLUMN MYTBALE (
MYCOL1 is 'My Column';
...
);

Note that the above would give you a two line column heading...It's a fixed
format 60 character label. Each 20 characters is a separate line.

HTH,
Charles



On Tue, Sep 1, 2015 at 11:14 AM, Buzz Fenner <bfenner@xxxxxxxxxxxxxxxx>
wrote:

I've looked through the manual and I'm probably overlooking this, but

what

is the method for adding a description to a field during table creation

or

alteration, much like using the TEXT('xxx') keyword for DDS physical

files?

--
Buzz Fenner, Analyst/Systems Administrator
+1 (870) 930.3374 bfenner@xxxxxxxxxxxxxxxx<mailto:

bfenner@xxxxxxxxxxxxxxxx

City Water and Light of Jonesboro
Office: +1 (870) 935.5581 / Fax: +1 (870) 930.3301
Physical: 400 East Monroe Ave., Jonesboro, AR 72401
Mailing: PO Box 1289, Jonesboro, AR 72403-1289

This e-mail message may contain confidential or legally privileged
information and is intended only for the use of the intended

recipient(s).

Any unauthorized disclosure, dissemination, distribution, copying or the
taking of any action in reliance on the information herein is prohibited.
E-mails are not secure and cannot be guaranteed to be error free as they
can be intercepted, amended, or contain viruses. Anyone who communicates
with us by e-mail is deemed to have accepted these risks. City Water and
Light of Jonesboro is not responsible for errors or omissions in this
message and denies any responsibility for any damage arising from the use
of e-mail. Any opinion and other statement contained in this message and
any attachment are solely those of the author and do not necessarily
represent those of the company.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.