|
We are V4R2M0 and current ptf's on an S2 and my experience with QMQRY is rather limited. In the Query/400 product, in the Report Column Formatting option you could do an F16 on the field whose edit code you wanted to change. Change a field defined as numeric to a use the date edit code was a simple matter of changing the edit code to a "2". In QMQRY, I am not finding a way to do the same thing. I keep getting the error message QWM1515 " Edit code for column x not valid." Under the Edit Column Formatting option I've changed the edit code to TDY/ (YYYY/MM/DD) and get the error when running the sample report. Running with no edit code, the date is formatted with decimals and period just like a numerically defined field would be edited. The field is defined as a packed 8,0 and the data displays like YYYYMMDD. Reading the manual and edit codes doesn't seem to help. I've tried the three edit codes available with & without the separator character and still get the error. I'm guessing that QMQRY is not letting the date edit code be applied to a non date defined field while Query/400 didn't seem to care. Any thoughts, suggestions, comments would be welcome as to how I can get the TDY/ edit code to work on a non date defined field. BPCS strikes again. Dilbert's Words Of Wisdom: "I love deadlines. I especially like the whooshing sound they make as they go flying by." Dennis Munro Badger Mining Corporation dmunro@badgerminingcorp.com <mailto:dmunro@badgerminingcorp.com> +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.