Re: SQL Casting/Exponential Notation

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
web site.
- 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
into Excel
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
and again.



Rob Berendt