Re: Re[2]: SQL-defined files/tables

[jpcarr@xxxxxxxxxxxx]

Dan, Eric

Pragmatically(not phisophically) ,   I don't think User Defined Types will
be embraced or implemented as widely as the Reference File concept.    Sure
you can define Canadian Dollars and US Dollars as UDT's,  and each can have
their own rules of behavior,   but I'd be willing to bet that most shops
will find them too narrow and restrictive to be used widely.

I don't know why the DB guys won't just admit that the designers of the
Sys/38 had a great idea back in 1978+/-    with the Reference(with very
liberal built in type casting).

John Carr


------------
Eric,

How about an example?  For an SQL newbie...

Dan Bale


----------------
Hello Al,

Thursday, December 07, 2000, 1:57:28 PM, you wrote:

> At 03:09 PM 12/7/00 -0500, you wrote:

> IBM deems DDS to be proprietary, and SQL to be an industry standard.  In
> this respect, they are correct.

> However, the field reference capability in DDS is not available in
> SQL.  You can be significantly more productive in DDS than in SQL for
> database file definition.  In my opinion, IBM is being cheap and stupid
not
> extending these capabilities to DDS.

Al,

You can get the same capability by doing a Create Distinct Type. I
think it is even better because in your script you would say a field
is a Type of AccountNumber if you had created such a type.

----------------------------------
Eric N. Wilson
President
Doulos Software and Computer Services



                                                                                
                  
                    D.BALE@handleman.co                                         
                  
                    m                          To:     MIDRANGE-L@midrange.com  
                  
                    Sent by:                   cc:                              
                  
                    owner-midrange-l@mi        Subject:     Re[2]: SQL-defined 
files/tables       
                    drange.com                                                  
                  
                                                                                
                  
                                                                                
                  
                    12/08/2000 09:34 AM                                         
                  
                    Please respond to                                           
                  
                    MIDRANGE-L                                                  
                  
                                                                                
                  
                                                                                
                  



IT - AS/400
Handleman Company
248-362-4400  Ext. 4952

-------------------------- Original Message --------------------------

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