Re: IBMDA400 w/packed decimal data

Rob beat me to it...I was going to suggest using IBMDASQL...

*Database Provider* *Framework* *Consideration*
*IBMDA400* OLE DB Provider Existing applications; applications that want
the most flexible OLE DB support, including support for SQL, RLA, Data
Queues, and Commands.
*IBMDASQL* OLE DB Provider SQL-only support; SQL commitment control and
MTS; (Note: IBMDA400 does not support SQL commitment control or MTS)
*IBMDARLA* OLE DB Provider RLA-only support; Forward-only cursors and block
fetches with RLA; (Note: IBMDA400 does not support forward-only cursors or
block fetches with RLA)
*IBM.Data.DB2.iSeries* .NET Provider Offers the best performance when using
the .NET framework.


That's the one I usually use.

Charles

On Mon, May 9, 2016 at 12:57 PM, Rob Berendt <rob@xxxxxxxxx> wrote:

This didn't seem to be very helpful

https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000013869525&ps=25

I did see this one comment:
<snip>
Try using IBMDASQL instead of IBMDA400 and see if that makes a difference.

</snip>


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

--
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.