RE: Create SQL Table With Labels

["Jeff Crosby" <jlcrosby@xxxxxxxxxxxxxxxx>]

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.