Home > Archive > PERL Modules > September 2006 > Re: Problem with DBD::DB2 on AIX.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: Problem with DBD::DB2 on AIX.
|
|
| usenet@DavidFilmer.com 2006-09-20, 3:57 am |
| Hemant Shah wrote:
> $InsStmt .= "?);\n";
I'm pretty sure you don't want the trailing semi-colon (that's a shell
thing) and I'm even more sure you don't want that linefeed.
> Then I get error that I should get.
> What could cause this problem?
You didn't tell us what the error message is.
--
David Filmer (http://DavidFilmer.com)
| |
| Mumia W. (reading news) 2006-09-20, 7:57 am |
| On 09/20/2006 01:10 AM, usenet@DavidFilmer.com wrote:
> Hemant Shah wrote:
>
> I'm pretty sure you don't want the trailing semi-colon (that's a shell
> thing) and I'm even more sure you don't want that linefeed.
> [...]
Huh? I thought that trailing semi-colons and newlines didn't matter in
SQL? They certainly don't matter in Mysql. Even newslines embedded in
the insert statement don't matter (so long as they aren't embedded in a
field name or value).
--
paduille.4058.mumia.w@earthlink.net
| |
| Hemant Shah 2006-09-20, 6:57 pm |
| While stranded on information super highway usenet@davidfilmer.com wrote:
> Hemant Shah wrote:
>
> I'm pretty sure you don't want the trailing semi-colon (that's a shell
> thing) and I'm even more sure you don't want that linefeed.
>
>
> You didn't tell us what the error message is.
I tried to force 2 errors:
1) I mispelled on of the column names.
2) I revoked insert authority for my user.
When I hard code the insert statement, I am able to re-create both errors.
I get appropriate error back from DB2.
When I dynamically build the insert statement, I get no errors from perl
or from DB2. It is as if the statement was never executed.
>
> --
> David Filmer (http://DavidFilmer.com)
>
--
Hemant Shah /"\ ASCII ribbon campaign
E-mail: NoJunkMailshah@xnet.com \ / ---------------------
X against HTML mail
TO REPLY, REMOVE NoJunkMail / \ and postings
FROM MY E-MAIL ADDRESS.
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind, Above opinions are mine only.
it's backed up on tape somewhere. Others can have their own.
|
|
|
|
|