RE: DBD::mysql next steps

2017-11-13 Thread Curtis Leach
h an error message saying to downgrade DBD::mysql  to a specific release.   It should be fairly strait forward to downgrade DBD::mysql at that point. Curtis Leach  |  Lead EngineerO 702-494-4562   One Harrah's Court | Las Vegas, NV 89119www.caesars.c

RE: perl DBI errors

2014-03-11 Thread Curtis Leach
Sorry to say, but you are into a mini-project to get things working again. From past experience, IBM tends to make a minimalistic version of Perl available to you by default with AIX. So your original error messages were telling you that the modules your program requires are not part of the IB

RE: A question about DBI

2013-09-11 Thread Curtis Leach
pears the "file" alias is still in place. But I'll still fix it so that I won't have an issue the next time I do an upgrade. Thanks again! Curtis -Original Message- From: Jens Rehsack [mailto:rehs...@gmail.com] Sent: Wednesday, September 11, 2013 3:59 AM To: Curtis

A question about DBI

2013-09-10 Thread Curtis Leach
ion where the log file is located, everything works. So I see one of two things being true: 1) "f_dir" is being ignored. 2) There is a problem with how I initialized things. Can anyone comment about which is the real issue? With the files I'm querying al

RE: DBI-616 Build Question for Perl 5.8.2 on AIX 5.3

2011-12-13 Thread Curtis Leach
Does anyone have any idea what these "free unreferenced scalar" messages mean? Are they important as to my having a good build? Looking at the test cases it seems to have something to do with threads. Curtis -Original Message----- From: Curtis Leach [mailto:cle...@caesars.

DBI-616 Build Question for Perl 5.8.2 on AIX 5.3

2011-12-03 Thread Curtis Leach
Guys, I'm building the DBI on AIX and I'm seeing something I'm not sure I like in the test results. I'm using the pre-built perl that comes with AIX 5.3 and IBM's C compiler that was used to build it. To cut down on most of the miscellaneous messages about skipping SQL-Statement, I went an

RE: Tail Module + DBI Module, can\'t keep up!

2011-09-21 Thread Curtis Leach
Here's a way that might speed things up for you considerably by eliminating a DB hit. I'm assuming that your query only returns 1 row and that you are not stepping through them all & just selecting the last one returned. If you are stepping through them, modify your select to only return 1 row. I

RE: Recurse gives me No more handles

2009-01-20 Thread Curtis Leach
That also means that you can reuse that statement handle & only do one prepare if you use placeholders. Since only one execute would be processed at a time. This would also slightly speed up your processing. Curtis -Original Message- From: Martin J. Evans [mailto:martin.ev...@easysoft

RE: A Question about DBD-Informix

2008-07-31 Thread Curtis Leach
Thanks for your insight. We'll see how things go. Curtis From: Jonathan Leffler [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2008 2:42 PM To: Curtis Leach Cc: dbi-users@perl.org Subject: Re: A Question about DBD-Informix On Thu, Jul 31, 2008

A Question about DBD-Informix

2008-07-31 Thread Curtis Leach
I'm running into a problem installing DBD-Informix. I'm running Perl version 5.8.2 on AIX against Informix 10 with the current DBI. The version of the Informix SDK is 2.01, with no option to upgrade since later releases enforce XA compliance and regrettably a lot of our other non-perl code isn't

RE: Generic DBI question about backups

2008-06-20 Thread Curtis Leach
pp still runs. That might in fact make the intermediate CSV representation unnecessary, but as usual there's more than one way to do it. -Will > -Original Message- > From: Curtis Leach [mailto:[EMAIL PROTECTED] > Sent: Thursday 19 June 2008 14:54 > To: [EMAIL PROTECTED] &

RE: Generic DBI question about backups

2008-06-19 Thread Curtis Leach
tempt. Curtis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2008 1:33 PM To: Curtis Leach Cc: dbi-users@perl.org Subject: Re: Generic DBI question about backups I guess I'd be more concerned initially with ensuring the datatype mappings are identic

Generic DBI question about backups

2008-06-19 Thread Curtis Leach
Does anyone know of a module that would backup an Oracle database in a database independent way? We are decommissioning our only Oracle database & we would like to be able to preserve it's contents so that it can be reloaded into another database at a later date. Such as Windows SQL Server or Inf

RE: DBI:CSV join ... flashback to 2002

2007-07-16 Thread Curtis Leach
Another way to remove the dot in the query is as follows. $dbh->{'csv_tables'}->{table_a} = { 'file' => table_a.csv }; $dbh->{'csv_tables'}->{table_b} = { 'file' => table_b.csv }; $sth = $dbh->prepare("Select a.subject from table_a as a, table_b as b where a.subject=b.subject"); I haven't verifi

RE: Problems using the DBI class to access CSV files.

2007-01-23 Thread Curtis Leach
Never mind, after writing up the email I noticed the csv_eol tag & tried setting it to "\n" for grins, and it solved my problem. Curtis Leach -Original Message- From: Curtis Leach [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 4:06 PM

Problems using the DBI class to access CSV files.

2007-01-23 Thread Curtis Leach
nge Enter driver name or number, or full 'dbi:...:...' DSN: DBI:CSV:csv_sep_char=| Connecting to 'DBI:CSV:csv_sep_char=|' as ''... @> select * from test.log @> ; TIME,Status,Description, [0 rows of 4 fields returned] Can anyone offer suggestions? Curtis Leach Programmer Analyst Harrah's Entertainment, Inc. - RMS I&AS Phone: (901) 537-3453 Cell: (901) 573-7973