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

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

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. ulloa
    Replies:
    1
    Views:
    508
    Juha Laiho
    Jul 22, 2004
  2. Ken
    Replies:
    24
    Views:
    3,816
    Ben Bacarisse
    Nov 30, 2006
  3. chris
    Replies:
    6
    Views:
    965
    chris
    Oct 28, 2005
  4. Bjarke Hammersholt Roune
    Replies:
    14
    Views:
    1,164
    Bjarke Hammersholt Roune
    Mar 6, 2011
  5. Jerome Hauss
    Replies:
    0
    Views:
    157
    Jerome Hauss
    Oct 13, 2004
Loading...

Share This Page