Re: IN in WHERE-clause is not being parsed correctly using SQL::Statement

2020-05-12 Thread Jens Rehsack
an-c...@virtu.com?subject=Unsubscribe%20request>. Please note that > we may not be able to accommodate this request for existing clients, where > Virtu is required under securities laws or any other applicable regulations > to send certain electronic communications related to your account. > -- Jens Rehsack - rehs...@gmail.com signature.asc Description: Message signed with OpenPGP

Re: Wrt. [DBD-AnyData] Repository cleanup (#1)

2020-02-12 Thread Jens Rehsack
ain that a bit? DBD::AnyData is there if anyone has old software which needs the old module with the old API sing with old perl and old DBI. > -Nigel > > On 11/2/20, 11:45, "Jens Rehsack" wrote: > >Hi Olivier, > > >wrt. https://github.com/rehsack/D

Wrt. [DBD-AnyData] Repository cleanup (#1)

2020-02-11 Thread Jens Rehsack
er than 2012) - and likely even before then ;) IIRC, it is marked deprecated on CPAN. Best regards -- Jens Rehsack - rehs...@gmail.com signature.asc Description: Message signed with OpenPGP

Re: perl issue

2019-06-09 Thread Jens Rehsack
or_perl/auto/DBD/Pg/Pg.so' for module > DBD::Pg: libpq.so.5: cannot open shared > object file: No such file or directory at /usr/lib64/perl5/DynaLoader.pm line > 190. > at /loader/0x1623548/pgBackRest/Db.pm line 10. > at /loader/0x1623548/pgBackRest/Main.pm line 12. > pgBackRest::Main::ANON('Can't load > '/usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so...') called at /usr > /share/perl5/vendor_perl/Carp.pm line 100 > Carp::croak('Can't load '/usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so...') > called at /usr/lib64/perl5/Dy > naLoader.pm line 98 > DynaLoader::croak('Can't load > '/usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so...') called at /usr/lib64/pe > rl5/DynaLoader.pm line 190 > DynaLoader::bootstrap('DBD::Pg', 'version=HASH(0x1f9a938)') called at > /usr/lib64/perl5/vendor_perl/DBD/Pg.pm > line 73 > > > -- > > > > Thanks, > Prakash.R > PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : > +91-8939599426 -- Jens Rehsack - rehs...@gmail.com signature.asc Description: Message signed with OpenPGP

Released SQL::Statement 1.407

2015-05-26 Thread Jens Rehsack
rovements] * reduce blocks and rewrite some inner statements to increase speed of sql command processing Best regards -- Jens Rehsack - rehs...@gmail.com

SQL-Statement 1.406_001 dev-release out for testing

2015-05-20 Thread Jens Rehsack
ek when no regressions are introduced. Cheers -- Jens Rehsack - rehs...@gmail.com

Re: Here is a classic one for you

