[DBI] Statement allocation error

Discussion in 'Perl Misc' started by Joachim Pense, Dec 20, 2006.

  1. 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
     
    Joachim Pense, Dec 20, 2006
    #1
    1. Advertisements

  2. 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
     
    Joachim Pense, Dec 20, 2006
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. dna
    Replies:
    1
    Views:
    1,452
  2. ulloa
    Replies:
    1
    Views:
    677
    Juha Laiho
    Jul 22, 2004
  3. Ken
    Replies:
    24
    Views:
    4,336
    Ben Bacarisse
    Nov 30, 2006
  4. chris
    Replies:
    6
    Views:
    1,211
    chris
    Oct 28, 2005
  5. Bjarke Hammersholt Roune
    Replies:
    14
    Views:
    1,449
    Bjarke Hammersholt Roune
    Mar 6, 2011
  6. Jerome Hauss
    Replies:
    0
    Views:
    318
    Jerome Hauss
    Oct 13, 2004
  7. Asby

    Mason, DBI, and DBI::Pg

    Asby, Jul 24, 2003, in forum: Perl Misc
    Replies:
    0
    Views:
    328
  8. Tim Haynes
    Replies:
    3
    Views:
    310
    Ron Reidy
    Sep 13, 2003
Loading...