Re: IDDU, S36 & AS/400 SQL & RPG -Reply -Reply

[Richard Baird <rbbaird@xxxxxxxxxxx>]

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