I think I've heard a few options:
- CPYTOIMPF, fraught with the exponential becoming character (and my usual
litany of pet peeves)
- Writing directly to a CSV with stream file apis. Does away with my pet
peeves and allows you to ensure that the number is not stored as "5E72"
but is instead stored as a number. APIs are documented at Scott Klement's
- Using HSSF APIs as documented at Scott Klement's website. But, for some
reason, they were not desired. It was new, change or something else that
made the sky to appear as falling.
- SQL2XLS or some lookalike that would run a sql statement and output it
directly into a spreadsheet on your i.
- Using IBM i Access for windows file transfer to get it on to your PC
- Using the Data transfer AddIn for Excel to read data directly from the i
Of course we could add a few like
- run a macro in Excel to convert text like "5E72" to a number.
- throw money at some reporting tools software to do this for you.
Good luck with that. Hopefully one of those will help you to find
something that is, first and foremost, effective. Then you can decide if
it's reliable, efficient and cost effective. And whether the new
knowledge of the new tool is throw away or something that you'll use again
This mailing list archive is Copyright 1997-2019 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