Re: DDL Files - Tables and keys

[Doug Palme <DPalme@xxxxxxxxxxx>]

   Ok....thanks Tom....

   From:                    Tom Liotta <qsrvbas@xxxxxxxxxxxx>                 
   To:                      midrange-l@xxxxxxxxxxxx                           
   Date:                    08/15/2008 06:32 PM                               
   Subject:                 Re: DDL Files - Tables and keys                   

     ----------------------------------------------------------------------

   Doug Palme wrote:
   >    Ok,
   >    Some are saying that you can use them with aliases, etc. and I assume
   you
   >    just said that won't work Jeff.....I'm confused.

   Doug:

   SQL (on OS/400, i5/OS, etc.) can _handle_ multi-member physical
   files. The SQL ALIAS statement is an example of how _handling_ can
   be done.

   However...

   SQL cannot be used to _create_ multi-member SQL TABLEs with DDL, and
   a SQL TABLE is restricted from having more than a single member.

   "Handling" members is different from "creating" members. PFs and
   TABLEs are _not_ exactly equivalent except in the sense that a TABLE
   is _implemented_ as a *FILE with the PF attribute. In addition to
   the PF attribute, there are other attributes that aren't always as
   obvious.

   It is your original statement about using DDL that brings up this
   difference. If you use DDS, multi-members is easy. If you use DDL,
   it's not easy.

   ...unless someone here can provide a method.

   Tom Liotta

   --
   Tom Liotta
   The PowerTech Group, Inc.
   19426 68th Avenue South
   Kent, WA 98032
   Phone  253-872-7788 x313
          253-479-1416
   Fax    253-872-7904
   http://www.powertech.com
   --
   This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
   list
   To post a message email: MIDRANGE-L@xxxxxxxxxxxx
   To subscribe, unsubscribe, or change list options,
   visit: http://lists.midrange.com/mailman/listinfo/midrange-l
   or email: MIDRANGE-L-request@xxxxxxxxxxxx
   Before posting, please take a moment to review the archives
   at http://archive.midrange.com/midrange-l.

   This transmission may contain information that is privileged, confidential
   and/or exempt from disclosure under applicable law. If you are not the
   intended recipient, you are hereby notified that any disclosure, copying,
   distribution, or use of the information contained herein (including any
   reliance thereon) is STRICTLY PROHIBITED. If you received this
   transmission in error, please immediately contact the sender and destroy
   the material in its entirety, whether in electronic or hard copy format.
   Thank you.