2015-01-04 Thread Jens Rehsack
rib/lib/perl5/site_perl/5.18.2/i386-bsdos/auto/DBI/DBI.so`? >>> What else is not correct? >>> >>> How do I do a debug on this? http://www.lmgtfy.com/?q=Can%27t+locate+object+method+%22bootstrap%22+via+package Cheers -- Jens Rehsack rehs...@gmail.com

Re: Escaping placeholders

2014-12-22 Thread Jens Rehsack
l? > > That's a good question. I'm not sure. I think the answer has to be no. > I'd welcome any input on that. We have a dictum (translated word by word ...): One can't even think as foolish as it sometimes happens. When escaping is specified, escaping the escape character itself should be mandatory - just for being complete and do not ask for future trouble. Of course - outside of quotes only. Cheers -- Jens Rehsack rehs...@gmail.com

Re: DBI - DBD - mysql on Yosemite

2014-10-29 Thread Jens Rehsack
Hi Michael, please keep dbi-users@ in cc ;) Am 29.10.2014 um 14:37 schrieb Michael Ahrweiler : > Hi > >> Am 29.10.2014 um 10:49 schrieb Jens Rehsack : >> Am 28.10.2014 um 17:45 schrieb Michael Ahrweiler : >> >>> Hello >> Hi Michael, >> >>

Re: DBI - DBD - mysql on Yosemite

2014-10-29 Thread Jens Rehsack
better but… > - with installing oder version of DBI and DBD (with the same error in make > test) > > I am out of „ideas“. > Is this a yosemite thing? For instance harder sandbox something? > > Any ideas ? Not enough information (at least for me)... Makes me fear updating to Yosemite ^^ > Is there a path ? There is always a path - but what dedicated path are you looking for? Cheers -- Jens Rehsack rehs...@gmail.com

Fwd: SQL:Statement/Parser

2014-09-10 Thread Jens Rehsack
t be found on unbless > object. > > I will appreciate too much, any information about this error that was taken > from CPAN documentation of this module. -- Jens Rehsack rehs...@gmail.com

Re: SQL Parser

2014-05-03 Thread Jens Rehsack
), or - when just parsing is required - check what ribasushi has in his portfolio. IIRC, he has several SQL parsing packages which are much more advanced than SQL::Parser. Best regards and good luck -- Jens Rehsack pkgsrc, Perl5 rehs...@cpan.org cpanid: REHSACK

Re: I have a weird issue with a script running under cron

2014-02-18 Thread Jens Rehsack
ly. > > This is a fairly lengthy script that hits tables in use during working hours, > yet depends on remote databases not available to me most of the nights, so it > may take a few days to work through checking stuff since I only have about > two hours a day when I can actually ru

Re: I have a weird issue with a script running under cron

2014-02-17 Thread Jens Rehsack
n.pl > > These are the correct values. > > So what am I missing? try an ldd on /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so and any dependent library beside standard library paths to see what might be missing. Optionally a locate for libocci.so.11.1 might be helpful. Cheers -- Jens Rehsack rehs...@gmail.com

Re: A question about DBI

2013-09-11 Thread Jens Rehsack
nges since DBI 1.49, also for SQL::Statement since 1.405. > Can anyone comment about which is the real issue? With the files I’m > querying all over the place, putting chdir’s all over my code isn’t really a > good option. > > Curtis Leach > Lead Engineer > RMS IT & ERM IT > Phone: (702) 494-4562 > > > > Cheers -- Jens Rehsack pkgsrc, Perl5 rehs...@cpan.org

Announcing DBI-Test 0.001

2013-08-06 Thread Jens Rehsack
Hi, hereby I proudly announce DBI::Test-0.001. It's ready to be used for converting DBD tests as well as create generic basic DBI test. Cheers -- Jens Rehsack pkgsrc, Perl5 rehs...@cpan.org

Re: cross database queries?

2013-06-26 Thread Jens Rehsack
s, that's something S::S can't do out of the box. But it could do, I have a version of DBD::Sys where during open_table() the query is send against the data-sources and first fetch_row() synchronized the results of the appropriate queries. Cheers -- Jens Rehsack

Re: cross database queries?

2013-06-26 Thread Jens Rehsack
based SQL engine and I can confirm that it's highly unoptimized regarding mass data ... Cheers -- Jens Rehsack

Re: Relevance of ChildHandles

2013-05-08 Thread Jens Rehsack
hey measure and finally one company really does). Sorry for complaining ;) Cheers -- Jens Rehsack

Re: Issues installing DBD::Teradata on AIX server

2013-04-30 Thread Jens Rehsack
les before running * Makefile.PL. * *** Memory fault(coredump) You should probably trace where it crashes - and you should NEVER run Makefile.PL as root. Thanks in advance ' welcome Cheers -- Jens Rehsack

Re: Building DBD-Oracle on MacOS 10.8 with instantclient_11_2

2013-04-01 Thread Jens Rehsack
/perl.dbi.users/ and a web-search will point to that message and increase your fame and karma. Thank you very much -- Jens Rehsack

SQL::Statement 1.402 uploaded

2012-12-22 Thread Jens Rehsack
gex to t/06virtual.t) The bug described in RT#81523 might result in invalid (outdated) data return from SQL::Statement. Upgrading is strongly recommended. Cheers -- Jens Rehsack

Fwd: SQL::Statement (SQL-Statement-1.402_002)

2012-12-19 Thread Jens Rehsack
Original Message Subject:SQL::Statement (SQL-Statement-1.402_002) Date: Wed, 19 Dec 2012 15:53:31 +0100 From: Thomas Binder To: rehs...@cpan.org Hi there, I have a little problem with SQL-Statement. I installed it on two different systems (Linux+Windows)

Re: DBD::CSV on MacOSX Lion using cpanm fails to $r->fetch in t/50_chopblanks.t line 41

2012-12-04 Thread Jens Rehsack
On 30.11.12 09:49, Allen van der Ross wrote: Hi Jens, Hi Allen, am I allowed to ask why you're writing to my NetBSD.org address instead of my CPAN address? At first I looked for a mistake I made last DBI/DBD::* update for pkgsrc ;) I've installed all the prerequisites, Congrats ;) but

Re: DBD::CSV and skip_first_line

2012-11-25 Thread Jens Rehsack
plicates matters) Is there any way to ensure that despite col_names being set, I can still force skip_first_line => 1 ? or should I report this as a possible edge-case bug There should be, and it is likely that this case is already fixed in the current development state of DBD::CSV by the v

SQL::Statement 1.401 is out

2012-11-01 Thread Jens Rehsack
Hi, hereby I announce the SQL::Statement 1.401 release containing following changes: Version 1.401, released October 29, 2012 - [Misc] * Switch to 3-digited minor version [Bug fixes] * undo literal replaces in subqueries before passing them to the

Re: error: software package not installed

2012-10-19 Thread Jens Rehsack
2012/10/16 John R Pierce : > On 10/15/12 2:15 AM, Darvesh Kumar wrote: >> >> plz give me solution for this problem, log installation is given below- > > > install Oracle Studio (assuming this is Solaris). or read about CPAN on > Solaris Perl and using GCC, here... > http://search.cpan.org/~jesse/p

Re: dbd-anydata v0.09 on windows - INSERT doesnt add new records

2012-05-11 Thread Jens Rehsack
On 11.05.2012 02:07, Greg Aiken wrote: > dear jeff and jens, > > i found your wonderful dbd-anydata module and installed it to my windows > activeperl 5.8.8 build 820 environment (on Windows XP 32 bit) Probably you should install a more recent version of DBD::AnyData. As I can see in CPAN (http:/

Fwd: questions about SQL::Statement

2012-03-20 Thread Jens Rehsack
Original-Nachricht Betreff: questions about SQL::Statement Datum: Mon, 19 Mar 2012 16:59:46 -0400 Von: Philip Goetz An: rehs...@cpan.org The module SQL::Statement doesn't work as your documentation describes. There is no column_defs function defined. There is a 'columns' funct

Re: SQL::Statement - how easy to subclass?

2012-03-16 Thread Jens Rehsack
Am 16.03.2012 01:50, schrieb David Muir Sharnoff: > Hi. Hi, > I want to build a SQL query translater for my OOPS module. I want users reading the support section of the modules they use or a business support contract when they want private or special support. > I need an SQL parser for that I c

Fwd: Problem to get UTF8-CSV-File

2011-12-22 Thread Jens Rehsack
-- Weitergeleitete Nachricht -- Von: Ralf Eiteljörge Datum: 21. Dezember 2011 14:06 Betreff: Problem to get UTF8-CSV-File An: rehs...@cpan.org Hallo, We have a problem. We want to get an UTF8-CSV-File from UTF8-Oracle-Database. It seems to be that the CSV-File is always charset

Re: How to detect if a table exists, with DBD::DBM

2011-04-04 Thread Jens Rehsack
2011/4/4 David McMath : > On 04/03/2011 06:18 AM, Jens Rehsack wrote: >> >> On 04/01/11 17:15, David McMath wrote: >>> >>> Dear List, >> >> Hi David, >> >> I quick reply now without taking a look into the details of the >> implemen

Re: How to detect if a table exists, with DBD::DBM

2011-04-03 Thread Jens Rehsack
On 04/01/11 17:15, David McMath wrote: Dear List, Hi David, I quick reply now without taking a look into the details of the implementation to prevent that I forget you (I'm currently busy with other tasks ...). The short version of my question is: Using DBD::DBM, is there a simple way to t

Re: DBI Layer documentation

2010-10-11 Thread Jens Rehsack
> Ankur Kumar > Intern, SMAI Dev. > NetApp, Bangalore > > -Original Message- > From: Jens Rehsack [mailto:rehs...@googlemail.com] > Sent: Thursday, October 07, 2010 3:56 PM > To: Kumar, Ankur > Cc: dbi-users@perl.org > Subject: Re: DBI Layer documentation > > 2010/

Re: FW: DBI 1.6.15 problem on AIX 6.1 with perl 5.8.8 64bit

2010-10-11 Thread Jens Rehsack
s up to date (1.0303). > YAML is up to date (0.72). > Parse::CPAN::Meta is up to date (1.40). > Text::Glob is up to date (0.08). > CPAN is up to date (1.9402). > File::Which is up to date (1.09). > > > Thanks, Mike > > -Original Message- > From: Jens Rehsac

Re: FW: DBI 1.6.15 problem on AIX 6.1 with perl 5.8.8 64bit

2010-10-08 Thread Jens Rehsack
On 10/08/10 14:57, Martin J. Evans wrote: On 08/10/10 15:25, Hatala, Michael wrote: I don't have the prove command with this perl 5.8.8 64bit release. I'm assuming it's a byproduct of the perl installation(?) It is in Test::Harness which you already have but perhaps not new enough. On my Linux

Re: FW: DBI 1.6.15 problem on AIX 6.1 with perl 5.8.8 64bit

2010-10-08 Thread Jens Rehsack
2010/10/8 Hatala, Michael : > Well I can't send a zip so here is my error in the tests and the perl > -V. I'm pretty much stuck at this point and need some direction. > > t/zvxgnp_51dbm_file.t .. > ok 1 - drop table > ok 2 - FRED.dir exists > ok 3 - fred.dir exists > Dubious, test returned -1 (

Re: DBI Layer documentation

2010-10-07 Thread Jens Rehsack
2010/10/7 Kumar, Ankur : > Hello, > > I am working with C in front end and Sybase in backend. I have been > asked to understand and modify a piece of code which uses DBI layer for > running queries on Sybase entries. > > I am not able to understand the DBI layer implementation in the code. > Please

Re: anti-join with SQL::Statement?

2010-10-07 Thread Jens Rehsack
2010/10/4 Reinier Post : > On Mon, Oct 04, 2010 at 11:12:05AM -0700, Darren Duncan wrote: >> Reiner, I don't know if this was your workaround, but here's another >> solution that just uses SQL::Statement ... >> >> Ludwig, Michael wrote: >> >>So the next thing I tried was the anti-join (see >> >> >>

Re: DBI and DBD Installation on Different Unix (Solaris, AIX, HP and Linux)

2010-08-06 Thread Jens Rehsack
On 08/06/10 08:05, Satish Bora wrote: Hello, Hello Satish, I am asking a very basic question here. You do not follow the guide how to ask questions as preferred in DBI documentation. Is there any standard instruction set which can guarantee the successful installation of DBI and DBD on

[ANNOUNCE] DBD-Sys-0.100 and DBD-Sys-0.101

2010-07-25 Thread Jens Rehsack
Hi, I'm glad to announce new versions of DBD::Sys: - the release with heavy plug-in structure reworking (0.100) and - the release with a test fix (0.101). I would be happy to read about feedback and successful uses. Best regards, Jens -- Changes since initial 0.01 release: 0.101 2010-07-25

[ANNOUNCE] SQL::Statement 1.28

2010-07-16 Thread Jens Rehsack
Hi all, I'm proud to announce SQL::Statement 1.28. It's the first release for me where other DBI developers (Matin Evans, H. Merijn Brand) actively contributed patches and do their own commits. Thanks for that! To all users of SQL::Statement or Meta-DBD's: Please take care when updating SQL::St

Re: Building 32-Bit ONLY Perl on Mac OSX

2010-06-16 Thread Jens Rehsack
On 06/15/10 21:25, Michael Nhan wrote: Hi, You are trying to build 32bit application on a 64bit osx. You will need to tell both the compiler and the linker that you want to build 32bit apps. Gcc is easy enough with the -m32 flag. ld is a little trickier. On linux, I have to link using "ld -melf_

Re: Building 32-Bit ONLY Perl on Mac OSX

2010-06-15 Thread Jens Rehsack
9-541-71008-0   Fax +49-541-71008-499 > http://www.bill-X.de    schwerm...@bill-x.de > > > > From:        Jens Rehsack > To:        kai.schwerm...@bill-x.de > Cc:        dbi-us...@perl.org > Date:        15.06.2010 22:53 > Subject:        Re: Building 32-Bit ONLY Perl on

Re: Building 32-Bit ONLY Perl on Mac OSX

2010-06-15 Thread Jens Rehsack
2010/6/15 : > Hi DBI-Users, > > my question isn't directly related to DBI, but i need to compile a 386/32 > Bit ONLY Perl Binary on Mac OSX 10.6 (SnowLeopard), > not only but also because we only have a 32 Bit Oracle Instant Client... > > No Matter what Config-Params i tried, the only thing i get

Re: Perl coredump when using ora_dbh_share to connect to Oracle DB's

2010-04-01 Thread Jens Rehsack
2010/4/1 John Scoles : >> Date: Wed, 31 Mar 2010 16:31:11 +0200 >> Subject: Perl coredump when using ora_dbh_share to connect to Oracle DB's >> From: rehs...@googlemail.com >> To: dbi-users@perl.org; pa...@pythian.com >> CC: karl.li...@lisse.it >> >> Hi all, >> >> I get a core dump when using attac

Re: Perl coredump when using ora_dbh_share to connect to Oracle DB's

2010-04-01 Thread Jens Rehsack
2010/4/1 Wesley Schwengle : > On 01.04.10 03:02 John Scoles wrote: > >> Hard to say exatly are you sure you are connecting to oracle corretly?? >> >> use DBI; >> >> my $dsn = 'DBI:Oracle:host=localhost;port=1527;sid=XXX'; >> >> is a rather odd dsn > > I always the the method above, although I don't

Perl coredump when using ora_dbh_share to connect to Oracle DB's

2010-03-31 Thread Jens Rehsack
Hi all, I get a core dump when using attached script to connect to an Oracle DB. Anyone here having a hint what's going wrong? I need this (probably) to get Log::Log4perl::Appender::DBI run fine in a multithreaded environment. Best regards and thanks in advance, Jens orathreads.pl Description:

Antwort: Re: Next patch for SQL::Statement

2007-10-13 Thread jens . rehsack
or the moment but if you give me several weeks to fix it, I'll get it up and running before christmas ;) Freundliche Grüße / Best Regards Jens Rehsack _ Fa. Manß & Partner Phone: +49 - 214 - 30 - 46 193 Fax: +49 - 214 - 30 - 31 625 E-mail

Next patch for SQL::Statement

2007-10-11 Thread jens . rehsack
in the perl-dbi mailing list (I googled before writing the patch on my onw ;-)) so duplicate work may avoided. Best Regards Jens Rehsack patch-SQL_Statement Description: Binary data

2nd Patch for SQL::Statement

2007-09-17 Thread jens . rehsack
rce. It's very painful to edit, because sometimes are TAB's used, sometimes blanks, no consistent indent etc. `perltidy -gnu` or `perltidy -toc` would allow me to stop wasting time to reformat the source when editing around to program sth. and format back whe