Re: SQL Casting/Exponential Notation

Thanks Charles!

On Thu, May 17, 2012 at 1:28 PM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

I suggest explicitly importing the data into excel, instead of
allowing Excel to implicitly import it by clicking on the CSV...

For Excel 2010, click the data tab, and then the "From Text" icon
shown in the "Get External Data" section of the ribbon.

Also check the STRDLM   parm of CPYTOIMPF....the IBM default is
*DBLQUOTE, but perhaps somebody is changing it.  Otherwise Excel is
being really stupid....which wouldn't surprise me :)

Charles

On Thu, May 17, 2012 at 1:23 PM, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:

Thanks John...what would you suggest to make the transition to Excel
easier? HSSF would probably be more than could be handled.

- Michael

On Thu, May 17, 2012 at 1:20 PM, John Yeung <gallium.arsenide@xxxxxxxxx> wrote:

On Thu, May 17, 2012 at 12:54 PM, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:

Sigh...yes, of course it's an Excel issue. Sorry for the post...I was
making expectations that I shouldn't have made. Thanks for the help.

No worries.  Now, even though the case is closed on the culprit, there
is still the issue of what to do about it.  Excel, for all its faults,
is a pretty good end-user application, and certainly an application
huge numbers of people are comfortable using.  If this data is
normally going to be opened in Excel, it is probably worth it to
implement a way to deliver the data in a form that Excel won't mangle
(which is what I offered further help with, if needed).

John
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.