RE: Record format ID not the same for INDEX with ADD column-name specified

Charles,
I don't have anything to add, but I appreciate the time you
took to make your interesting and informative post.
Best wishes!

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Tuesday, November 27, 2012 11:14 AM
To: Midrange Systems Technical Discussion
Subject: Re: Record format ID not the same for INDEX with ADD column-name specified

No takers on this one?

Charles


On Sun, Nov 25, 2012 at 9:37 PM, Charles Wilt <charles.wilt@xxxxxxxxx>wrote:

All,

I had a DDS logical replaced some time ago(pre v5r4) with an SQL index:
create index IORITEM1
on IORITEMM (INDCNO,IITNBR);

rename index ioritem1 to ioritend;

Now I'm looking at replacing the PF with an newly named SQL table,
turning the original PF into a logical...all that is working fine till
I get to the above index.

Updating to 7.1 and using my new table, gives me this:
create index IORITEMND
on IORITEM_MASTER (INDCNO,IITNBR)
rcdfmt IORITEM1;

which gives me a LF with the same record format ID as the original.

However, I know that I'll be making changes to the new table and I
wanted to go ahead and make the record format of the index/logical
static by using the ADD column-name clause:
create index IORITEMND
on IORITEM_MASTER (INDCNO,IITNBR)
rcdfmt IORITEM1
add FLD1, FLD2, FLD2 <...>;

(fields names just examples)
Although DSPFD shows the same length and number of fields, the record
format ID is not the same.

Ok, so it appears that the key columns end up preceding the rest of
the rest of the columns...and the manual does mention this. :)

I guess for "heritage" DDS files, I'll just need to stick to DDS if I
want a static format unless I'm willing to recompile existing programs one time.

Unless somebody knows of something I'm missing?

Thanks!
Charles

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