PERL Modules - Re: [DBI] Statement allocation error

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: [DBI] Statement allocation error

Joachim Pense

2006-12-20, 6:58 pm

Oops, wrong newsgroup...

Am Wed, 20 Dec 2006 15:13:47 +0100 schrieb Joachim Pense:

> I get
> DBD::DB2::db selectall_arrayref failed: Statement allocation error
> after submitting a selectall_arrayref statement. My other queries in this
> program work fine.
>
> This error message seems to come from DBD, not from DB2. Any hint what this
> error could be about?
>
> The query looks unsuspicious to me:
>
> select distinct wgh.res_type as TYPE
> , wgh.res_code as CODE
> , wgh.res_weight as weight
> from emea.res_weight_vw wgh
> join session.res_summary_result rsr
> on wgh.res_type = rsr.res_type
> and wgh.res_code = rsr.res_code
> with ur
>
> Joachim

Sponsored Links