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

>> While it is generally true that SQL don't know da difference 'tween a
>> "CREATE TABLE" objects and a "CRTPF" object, there are some
>> differences, at least at the system level.  One is that SQL tables can
>> not have more than one member, even though SQL can access
>> multiple member "CRTPF" files using OVDBF.  So somewhere down in
>> the bowels of the system, there is (are?) a difference(s).
> 
>The differences you site have more to do with SQL syntax compatibility
>than differences in the database.   
>
>The create table and crtpf bot create DB2-400 database files.  but SQL,
>being a cross platform language, doesn't know what a multi member file
>is, because that's a 400 specific file type.  the ovrdbf command more or
>less "explains" the concept to SQL.

Actually, there *is* a difference in the created file.  I didn't believe that
an SQL file was any different from a DDS file until I tried this:

create table test (key numeric(5,0),name char(30))
chgpf test maxmbrs(2)

It bombs and tells me that I can't change an SQL table to be multiple
members (at least it does on V4)... CPD3213...
  SQL tables, views, indexes, and non-SQL files that are in an SQL data base
must have only one member; however, the value that you specified on the     
maximum number of members (MAXMBRS) parameter is either a number greater    
than one or *NOMAX.  For more information about SQL tables, views and       
indexes, see the Programming: Structured Query Language Programmer's Guide, 
SC41-9609.                                                                  

Buck Calabro
Commsoft

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