Re: IBMDA400 w/packed decimal data

[Charles Wilt <charles.wilt@xxxxxxxxx>]

However, assuming that works with the same statement, I'd open a PMR.

There's no reason for IBMDA400 to be dropping packed fields.

Charles

On Mon, May 9, 2016 at 1:01 PM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

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