Re: Installing DBI and DBD::TSM

2005-05-09 Thread Michael A Chase
On 05/09/2005 03:47 PM, De Joe, Jackie said: I have two questions, first do I understand correctly to use DBD::TSM 1.48 I must have DBI installed? You understand correctly. Second, I am having trouble installing DBI. Here's some info: I am very much a newbie at compiling code, any help will be so

Executing Oracle stored procedures

2005-05-09 Thread Kevin Moore
All, I've got Apache v2.x, Oracle 9i, running on Red Hat linux 9, mod_perl, and DBI installed and working. I'd like to be able to execute Oracle stored procedures. Is anyone doing this without the mod_plsql plugin? If so, would you be wlling to share tips for making this work. I've already got

Re: SQL -25507 error trying to build DBD::Informix on linux

2005-05-09 Thread Jonathan Leffler
On 5/9/05, Bruce Lysik <[EMAIL PROTECTED]> wrote: > I'm running into a problem trying to build DBD::Informix on a Redhat ES3 > host, with a > database on a Solaris 9 host. > > Client: RedHat ES3, 2.4.21-15.0.4.ELsmp, perl v5.8.0, Informix > clientsdk.2.90.UC1.LINUX installed. Trying to install

Re: Spreadsheet::WriteExcel question

2005-05-09 Thread Michael A Chase
On 05/09/2005 12:45 PM, Robert said: I am pulling data out of Oracle and putting it into an Excel spreadsheet. Using this: while ( $row = $sth->fetchrow_arrayref ) { # this is a fast and simple way to deal with nulls: foreach (@$row) { $_ = '' unless defined } push (@results, @$row); Th

RE: Spreadsheet::WriteExcel question

2005-05-09 Thread Ian Harisay
This is really off topic. -Original Message- From: Robert [mailto:[EMAIL PROTECTED] Sent: Mon 5/9/2005 1:45 PM To: dbi-users@perl.org Subject: Spreadsheet::WriteExcel question My ignorance is showing. : ) I am pulling data out of Oracle and putting it into an Excel spreadsheet. Using

SQL -25507 error trying to build DBD::Informix on linux

2005-05-09 Thread Bruce Lysik
Hi, I'm running into a problem trying to build DBD::Informix on a Redhat ES3 host, with a database on a Solaris 9 host. Client: RedHat ES3, 2.4.21-15.0.4.ELsmp, perl v5.8.0, Informix clientsdk.2.90.UC1.LINUX installed. Trying to install DBD-Informix-2005.01 Database server: Solaris 9, Inform

Installing DBI and DBD::TSM

2005-05-09 Thread De Joe, Jackie
I have two questions, first do I understand correctly to use DBD::TSM 1.48 I must have DBI installed? Second, I am having trouble installing DBI. Here's some info: I am very much a newbie at compiling code, any help will be so appreciated!! Thanks, Jackie AIX unix 5.2.0.0 chewbacca:/adsm2/per

Re: /usr/bin/ls: 0403-027 The parameter list is too long

2005-05-09 Thread Gregg R. Allen
On May 9, 2005, at 4:16 AM, Vamsi_Doddapaneni wrote: Hi all, Thanks for your help. I am facing a new problem. Here is the code part: Although I don't understand why it's doing that you might have better luck (not to mention better code) if used the Perl "readdir" command. foreach $name(`ls $opt_i

Spreadsheet::WriteExcel question

2005-05-09 Thread Robert
My ignorance is showing. : ) I am pulling data out of Oracle and putting it into an Excel spreadsheet. Using this: while ( $row = $sth->fetchrow_arrayref ) { # this is a fast and simple way to deal with nulls: foreach (@$row) { $_ = '' unless defined } push (@results, @$row); } my

Re: /usr/bin/ls: 0403-027 The parameter list is too long

2005-05-09 Thread Tim
On Mon, May 09, 2005 at 02:52:53PM +0200, Madani, Srikanth, VF-DE wrote: > > BTW, this is slightly OT for the DBI-users list. Very. More than enough kinds folks have answered. Let's close it now. Tim.

SEGV error

2005-05-09 Thread Mark Vaughan
All, While executing CPAN's "install DBD::ODBC" command test #2 fails. Here is the output when run by hand: /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/perl5/5.6.1/sun4-solaris -I/usr/local/lib/perl5/5.6.1 t/02simple.t 1..36 ok 1 - use DBI; ok 2 - use ODBCTEST; DBI 1.48-noth

RE: /usr/bin/ls: 0403-027 The parameter list is too long

2005-05-09 Thread Ian Harisay
Try something like this instead. You should always use native perl calls to get the job done. Also, this isn't something to discuss in the dbi-user list. opendir(DIR, $dirname) or die "can't opendir $dirname: $!"; while (defined($file = readdir(DIR))) { if( -f "$dirname/$file" && "$dirname/$

OT: Re: /usr/bin/ls: 0403-027 The parameter list is too long

2005-05-09 Thread David
On Mon, May 09, 2005 at 03:46:20PM +0530, Vamsi_Doddapaneni wrote: > Here is the code part: > foreach $name(`ls $opt_i/*.xml`){ Change this to: foreach $name (glob("$opt_i/*.xml")) { You can learn more here: $ perldoc -f glob > chomp; > push @f, $name; > print "pushing eleme

RE: Newbie problem connecting to MS SQL Server

2005-05-09 Thread Mark Vaughan
All, I did not get any responses back to my previous message (see below). The other item I found interesting is that the port on the DB box is 4000, even though my freetds.conf says it should be 1433. Am I missing how this is supposed to work. I would appreciate any and all thoughts on this subj

RE: /usr/bin/ls: 0403-027 The parameter list is too long

2005-05-09 Thread Kimball, Conrad
$opt_i expands to some path, then perl calls the shell to run the command "ls some_path/*.xml". The shell then does what shells do, it tries to expand the *.xml pattern into a list of files to construct a command line of the form "ls some_path/file1 some_path/file2 some_path/file3" which it will t

OT - but help here anyway -- was Re: /usr/bin/ls: 0403-027 The parameter list is too long

2005-05-09 Thread Jonathan Leffler
On 5/9/05, Vamsi_Doddapaneni <[EMAIL PROTECTED]> wrote: > I am facing a new problem. > > Here is the code part: > foreach $name(`ls $opt_i/*.xml`){ > chomp; > push @f, $name; > print "pushing elements=$name\n"; > } > [EMAIL PROTECTED]; > > Now in the directory $opt_i if there are

RE: /usr/bin/ls: 0403-027 The parameter list is too long

2005-05-09 Thread Madani, Srikanth, VF-DE
Vamsi_Doddapaneni wrote on Montag, 9. Mai 2005 12:16 > Here is the code part: > foreach $name(`ls $opt_i/*.xml`){ > chomp; > push @f, $name; > print "pushing elements=$name\n"; > } > [EMAIL PROTECTED]; > Now in the directory $opt_i if there are some 10 , 20 or even 100 its > workin

/usr/bin/ls: 0403-027 The parameter list is too long

2005-05-09 Thread Vamsi_Doddapaneni
Hi all, Thanks for your help. I am facing a new problem. Here is the code part: foreach $name(`ls $opt_i/*.xml`){ chomp; push @f, $name; print "pushing elements=$name\n"; } [EMAIL PROTECTED]; Now in the directory $opt_i if there are some 10 , 20 or even 100 its working well. B