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

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