002)
Thanks,
John W. Herbold Jr.
-Original Message-
From: David N Murray [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 11:08 AM
To: Herbold, John W.
Cc: [EMAIL PROTECTED]
Subject: Re: Quick DBI:ODBC question...
What's the error that's returned?
I looked at some cod
I am trying to hit a MS SQL server using DBI:ODBC from an win2k box. I have
the odbc client setup on my box, but I can not get the perl to hit it. Any
help would be great! I use DB2 with no problem and am trying the MSSQL
world (not by choice ;-). Here is what I am trying to run...
# I have th
All other DB's that I know of are case sensitive.
Thanks,
John W. Herbold Jr.
Security Specialist
501-399-3939
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 13, 2003 11:34 PM
To: Scott R. Godin
Cc: [EMAIL PROTECTED]
Subject: Re: MYSQL where
Try:
my $dbh = DBI->connect('dbi:mysql:database=helpdesk:host=123.123.123.123',
'user', 'pw');
Thanks,
John W. Herbold Jr.
Security Specialist
501-399-3939
-Original Message-
From: Herbert Braun [mailto:[EMAIL PROTECTED]
Sent: Monday, August 25, 2003 4:53 AM
To: [EMAIL PROTECTED]
Subj
For MySQL you can also use the SQL command DESCRIBE TABLE_NAME and loop
through the answer set just as you would any other DB call.
For DB2 the tables would SYSIBM.SYSCOLUMNS and SYSIBM.SYSTABLES
Thanks,
John Herbold
IS Specialist/DBA
-Original Message-
From: Vinnie Lima
To: Anthony Nic
Ummm two thing about your request...
1) It might help if you give us the error.
2) It might help if you say please.
Thanks,
John W. Herbold Jr.
IS Specialist/DBA
-Original Message-
From: OMKAR (Pramod Shanbhag) [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 29, 2003 7:37 AM
To: [EMAIL
Do you have a DB2 ODBC client installed like DB2 Connect?
Thanks,
John W. Herbold Jr.
IS Specialist/DBA
-Original Message-
From: Robert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 3:47 PM
To: [EMAIL PROTECTED]
Subject: Re: DBD::DB2
And also is it possible to connect to DB2 u
I have done this kind of thing, and I check the value of $DBI::errstr to see
if I could connect to the Database. After I do an insert I turn around and
do a select and check the return code to make sure the records were added.
I am sure there are other and better ways out there through.
Thanks
I have done something like that. I used two connections to the database.
The first "outer" connection retrieved the column names from the system
table. On DB2 this was Select name from sysibm.syscolumns where tbname =
'favorate_table'; Then using Perl I made the calls to the table looking for
the
Select col1
from Jenny
where col1 is not null
Should get you all of column 1 where there is not a null.
Thanks,
John W. Herbold Jr.
IS Specialist/DBA
-Original Message-
From: Christopher G Tantalo [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 16, 2002 12:46 PM
To: [EMAIL PROT
, John W. wrote:
> Has anybody done anything with sending data from DBI calls to PDF files?
You could check out PDF.pm.
dd
--
David Dooling
Has anybody done anything with sending data from DBI calls to PDF files?
Thanks !
John W. Herbold Jr.
IS Specialist/DBA
Help!
I have a chance for Perl to take yet another deep foot hold in my company!
However I need it to be able to hit IMS on the mainframe? We have it
hitting DB2 on the mainframe already, but for a new project, we need it to
be able to read IMS tables.
Any Ideas?
Thanks in advance!
John Herb
Mark,
Try your hardest to use the LOAD procedure. Though I have not done it in
MYSQL yet, I have found with other databases, that the load procedures are
always faster than doing an insert a record at a time. I have taken a DB2
database and used inserts to insert the records one at a time into
Does anybody have an example or two of spitting out a result from a DBI call
into a PDF file ?
I am loosing what little hair I have left trying to get PDF::CREATE to put
thing like I want them!
Thanks !
John W. Herbold Jr.
IS Specialist/DBA
15 matches
Mail list logo