more I know, the more I know that I dont know a lot. :-) Would you help
me consider these questions?
Again, Thanx A LOT to all of you who helped me understand better what I need
to do.
Best regards,
Daniel
-----Original Message-
From: David N Murray [mailto:[EMAIL PROTECTED]
Sent: Friday, De
it looks to me like you need
to do the tuning there, and not in the DBI code.
If it was Oracle, I would not expect using functions like substr would cause
a performamce problem, but I would look at the query plan, and maybe try a
hint, eg change the
SELECT
to
SELECT /* INDEX(GOVT_TABLE) */
Michael
Hello All,
I am trying to optimize my code to work faster in selecting about 30 columns
from a denormolized table. The result set of 165,000 records is put to a
file on Unix in about 35-40 minutes. I have tried to follow the guide lines
from Tim's recent presentation on DBI (DBI_AdvancedTalk_20030
Hello All,
I have rather general question.
We are about to migrate to Oracle9i from 8.1.7. We are using:
Perl5.6.1
DBI 1.2
DBD::Oracle 1.12
Sun 5.8
The questions are:
1. If we do nothing to update our modules/libs/etc will our existing
scripts work against
Hello All,
I have a quick question:
Can I use a 'prepare' statement to execute later a "CREATE OR REPLACE
VIEW..." with passing to it a specific param? I.e. something like that:
my $sth_CreateEquityIDsView = $dbh->prepare(q{
CREATE VIEW IDS_COUNT_VIEW AS (
SELECT ISID.ID_CTXT_TYP, ISS_ID
You're absolutely right. Its better to use one sorted array instead of
sorting it all the time.
Thanx much again
Dan
-Original Message-
From: Michael A Chase [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 09, 2003 11:30 AM
To: Rozengurtel, Daniel; dbi-users
Subject: Re:
t sorted array of predefined fields. Something that I was
not able to achieve when I started this email. I am still puzzled as to why
it worked!!!
Anyway, thanx much for your time and help.
This has really been educating.
Daniel
-Original Message-
From: Michael A Chase [mailto:[EMAI
Dear friends,
I have a little problem that I am not sure I understand. Its about
bind_columns. I use it a lot cause its really fast in retrieving a lot of
data. I tie the values from table to keys in hash based on array of keys
that I pass to it in bind columns statement. (like in one of the fancy
Dear Gurus,
I am having problems with updating my Oracle table when changing one table's
column data type from VARCHAR2 to CHAR.
This particular column is in WHERE statement for an update. If it was left
as VARCHAR2 I would have no problems. However I need this data type be
persistent so that I ca
This is WONDERFUL !!!
Works very nicely :)
thanx a lot.
Dan
-Original Message-
From: Michael A Chase [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 20, 2003 3:36 PM
To: '[EMAIL PROTECTED]'; Rozengurtel, Daniel
Subject: Re: need help on "bind_columns "
On Thu,
Hello all,
I have a question about bind_columns feature.
In my next piece of code I am trying to get the values from specific fields
of a table to be associated with their names in ISSU_FIELDS hash. I cannot
indicate the exact fields I wanna fetch since its going to be chaning as per
client. Ther
> Hello All,
>
> we are about to migrate to our new PROD machine and I was wondering
> whether you can suggest on these questions:
> - We are currently using Perl5.6.1 should I migrate to Perl 5.8?
> - we are using DBI 1.20 - should we migrate to DBI 1.35? If so will
> functionalities from previou
Hello all,
I am having a problem with prepared sth that uses fetchrow_array with two
parameters passed in.
The problem is as follows:
in one of my tables I have a column STAT_DEF_ID ( CHAR(8) ) which is also
one of the four unique constraints for that table. I am able to select my
rows into an ar
Hello Gurus,
I have a little problem when I bound three variables from bind_param.
I am using union in my sql. I am not sure where the problem comes arises.
The three fields from each table have different names although defined and
contain the same data (CHAR(10),VARCHAR2(40),CHAR(8)) I have TYPE=
Hello all gurus,
I am writing a program that fetches counts for each security type that I
pass to a prepared statement. However I have some interesting/funky stuff
going on with my passing params to prepare and the way it handles it. Could
you please take a look at it and
Ok, thanx a lot, guys
> -Original Message-
> From: William R. Mussatto [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, September 12, 2002 1:35 PM
> To: Hardy Merrill
> Cc: Brian McCain; Rozengurtel, Daniel; [EMAIL PROTECTED]
> Subject: Re: "fetchrow_hashr
Hello All,
I have a question about return code from execute statement using
"fetchrow_hashref".
I need to know if my execute returned anything at all before I start looping
thru the hash.
In the specs it says:
Perform whatever processing is necessary to execute the prepared statement.
An undef
rameter that specifies `ora_type' as `ORA_RSET'. If
> you
> don't do that you'll get an error from the `execute()' like: "ORA-06550:
> line X, column Y: PLS-00306: wrong number or types of arguments in call
> to
> ...".
>
> ---
n 4:
PLS-00306: wrong number or types of arguments in call to
'OPEN_INCOME_EVENTS'
ORA-06550: line 3, column 4:
PL/SQL: Statement ignored (DBD ERROR: OCIStmtExecute) at package_call.pl
line 116.
Thanx to all of you .
daniel
> -Original Message-
> From: Fox, Michael [SMTP
Hello All,
i am trying to select a big chunk of data to archive it into a flat file.
Its a " select * " query which normally returns 1,200,000 records.
1. Is there anything in DBI/DBD that I can use to do the job without
selecting first and then storing it?
2. which method in DBI/DBD should I tr
Hello to all,
I am struggling with creating the prepared statement, passing to it a
placeholder param, and then executing in "execute " statement.
It seems not to be working. Can you please give me a suggestion/fix to my
problem.
Thanx a lot,
Daniel
PS: What am I doing wrong???
Oh. I use DBI v
Hi All.
Please people can you respond to my previous posting? Its a prod problem and
i would really like to get going.
Thanx a lot.
Danny
> -Original Message-
> From: Rozengurtel, Daniel
> Sent: Wednesday, January 09, 2002 9:52 AM
> To: '[EMAIL PROTECTED]'
&g
Hello friends,
I have a problem with DBI.pm module running on Sun5.8. While using
selectall_hashref i get this strange error. I am 100% sure the table to
select from does exist. And that the same statement works on our dev machine
(which is Sun5.6) We also descovered that there is a diference in
Hello all,
I am using DBD-Oracle-1.06 and DBI-1.15 modules on SunOS 5.8 While
executing a perl script that used to work fine on dev machine i am getting
this error:
$ select_infopump_completion.pl
You must install a Solaris patch to run this version of the Java runtime.
Please see the README a
hello,
while installing the DBI , my SA got this error
Any ideas y?
Thanx Daniel
]# make
gcc -c -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC
-I/usr/local/lib/perl5/5.6.1/sun4-solaris/CORE -Wall -Wno-com
Hello all
I am trying to delete from a large table (about 500,000 recs). This
procedure has to take place twice a month, on a specific day. So for that
purpose I have this sql:
$sql = "DELETE FROM ft_t_ispc WHERE LAST_CHG_TMS <
TO_DATE('$final_date','MM/DD/')";
my $rc = $dbh->do("$sql");
H
Hello all
My friend is planing to write an application which will need to have a small
DataBase access. I suppose its going to be either Access or Excell. Can
anybody suggest of any DBI/DBD modules/pre-installs that he could use for
this purpose.
Thanx a lot
__
Hello people
I am trying to run a perl script that has this command
my $rows_inserted = $dbh->do("INSERT INTO CMO_MONDAY values ('$record[13]',
'$record[6]', '$record[26]', '$record[33]', '$record[74]', '$record[76]',
'$record[84]', '$record[86]', sysdate, '$file')") || die $dbh->errstr;
However
Thanx people, that really helped :)
Glad on that list
> -Original Message-
> From: Rozengurtel, Daniel
> Sent: Monday, October 08, 2001 5:16 PM
> To: '[EMAIL PROTECTED]'
> Subject: Insert
>
> Hello people,
>
> I am having hard time inser
Hello people,
I am having hard time inserting something into my table. This is what i do:
my $rows_inserted = $dbh->do(q{
INSERT INTO CMO_MONDAY values ($record[13], 'ttt', 'sss', 'sss',
'sss', 'sss', 'sss', 'sss', sysdate, 'sss')
}) || die $dbh->errst
Hello,
I am executing a query that in some cases dont have an entry for the
instrument_id I am using to retrieve by. I.e there is no physically record
in there (NVL wouldnt work).
This is a peice of code i am struggking with:
undef $ticker;
$sql="SELECT SUBSTR(ISS_ID,1, INSTR(ISS_ID,' ',1
Hello all,
I am trying to retrieve a record that may/maynot have a null value in it.
this is what i am doing, however there its not really working. I can feel
there is a simpler way of doing it, but unfortunately i am clueless in that
sense. Can anybody make sense out of it???
Thanx a lot.
PS:
Hi all,
I am trying to pass several values to a store proc, as Ilya sugested
I am using bind_param
however, right i am able to pass only one arg to a proc. Do you
have any idea how to make it happen wtih more than one ?
Thats what I am using:
my $csr = $db
Hello people.
Does anybody know how to retrieve a single value from a DB?
EX: select ID from my_table where my_key='12345';
I have used a :selectrow_array() but its not a good idea to instantiate an
array for retrieving only one value.
Thanx Dan
Daniel Rozengurtel
Analyst II -Data Mining/WHSE
Hello,
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)?
Thank you
Daniel Rozengurtel
Analyst
Hello Ilya,
I am wondering why am I using all the methods from DBI module to retrieve
the info or manipulate it instead of using DBD::Oracle which i also
installed succesefully? I guess I install DBD in order to use it? However
every resourse on the net that i found heavely relies on DBI functiona
Hello everybody
I am installing the DBD::Oracle onto SunSolaris.
While installing I get this messages:
Evaluating `cat $(LIBHOME)sysliblist`
expanded `cat /db01/app/oracle/product/8.1.6/lib/sysliblist`
returned '-lnsl -lsocket -lgen -ldl -lsched'
Died at Make
Hello Kevin
my name is Daniel and I am looking for help with the issue of installing the
DBD::Oracle onto SunSolaris.
While installing I get this messages:
Evaluating `cat $(LIBHOME)sysliblist`
expanded `cat /db01/app/oracle/product/8.1.6/lib/sysliblist`
returned '-lns
38 matches
Mail list logo