Re: Concatenation of files

Hi:

This doesn't sound right. We have several multi-format logicals built on 
physical files with radically different formats. Certain utility setups, 
such as DBU in multi-record mode, don't work with such files, but that is 
not a problem for the most part. 

The original message didn't mention indexes. However, record order is 
probably implicit in the question.

I *believe* we are running programs that depend on the order of records in 
multi-format logicals. This suggests that these logicals are indeed 
indexed (in some way) on values from different files. I would be 
interested in the rules if this is not true. It might help solve some 
long-term nagging problems.

Darrell

Darrell A. Martin  -  754-2187
Manager, Computer Operations
dmartin@xxxxxxxxxxxxx

midrange-l-bounces@xxxxxxxxxxxx wrote on 07/18/2006 10:12:50 AM:

I recently had similar scenario.
A logical file MUST use indexes 100% taken from one file, can't mix 

them.

So I created an intermediate logical to feed the stuff into a OPNQRYF 

then 

the data from that became indexed the way I wanted.
Perhaps not ideal solution.

This e-mail, including attachments, may contain information that is 
confidential and/or proprietary, and may only be used by the person to 
whom this email is addressed. If the recipient of this e-mail is not the 
intended recipient or an authorized agent, the reader is hereby notified 
that any dissemination, distribution, or copying of this e-mail is 
prohibited. If this e-mail has been delivered to you in error, please 
notify the sender by replying to this message and deleting this e-mail 
immediately.