Re: Weird problem a customer is having with a file

Even though I'm a complete novice with Query/400, I 
decided to try modeling the customer's situation.

I found that if the date format for the file field is 
*ISO, there's no problem. But if it's *MDY, it creates the 
same unreadable "grand total" record the customer was 
getting.

Just trying things out of the manual, I found that if you 
define a "result field" thusly:
                              Define Result Fields
                                                            
                   Type definitions using field names or 
constants and operators, press Enter.
   Operators:  +, -, *, /, SUBSTR, ||, DATE...

Field       Expression                         Column 
Heading        DATECHAR    CHAR(DATEFLD) 
                     DATE

and use DATECHAR in place of DATEFLD in the rest of the 
query, you avoid the unreadable record, since everything 
goes into the query summary as a character field. You can 
also specify how you want the date formatted.

So I guess I've answered my own parting question on this 
puzzle.

Thanks for all your help.

--
JHHL
_______________________________________________
This is the MI Programming on the AS400 / iSeries (MI400) mailing list
To post a message email: MI400-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mi400
or email: MI400-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mi400.