Re: DDS Support

["Eric N. Wilson" <doulos1@xxxxxxxx>]

When you do your create table statement you could use AccountNumber as a
datatype ( ie. instead of using integer)

 CREATE TABLE Customer (
        CustAcct         AccountNumber,
        CustName     VarChar(50)
 );

Then you could do the same with other tables giving the Account# fields
names that make sense in the context of the table. Again I would encourage
anyone using SQL for their DDL to store the commands in a source member. (
Preferably one per object :-)



______________________________________________
Eric N. Wilson
President
Doulos Software & Computer Services
2913 N Alder St.
Tacoma WA 98407


----- Original Message -----
From: "James W. Kilgore" <eMail@James-W-Kilgore.com>
To: <MIDRANGE-L@midrange.com>
Sent: Thursday, June 29, 2000 1:36 AM
Subject: Re: DDS Support


> Eric,
>
> You're the man!
>
> I will readily admit that I'm an SQL dummy. So I have to ask, how does
> this translate into a creatable, maintainable source member?
>
> For example, I have a field AccountNumber which is used in 14 different
> physical files.  Each occurrence needs to have a different name to avoid
> buffer to variable content conflict.  I.E. AccountNumber in master file
> vs AccountNumber in transaction file.
>
> Some languages, not RPG, will prefix the variable by the file name, but
> we live in an RPG world.  So please educate me on how I can extrapolate
> AccountNumber to 14 uses, uniquely named?
>
> "Eric N. Wilson" wrote:
> >
> >
> > What about the Domain keyword that most every SQL implementation I know
of
> > other than DB2 UDB supports? Then you can say that this field is a
> > AccountNumber field and it would take on the attributes of the Domain
> > AccountNumber.
> >
> > The syntax for the command is
> >
> > Create Domain AccountNumber as Integer
> >
> > Or you could be more creative and add check constraints to the domain
> >
> > Create Domain AccountNumber as Integer
> >     Check((Value >= 100) Or Value Is Null)
> >
> > Then you will have the Handy Dandy AccountNumber DataType available for
your
> > SQL enjoyment :-)
> >
> > ______________________________________________
> > Eric N. Wilson
> > President
> > Doulos Software & Computer Services
> > 2913 N Alder St.
> > Tacoma WA 98407
> >
> > +---
> > | This is the Midrange System Mailing List!
> > | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> > | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> > | Questions should be directed to the list owner/operator:
david@midrange.com
> > +---
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---