Re: Possible bug in SQL 'create or replace' wrt primary keys?

[Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx>]

that behavior happens to me as well (7.2 very current PTF groups)


On Wed, Jul 19, 2017 at 10:58 AM, David Gibbs <david@xxxxxxxxxxxx> wrote:

> Folks:
>
> I observed some odd behavior and just want to confirm its a bug before we
> open a PMR.
>
> We ran the following SQL statement ...
>
> create or replace table yourlib/pk1 (f1 char (10), f2 char (10), f3 char
> (20), primary key (f1,f2));
>
> and did a DSPFD on it ... the key fields for the file showed up correctly.
>
> We then ran this statement ...
>
> create or replace table yourlib/pk1 (f1 char (10), f2 char (10), f3 char
> (20), primary key (f2,f1));
>
> (just reversing the order of the primary keys)
>
> When we did a DSPFD on the file, the key fields for the file showed up as
> F1 & F2 (in that order).
>
> Can someone run that same test and confirm the behavior?
>
> Thanks!
>
> david
>
> --
> IBM i on Power Systems: For when you can't afford to be out of business!
>
> I'm riding a metric century (100 km / 65 miles) in the American Diabetes
> Association's Tour de Cure to raise money for diabetes research, education,
> advocacy, and awareness.  You can make a tax deductible donation to my ride
> by visiting https://mideml.diabetessucks.net.  My goal is $6000 but any
> amount is appreciated.
>
> You can see where my donations come from by visiting my interactive
> donation map ... https://mideml.diabetessucks.net/map (it's a geeky
> thing).
>
> I may have diabetes, but diabetes doesn't have me!
> --
> 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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD