• Subject: Re: IDDU, S36 & AS/400 SQL & RPG -Reply -Reply
  • From: Richard Baird <rbbaird@xxxxxxxxxxx>
  • Date: Wed, 10 Dec 1997 09:20:36 -0500
  • Organization: Premium Systems, Inc.

Scott,

> Absolutely true - however, what I was referring was not SQL's
> ignorance of members, but the basic underlying difference between a
> file object and a table object. To wit, the following is not possible,
> even though the OVRDBF part is legitimate:
> 
> 1) SQL - CREATE TABLE FRED (SOME_DATA NUMERIC)
> 2) SQL - INSERT INTO FRED (SELECT SOME#S FROM SOMEWHERE)
> 3) OS/400 - ADDPFM FRED MBR(SECOND)
> 4) OS/400 - OVRDBF FRED MBR(SECOND)
> 5) SQL - INSERT INTO FRED (SELECT SOME#S FROM
>            SOMEWHERE_ELSE)
> 
> The ADDPFM pukes, giving a CPF message stating that one can't have
> multiple members in an SQL table.  

I'd never tried that.  obviously, something must be different.

I remember hearing somewhere that there are benefits to using sql tables
rather than dds pfs, but I don't know what they are. 

Anyone care to comment?

rick
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].