How to disable SQL Warning in DBI.pm

joperocho has asked for the wisdom of the Perl Monks concerning the following question:

Anyway to disable SQL Warning from being printed in errstr? I've tried setting PrintWarn, Warn, PrintError to 0, yet sql warnings are still being set in errstr. Sample Warning: DBI Error: 513: IBM CLI Driver DB2/LINUXZ64 SQL0513W The SQL statement will modify an entire table or view. SQLSTATE=01504 Please advise. Thanks in advance.

Comment on How to disable SQL Warning in DBI.pm

Replies are listed 'Best First'.
Re: How to disable SQL Warning in DBI.pm by runrig (Abbot) on Mar 17, 2014 at 17:48 UTC
Googling found this: Informational Warnings. Does that help? Summary is to add to the db2cli.ini file: `[COMMON] IgnoreWarnList="'01504'"` [download]	[reply] [d/l]
Re^2: How to disable SQL Warning in DBI.pm by joperocho (Initiate) on Mar 17, 2014 at 18:08 UTC
Unfortunately, specifying / trapping the code is a fix, but not the solution I'm looking for. I want to suppress all warning message from being printed in errstr.	[reply]
Re^3: How to disable SQL Warning in DBI.pm by runrig (Abbot) on Mar 17, 2014 at 18:46 UTC
The docs list a connection attribute "db2_quiet_mode". Does that do anything? If PrintWarn doesn't work though, I'd report that as a bug.	[reply]
Re: How to disable SQL Warning in DBI.pm by mje (Curate) on Mar 18, 2014 at 08:39 UTC
What version of DBI are you using? I ask because Changes in DBI 1.630 says "NOTE: This release enables PrintWarn by default regardless of $^W. Your applications may generate more log messages than before." May be there is a problem with that change.	[reply]
Re^2: How to disable SQL Warning in DBI.pm by Anonymous Monk on Mar 18, 2014 at 12:20 UTC
We are using DBI version 1.607, setting PrintWarn to 0, doesn't work.	[reply]
Re^3: How to disable SQL Warning in DBI.pm by Tux (Abbot) on Mar 18, 2014 at 12:25 UTC
And your script uses `-w`? Please re-read mje's post, and/or try to upgrade to recent DBI (in a local folder) and see if that fixes your problem Enjoy, Have FUN! H.Merijn	[reply] [d/l]
Re^4: How to disable SQL Warning in DBI.pm by Anonymous Monk on Mar 18, 2014 at 12:51 UTC
Re: How to disable SQL Warning in DBI.pm by runrig (Abbot) on Mar 18, 2014 at 15:44 UTC
I'm a little confused by this statement: disable SQL Warning from being printed in errstr? I've tried setting PrintWarn, Warn, PrintError to 0, yet sql warnings are still being set in errstr. Do you mean that errstr is just being set and you are printing the contents of errstr, or that warnings are being printed with no explicit print statements on your part?	[reply]
Re^2: How to disable SQL Warning in DBI.pm by Anonymous Monk on Mar 18, 2014 at 18:23 UTC
errstr is being populated by SQL Warning messages.	[reply]
Re^3: How to disable SQL Warning in DBI.pm by runrig (Abbot) on Mar 18, 2014 at 18:49 UTC
Then there is no problem with PrintWarn (at least it sounds like your problem has nothing to do with PrintWarn). You can change the behavior with HandleSetErr, but why are you printing errstr or even caring what is in errstr if there are no errors? The problem resolution seems like it should be "Don't print errstr if there are no errors detected".	[reply]

Back to Seekers of Perl Wisdom