Re: ITHL02 sort

Well, Al.  You are both right and wrong.  Yes, DspFD shows the text
description of the object, but further down it does give the actual
definition of the key fields:

Access path . . . . . . . . . . . . . . . . :            Keyed
Number of key fields  . . . . . . . . . . . :              2
Record format . . . . . . . . . . . . . . . :            IPI500TH
  Key field . . . . . . . . . . . . . . . . :            TPROD
    Sequence  . . . . . . . . . . . . . . . :            Ascending
    Sign specified  . . . . . . . . . . . . :            UNSIGNED
    Zone/digit specified  . . . . . . . . . :            *NONE
    Alternative collating sequence  . . . . :            No
  Key field . . . . . . . . . . . . . . . . :            TSEQ
    Sequence  . . . . . . . . . . . . . . . :            Ascending
    Sign specified  . . . . . . . . . . . . :            SIGNED


I am willing to bet that the answer is as someone previously suggested.
They are looking at ITHL02 through either SQL or Query and expecting the
output to mimic the key information in the file.  That's not how they work,
the sorting criteria must be specified.

Bill

----- Original Message -----
From: <MacWheel99@aol.com>
To: <BPCS-L@midrange.com>
Sent: Wednesday, August 02, 2000 12:05 AM
Subject: Re: ITHL02 sort


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


__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
+---
| 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
+---