RE: Optimization for faster select...

2003-12-13 Thread Rozengurtel, Daniel
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

RE: Optimization for faster select...

2003-12-11 Thread Rozengurtel, Daniel
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

Optimization for faster select...

2003-12-11 Thread Rozengurtel, Daniel
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

Oracle8i vs Oracle 9i and DBI/DBD issues

2003-11-14 Thread Rozengurtel, Daniel
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

Create View with Bind Params

2003-09-29 Thread Rozengurtel, Daniel
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

RE: bind columns behavior

2003-09-09 Thread Rozengurtel, Daniel
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:

RE: bind columns behavior

2003-09-09 Thread Rozengurtel, Daniel
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

bind columns behavior

2003-09-08 Thread Rozengurtel, Daniel
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

Confusion with Char Datasets when Updating Oracle 8.1

2003-08-28 Thread Rozengurtel, Daniel
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

RE: need help on "bind_columns "

2003-03-20 Thread Rozengurtel, Daniel
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,

need help on "bind_columns "

2003-03-20 Thread Rozengurtel, Daniel
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

DBI/DBD

2003-03-19 Thread Rozengurtel, Daniel
> 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

prepare with fetchrow_array

2003-02-20 Thread Rozengurtel, Daniel
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

Bound Vars

2002-12-26 Thread Rozengurtel, Daniel
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=

Prepare misbehavior

2002-12-08 Thread Rozengurtel, Daniel
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

RE: "fetchrow_hashref" Question

2002-09-12 Thread Rozengurtel, Daniel
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

"fetchrow_hashref" Question

2002-09-12 Thread Rozengurtel, Daniel
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

RE: Stored Procs

2002-08-20 Thread Rozengurtel, Daniel
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 > ...". > > ---

RE: Stored Procs

2002-08-19 Thread Rozengurtel, Daniel
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

Big Chunk Of data

2002-04-08 Thread Rozengurtel, Daniel
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

Bind Param and PlaceHolders

2002-02-20 Thread Rozengurtel, Daniel
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

FW: DBI Problem

2002-01-09 Thread Rozengurtel, Daniel
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

DBI Problem

2002-01-09 Thread Rozengurtel, Daniel
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

Java Error

2001-12-11 Thread Rozengurtel, Daniel
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

DBI instalation

2001-11-30 Thread Rozengurtel, Daniel
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

Delete

2001-10-18 Thread Rozengurtel, Daniel
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

Access/Excell DBI

2001-10-17 Thread Rozengurtel, Daniel
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 __

String termination

2001-10-09 Thread Rozengurtel, Daniel
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

FW: Insert

2001-10-08 Thread Rozengurtel, Daniel
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

Insert

2001-10-08 Thread Rozengurtel, Daniel
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

Query tha returns nothing

2001-08-15 Thread Rozengurtel, Daniel
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

NULL VALUE QUERY

2001-08-14 Thread Rozengurtel, Daniel
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:

StoreProc

2001-07-12 Thread Rozengurtel, Daniel
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

Single value

2001-07-11 Thread Rozengurtel, Daniel
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

SELECT

2001-05-10 Thread Rozengurtel, Daniel
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

DBI/ DBD::Oracle

2001-05-01 Thread Rozengurtel, Daniel
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

DBD

2001-04-25 Thread Rozengurtel, Daniel
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

DBD problems

2001-04-25 Thread Rozengurtel, Daniel
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