Re: DDL Files - Tables and keys

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.