I thought you said you were getting a lot of rows. If you are fetching more
than 100,000 or so all in one chunk (depending on the row size), you risk
running out of memory.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: "Rozengurtel, Daniel" <[EMAIL PROTECTED]>
To: "'Michael A. Chase'" <[EMAIL PROTECTED]>
Sent: Thursday, May 10, 2001 12:07
Subject: RE: SELECT
> Hi, Actually i got it the other way :)
> my $statement ="select ISID.iss_id, ISDE.iss_desc from FT_T_ISID ISID,
> FT_T_ISDE ISDE where ISID.ID_CTXT_TYP='BBCUSIP' and
> ISID.instr_id=ISDE.instr_id";
>
> $ary_ref = $dbh->selectall_hashref($statement);
> my %hash;
> foreach $record(@$ary_ref)
> {
> $hash{$record->{'ISS_ID'}}=$record->{'ISS_DESC'}; #i.e
> $hash{key}="value";
> }
>
> Thanx
>
> > -----Original Message-----
> > From: Michael A. Chase [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, May 10, 2001 2:36 PM
> > To: Rozengurtel, Daniel; [EMAIL PROTECTED]
> > Subject: Re: SELECT
> >
> >
> >
> >
> >
> > I would
> > $dbh -> {RaiseError} = 1;
> > my $sth = prepare();
> > $sth -> execute( ... );
> > $sth -> bind_columns( \( ... ) );
> > while ( $sth -> fetch ) {
> > }
> >
> > They are all described in the fine manual (perldoc DBI).
> > --
> > Mac :})
> > ** I normally forward private database questions to the DBI mail lists.
**
> > Give a hobbit a fish and he'll eat fish for a day.
> > Give a hobbit a ring and he'll eat fish for an age.
> > ----- Original Message -----
> > From: "Rozengurtel, Daniel" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, May 10, 2001 09:19
> > Subject: SELECT
> >
> >
> > > I need to run this select statement:
> > > select ISID.instr_id, ISDE.iss_desc from FT_T_ISID ISID, FT_T_ISDE
ISDE
> > > where ISID.ID_CTXT_TYP='BBTICKER' and ISID.instr_id=ISDE.instr_id
> > > which invokation method should I use? ( it has to return a lot of
> > records)?
> >
> >
> >
> _____________________________________________________________________
> IMPORTANT NOTICES:
> This message is intended only for the addressee. Please notify
the
> sender by e-mail if you are not the intended recipient. If you are not the
> intended recipient, you may not copy, disclose, or distribute this message
> or its contents to any other person and any such actions may be unlawful.
>
> Banc of America Securities LLC("BAS") does not accept time
> sensitive, action-oriented messages or transaction orders, including
orders
> to purchase or sell securities, via e-mail.
>
> BAS reserves the right to monitor and review the content of all
> messages sent to or from this e-mail address. Messages sent to or from
this
> e-mail address may be stored on the BAS e-mail system.
>
>
>
