Re: Install Issues With PERL Informix::DBD On HPUX
Dear Cory, On Mar 31, 2005 9:51 AM, Cory Cox [EMAIL PROTECTED] wrote: Basically we are trying to establish a database connection from an HPUX box running on a network. Our database server is remote on another HPUX box. We have Perl 5.8.6 installed with all the current DBI and DBD modules. We also have an SDK client installed as well. When we try to install the DBD module we get the following error: Oh Dear, Cory, /usr/include/machine/sys/sigcontext.h .. /usr/local/lib/gcc/hppa2.0w-hp-hpux11.11/3.4.2/include/pwd.h .. /usr/include/errno.h ... /usr/include/sys/errno.h . /usr/local/lib/gcc/hppa2.0w-hp-hpux11.11/3.4.2/include/string.h .. /usr/include/sys/_null.h . esqlperl.h .. ixblob.h Failed to compile esqltest.ec to esqltest.o Has anyone run into this before and does anyone have an suggestions? Thanks, Cory Cory Cox Werner Enterprises Analysis and Information Systems 1-800-228-2240 ext 2695 Please read the README file for information on, amongst other things, how to report problems with DBD::Informix. There is a lot of information that is requested - you have a Class A failure (failed to compile esqltest); see Notes/bug.reports as mentioned in the README file. I need to know: * Version of Perl (5.8.6) * Version of DBI (1. 48 - you said current) * Version of DBD::Informix (2005.01 - you said current) * Version of CSDK or ESQL/C (e.g. 2.90.FC1 - the letters and numbers can be important) * Version of IDS (or SE, XPS, OnLine) - though that is not going to material this time. * Hardware platform (HP-UX, probably PA-RISC rather than Itanium, 32-bit or 64-bit). * O/S Version. * Which C compiler you're using - version number * Output of 'perl -V' * Did you build this perl or is it one supplied with the o/s. * Did you build this perl on this machine. * Output of 'perl Makefile.PL'. * Have you built any programs with the CSDK you have installed? * What happened when you tried to build esqlbasic as directed in the README file? There might be some benefit to running with DBD_INFORMIX_DEBUG_ESQLTEST=yes set in the environment since your failure occurs during the build of esqltest. With some - preferably most - of that information, we can start trying to help you. Note that there is a tool to help with accumulating the information; read the README file! -- Jonathan Leffler [EMAIL PROTECTED] #include disclaimer.h Guardian of DBD::Informix - v2005.01 - http://dbi.perl.org I don't suffer from insanity - I enjoy every minute of it.
Re: DBD::CSV much slower on osX ?
On Wed, Feb 16, 2005 at 09:44:08AM -0800, Jeff Zucker wrote :
[EMAIL PROTECTED] wrote:
Total Elapsed Time = 63.19465 Seconds
User+System Time = 43.46465 Seconds
Exclusive Times
%Time ExclSec CumulS #Calls sec/call Csec/c Name
66.5 28.91 36.463 109445 0.0003 0.0003 SQL::Statement::eval_where
I'm the maintainer of DBD::CSV and while I don't have time this week to
get into this, I am following the conversation and will certainly
eventually revise the module if any useful information is discovered.
Sorry for wasting your time with my problems, but since I
changed the i386 computer, I can not reproduce the speed difference
anymore. And I do not have access anymore to this computer where the
query was running faster to double-check wether everything is exactly
the same than on the new one.
As I had better to spend my time on analysing some data with
my script rather than analysing the script itself, I eventually
swiched to DBI::SQLite, which solved my problem by performing the
query in a few seconds.
The query was something like :
$query = SELECT * FROM $db_table WHERE SYMBOL1 LIKE \'%${Search}%\' OR
SYMBOL2 LIKE \'%${Search}%\' ;
my $sth = $dbh-prepare($query);
$sth-execute;
(actually CLIKE, before the transition)
You may wonder the purpose of this mail, as there is no new
crucial information. The reason is that I do not like not knowing the
end of the story when I browse archived threads.
Anyway, many thanks to all that tried to help me.
--
Charles
DBD-DB2 Error
Hi, Saw the problem you have raised in dbi-users regarding DBD::DB2 - What components of the DB2 Application Development Client are essential? Have you solved the problem? Can you help us as we are also facing the same problem as shown below. Machine1:/perl/DBD-DB2-0.78make cc -c -I/db2admin/sqllib/include -I/usr/local/lib/perl5/site_perl/5.8.6/aix/auto/DBI -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOU RCE -qmaxmem=-1 -qnoansialias -DUSE_NATIVE_DLOPEN -q32 -D_LARGE_FILES -qlonglong -O-DVERSION=\0.78\ -DXS_VERSION=\0.78\ -I/usr/local/lib/pe rl5/5.8.6/aix/CORE DB2.c DB2.h, line 9.10: 1506-296 (S) #include file sqlcli.h not found. DB2.h, line 11.10: 1506-296 (S) #include file sqlcli1.h not found. DB2.h, line 12.10: 1506-296 (S) #include file sqlext.h not found. DB2.h, line 14.10: 1506-296 (S) #include file sqlstate.h not found. dbdimp.h, line 16.3: 1506-046 (S) Syntax error. dbdimp.h, line 24.3: 1506-046 (S) Syntax error. dbdimp.h, line 33.3: 1506-046 (S) Syntax error. dbdimp.h, line 63.3: 1506-046 (S) Syntax error. dbdimp.h, line 75.3: 1506-046 (S) Syntax error. dbdimp.h, line 86.3: 1506-046 (S) Syntax error. dbdimp.h, line 90.3: 1506-046 (S) Syntax error. dbdimp.h, line 95.1: 1506-166 (S) Definition of function SQLCHAR requires parentheses. DB2.xs, line 40.9: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 57.14: 1506-196 (W) Initialization between types struct av* and int is not allowed. DB2.xs, line 79.5: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 90.5: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 99.5: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 108.5: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 138.5: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 151.5: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 152.17: 1506-196 (W) Initialization between types struct sv* and int is not allowed. DB2.xs, line 162.5: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 228.7: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 229.14: 1506-196 (W) Initialization between types struct sv* and int is not allowed. DB2.xs, line 250.5: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 260.5: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 273.5: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 302.5: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 330.5: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 379.5: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 380.12: 1506-196 (W) Initialization between types struct av* and int is not allowed. DB2.xs, line 390.5: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 391.12: 1506-196 (W) Initialization between types struct av* and int is not allowed. DB2.xs, line 405.5: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 430.5: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 445.5: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 459.5: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 460.17: 1506-196 (W) Initialization between types struct sv* and int is not allowed. DB2.xs, line 470.5: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 502.7: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 517.7: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 538.7: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 555.7: 1506-045 (S) Undeclared identifier dbis. DB2.xs, line 565.7: 1506-045 (S) Undeclared identifier dbis. DB2.c, line 937.47: 1506-045 (S) Undeclared identifier XS_DBD__DB2__dr_disconnect_all. DB2.xs, line 22.5: 1506-045 (S) Undeclared identifier dbis. make: 1254-004 The error code from the last command is 1. Regards Manoj B. Tata Consultancy Services Limited Mailto: [EMAIL PROTECTED] Website: http://www.tcs.com Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you
DBD::Pg for Windows
Does anyone know if (and where) there is a DBD::Pg compiled as a PPD for Windows? I do not have a compiler and I want to try out Pg instead of MySQL for a project. Learning experience for me. Robert
RE: :Pg for Windows
Why not install the free Windows SQL Server Express 2005? http://lab.msdn.microsoft.com/express/sql/ With features: http://lab.msdn.microsoft.com/express/sql/Features/default.aspx There is a SQL2000 version somewhere also that is a full fledged server only limited to 20 connections at a time. I installed it on my laptop and it works fine. James -Original Message- From: Robert [mailto:[EMAIL PROTECTED] Sent: Friday, April 01, 2005 9:06 AM To: dbi-users@perl.org Subject: DBD::Pg for Windows Does anyone know if (and where) there is a DBD::Pg compiled as a PPD for Windows? I do not have a compiler and I want to try out Pg instead of MySQL for a project. Learning experience for me. Robert
RE: string help!
From: Michael Peppler [EMAIL PROTECTED] Date: 2005/03/31 Thu PM 11:29:58 CST Placeholders in Sybase are well supported, with the notable exceptions that you can't use them for TEXT or IMAGE (i.e. BLOB) columns/parameters. Yep, I use placeholders to insert the row, minus the TEXT column, then update the row to get the TEXT data in. Just like Michael told me to. Thanks, Michael... Michael amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|
RE: :Pg for Windows
From: Moosmann, James [EMAIL PROTECTED] Date: 2005/04/01 Fri AM 08:45:15 CST From: Robert [mailto:[EMAIL PROTECTED] Sent: Friday, April 01, 2005 9:06 AM Does anyone know if (and where) there is a DBD::Pg compiled as a PPD for Windows? I do not have a compiler and I want to try out Pg instead of MySQL for a project. Learning experience for me. Robert Why not install the free Windows SQL Server Express 2005? http://lab.msdn.microsoft.com/express/sql/ James Yeah, and while you're at it, sign up at oracle.com/start for a free copy of 10g. I mean, you know, since we're telling you what database to use, instead of answering your question... amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|
RE: :Pg for Windows
From: Robert [mailto:[EMAIL PROTECTED] Sent: Friday, April 01, 2005 9:06 AM Does anyone know if (and where) there is a DBD::Pg compiled as a PPD for Windows? I do not have a compiler and I want to try out Pg instead of MySQL for a project. Learning experience for me. WARNING: You should never trust compiled software from non-trusted sources. Even though the source below seems straight-up, I don't know him, and chances are, you don't either. You really should get an old copy of VC6 from eBay and do your own compiling... I found this: http://www.soulcage.net/ppds/ via this: http://www.issociate.de/board/post/149171/DBD-Pg_for_Perl_5.8.4_Build_810.html which was the 6th result in this: http://www.google.com/search?hl=enq=%22dbd%3A%3Apg%22+ppd Robert HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|
Re: DBD-DB2 Error
Score 1 for Google Gmail: On Apr 1, 2005 12:11 AM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi, Saw the problem you have raised in dbi-users regarding DBD::DB2 - What components of the DB2 Application Development Client are essential? Have you solved the problem? Can you help us as we are also facing the same problem as shown below. Machine1:/perl/DBD-DB2-0.78make cc -c -I/db2admin/sqllib/include -I/usr/local/lib/perl5/site_perl/5.8.6/aix/auto/DBI -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOU RCE -qmaxmem=-1 -qnoansialias -DUSE_NATIVE_DLOPEN -q32 -D_LARGE_FILES -qlonglong -O-DVERSION=\0.78\ -DXS_VERSION=\0.78\ -I/usr/local/lib/pe rl5/5.8.6/aix/CORE DB2.c DB2.h, line 9.10: 1506-296 (S) #include file sqlcli.h not found. DB2.h, line 11.10: 1506-296 (S) #include file sqlcli1.h not found. DB2.h, line 12.10: 1506-296 (S) #include file sqlext.h not found. DB2.h, line 14.10: 1506-296 (S) #include file sqlstate.h not found. From October 2004: Darin McBride [EMAIL PROTECTED] to dbi-users On October 12, 2004 1:27 pm, Edward Peschko wrote: I'm missing a piece, I guess, in the install of DB2.. I have the libraries, etc. installed in /opt/IBM/db2/V8.1. Did you install the application development tools with DB2? If you have the Application Development Client installed, you have it. Or, if you have any licensed product, you could install it (it's optional). If you have the Runtime Client or the Administration Client products, you will need to get the Application Development Client off the IBM website and install it to get the headers and libraries required for compiling C programs. - Hide quoted text - I'm getting: Constants.xs:16:20: sqlcli.h: No such file or directory Constants.xs:18:21: sqlcli1.h: No such file or directory Constants.xs:19:20: sqlext.h: No such file or directory so... what do I need to download and from where? -- Jonathan Leffler [EMAIL PROTECTED] #include disclaimer.h Guardian of DBD::Informix - v2005.01 - http://dbi.perl.org I don't suffer from insanity - I enjoy every minute of it.
Re: DBD::CSV much slower on osX ?
On Fri, Apr 01, 2005 at 03:09:12PM +0900, Charles Plessy wrote: You may wonder the purpose of this mail, as there is no new crucial information. The reason is that I do not like not knowing the end of the story when I browse archived threads. Thanks Charles. Tim.
Re: DBD::CSV much slower on osX ?
Charles Plessy wrote:
As I had better to spend my time on analysing some data with
my script rather than analysing the script itself, I eventually
swiched to DBI::SQLite, which solved my problem by performing the
query in a few seconds.
There's no question, SQLite is faster than DBD::CSV for most things. If
someone asks me for a recommendation for a database to use and they have large
and or complex data, don't care about the format of the data, and speed is an
issue, I never recommend my own modules :-). I hope you're using mod_perl or
something because connecting to the database is one area where SQLite is
slower. It's also slower for inserts. I'd like to point out also that
SQL::Statement, the underlying engine for DBD::CSV, is undergoing some major
changes and is becoming faster on each benchmark and that the purpose of the
pure perl DBDs like DBD::CSV is to provide access to human readable data,
unconventional datasources, and to provide support for platforms and contexts
where compilation is not an option, not to try to rival the speed of RDBMSs
written in C.
The query was something like :
$query = SELECT * FROM $db_table WHERE SYMBOL1 LIKE \'%${Search}%\' OR SYMBOL2 LIKE \'%${Search}%\' ;
LIKE and CLIKE with wildcards are full text searches and are always
going to be slow relative to other kinds of searches.
You may wonder the purpose of this mail, as there is no new
crucial information. The reason is that I do not like not knowing the
end of the story when I browse archived threads.
Thanks, I appreciate hearing back. Good luck!
--
Jeff
RE: :Pg for Windows
I don't have the binaires for Pg ( easy to google for them ) and he is in the exploratory stage for an alternative to MySQL on Windows so I offered my suggesion. I think the Oracle suggestion is good too. But, I have to say, Amonotod's reply was implying to be rude to me. I think poking in comments like instead of answering your question... is not called for. Some etiquette would go a long way. If you can't be nice and helpful, then don't reply. Why are you here? I would just as soon remove myself from this list if this is to be expected and only Tim and few others should be allowed to comment? -Original Message- From: amonotod [mailto:[EMAIL PROTECTED] Sent: Friday, April 01, 2005 10:00 AM To: dbi-users@perl.org Subject: RE: :Pg for Windows From: Moosmann, James [EMAIL PROTECTED] Date: 2005/04/01 Fri AM 08:45:15 CST From: Robert [mailto:[EMAIL PROTECTED] Sent: Friday, April 01, 2005 9:06 AM Does anyone know if (and where) there is a DBD::Pg compiled as a PPD for Windows? I do not have a compiler and I want to try out Pg instead of MySQL for a project. Learning experience for me. Robert Why not install the free Windows SQL Server Express 2005? http://lab.msdn.microsoft.com/express/sql/ James Yeah, and while you're at it, sign up at oracle.com/start for a free copy of 10g. I mean, you know, since we're telling you what database to use, instead of answering your question... amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|
OT: Apology (WAS: RE: :Pg for Windows)
From: Moosmann, James [EMAIL PROTECTED] Date: 2005/04/01 Fri AM 09:41:25 CST But, I have to say, Amonotod's reply was implying to be rude to me. For that, I apologize... Sincerely. I'll try to refrain from being sarcastic from now on... v/r, amonotod - Please note the all-lower-case name... -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|
Re: :Pg for Windows
James Moosmann [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I don't have the binaires for Pg ( easy to google for them ) and he is in the exploratory stage for an alternative to MySQL on Windows so I offered my suggesion. I think the Oracle suggestion is good too. But, I have to say, Amonotod's reply was implying to be rude to me. I think poking in comments like instead of answering your question... is not called for. Some etiquette would go a long way. If you can't be nice and helpful, then don't reply. Why are you here? I would just as soon remove myself from this list if this is to be expected and only Tim and few others should be allowed to comment? I have Oracle at work and that is what I currently use. I have the potential of picking up a second Perl only job that uses Postrgesql, which is driving my desire to learn it. I have used the Microsoft stuff as well (mostly Access). Thanks for the suggestions...really. Robert -- A little consideration, a little thought for others, makes all the difference. -- Winnie the Pooh
