Craig,
I have full version of IBM i Access for Windows installed on my pc, this
was installed prior to the IBM i Access Client (I find those ACCESS names
confusing.....)
Anyway, following your instructions, my PC service level was at SI50567,
but now applied the lastest service pack, which brings me to Version 7 Rel
1 Mod 0 Service Level SI57907.
Tried a new odc connection, again using the IBMDA400 driver..... same
issue. Using these odc connections and bringing my iSeries data into
Excel is pretty slick.....until I come across a file with a packed decimal
field.
Jon Paris suggested redefining my packed fields with a logical, that may
be my only solution to this...which would work for me.
Thanks for the reply.
Diane
From: "Craig Pelkie" <craig@xxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>
Date: 05/09/2016 05:03 PM
Subject: RE: IBMDA400 w/packed decimal data
The PTFs may not have affected the code on your PC, unless the IBM i
Access
for Windows (not IBM i Access Client) was updated from the PTFs.
I don't know if you have the full version of IBM i Access for Windows
installed, or just the database drivers, which IBM released separately (as
"IBM i Access Client Solutions - Windows Application Package", an add-on
to
IBM i Access Client
If you have IBM i Access for Windows installed (perhaps you had this on
your
PC before you installed IBM i Access Client), try this: go to Start menu,
look for "IBM i Access for Windows" (or "System i Access for Windows", or
"iSeries Access for Windows"). Within that program group, look for the
"Properties" program (title something like "IBM i Access for Windows
Properties"). On the General tab of that program, it will show what
Version/Release/Mod of the package is installed on your PC, and most
importantly, the Service level (something like SI42423, whatever).
You need to check your VRM number and service level against what is
available on the IBM downloads page for service packs:
http://www-03.ibm.com/systems/power/software/i/access/windows_sp.html
Craig Pelkie
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
dmmueller@xxxxxxx
Sent: Monday, May 09, 2016 8:55 AM
To: Midrange Systems Technical Discussion
Subject: Re: IBMDA400 w/packed decimal data
Charles,
iSeries - V7R1
PTFs - applied each 6 months
IBM I Access Client - version 1.1.5
Windows 10
MS Office Excel 2013
I feel that I am current with all software & ptf's.
When I take the option in Windows to create a new data source to bring the
data directly into Excel, and use the IBMDA400 driver, it will drop my
packed decimal every time. I can convert my packed decimal data to a text
field in an sql select statement, but then that gets ugly in Excel.
Diane
--
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.
Please contact support@xxxxxxxxxxxx for any subscription related
questions.
midrange.com
