Re: ITHL02 sort -- BPCS-L

From Al Macintyre on 405 CD AS/400 V4R3 mixed mode

DSPFD "says" the text of the programmer source code at time of compile, not 
what the file really is defined as.  I have found a few cases in 405 CD where 
apparently an SSA programmer, in the creation of a new logical, copied old 
source & neglected to rephrase what's unique about it ... which means that 
the WRKOBJ & other descriptions are also not quite right.  If your system is 
quiesed, it is safe to recompile a logical but I would not touch any 
physicals.  There has been some MIDRANGE_L discussion about how to use SQL to 
fix descriptions of some files, without messing up the data contained within 
them,  I have not bothered to do anything about this.

If we were still on our old computer I might be able to link creation date of 
file with what source was used, but everything we have now is creation dated 
when we moved everything to the new CPU.

>  From:    holstein13@excite.com (Paul Holstein)
>  
>  ITHL02 is supposed to be sorted by TPROD, and TSEQ.  However, whenever I
>  look at the file, I notice it is not sorted at all.
>  
>  I did a DSPFD on ITHL02 and it says it is sorted ascending by the two
>  fields.  Does anyone else have this problem?  How do I (or should I) fix
>  this?  Seams like this could make a big difference in performance.
>  
>  --Paul Holstein
>  iWork Software, L.L.C.

How are you determining that the data is not in right sequence?

On our system, if I do a dump of ITH via
RUNQRY *N ITH or
RUNQRY *N ITHL01 or
RUNQRY *N ITHL02 or
any one of a number of other logicals, I get to see the contents of ITH from 
the very beginning of the unsorted data ... oldest record is in 1999.

However, when STRDFU option FIVE define logical view
then when it prompts me for ITEM# & SEQ#, just scroll forwards through the 
file.
From this perspective ITHL02 & others are in the stated correct sequence.

So the question becomes
How does Paul know it is not sorted right? ... different tools different 
pictures
How should we check this stuff?

Al Macintyre  ���
MIS Manager Green Screen Programmer & Computer Janitor of BPCS 405 CD Rel-02 
running on AS/400 V4R3 http://www.cen-elec.com Central Industries of 
Indiana--->Quality manufacturer of wire harnesses and electrical 
sub-assemblies

Y2K is not the end of my universe, but a re-boot of that old Chinese curse.
The road to success is always under construction.
Accept that some days you are the pigeon and some days the statue.
Murphy's Mom brought wrong baby home from hospital so it should be Kelly's 
Law.
When in doubt, read the documentation, assuming you can find it.
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---