RE: Create SQL Table With Labels

Here's an example:

CREATE TABLE JEFF/TBLCMERR (
CMERCD CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
CMERDS CHAR(25) CCSID 37 NOT NULL DEFAULT '' ,
CMERH1 CHAR(11) CCSID 37 NOT NULL DEFAULT '' ,
CMERH2 CHAR(11) CCSID 37 NOT NULL DEFAULT '' ,
PRIMARY KEY ( CMERCD ) )
NOT VOLATILE
RCDFMT CMERRRC ;

LABEL ON TABLE JEFF/TBLCMERR
IS 'Credit memo error codes table' ;

LABEL ON COLUMN JEFF/TBLCMERR
( CMERCD IS 'C/M Error Code' ,
CMERDS IS 'C/M Error Description' ,
CMERH1 IS 'C/M Error Header 1' ,
CMERH2 IS 'C/M Error Header 2' ) ;

LABEL ON COLUMN JEFF/TBLCMERR
( CMERCD TEXT IS 'C/M error code' ,
CMERDS TEXT IS 'C/M error description' ,
CMERH1 TEXT IS 'C/M error desc header 1' ,
CMERH2 TEXT IS 'C/M error desc header 2' ) ;

--
Jeff Crosby
UniPro FoodService/Dilgard
P.O. Box 13369
Ft. Wayne, IN 46868-3369
260-422-7531
www.dilgardfoods.com

The opinions expressed are my own and not necessarily the opinion of my
company.  Unless I say so.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of RWMunday
Sent: Friday, March 27, 2009 5:25 PM
To: Midrange Systems Technical Discussion
Subject: Create SQL Table With Labels

Greetings from the rainy First Coast.


I have been assigned to create some files, but instead of going native we
are to create them as SQL tables. I am trying to imitate what I can of

the

DDS TEXT and COLHDG which I put in every DDS for a PF I create. Query is
much easier to use as a tool when those two elements are defined.

I looked on the IBM site for SQL tables and the LABEL ON option looked

good.

However, my system didn't like it.

Do you have an example of an SQL table create using labels or whatever I
need to use to replicate what I can do in DDS?

Thanks,



Robert Munday
Munday Software Consultants
Montgomery, AL
on assignment in Jacksonville, FL

--
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.