Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Suppress Warning messages in SPUFI

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Dsingh29

Active User


Joined: 16 Dec 2008
Posts: 132
Location: IBM

PostPosted: Thu Apr 04, 2013 1:01 pm    Post subject: Suppress Warning messages in SPUFI
Reply with quote

hi,

I am trying to suppress warning messages in SPUFI, while searching on net I found that --#SET TOLWARN YES, can do it. But when I code this line before my query, spufi still prints the warning messages as below.

Code:
DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION                             
DSNT418I SQLSTATE   = 01506 SQLSTATE RETURN CODE                         
DSNT415I SQLERRP    = DSN SQL PROCEDURE DETECTING ERROR                   
DSNT416I SQLERRD    = 0 0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION         
DSNT416I SQLERRD    = X'00000000'  X'00000000'  X'00000000'  X'FFFFFFFF' 
         X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION             
DSNT417I SQLWARN0-5 = W,,,,, SQL WARNINGS                                 
DSNT417I SQLWARN6-A = W,,,,   SQL WARNINGS                               


I dont want these messages in my output. I guess spufi is rejecting line --#SET TOLWARN YES, because it treats line starting with two hyphens as comment. Is there a way around, or am I doing something wrong here.

Thanks.
Back to top
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Apr 04, 2013 1:49 pm    Post subject:
Reply with quote

If you look for the explanation of SQLSTATE=01506, it tells that an adjustment was made to a DATE or TIMESTAMP value to correct an invalid date resulting from an arithmetic operation. So how your SQL query looks like?

What level of DB2 are you at? And this article might just interest you.
Back to top
View user's profile Send private message
Dsingh29

Active User


Joined: 16 Dec 2008
Posts: 132
Location: IBM

PostPosted: Thu Apr 04, 2013 2:40 pm    Post subject:
Reply with quote

hi Anuj,

Thanks for the link, I have already gone through it.

My query looks something like this.

select CURRENT DATE - 6 months from sysibm.sysdummy1;


On 31st March when it ran, March 31, 2013 - 6 MONTHS would be September 31, 2012 which does not exist (September has only 30 days) so the date adjustment, hence the warnings.

Our DBA says , "The messages are just telling you that DB2 corrected the invalid date to allow the SQL to run. The fact that it generates 8 lines for every record, this is what is filling up the JES2 spool and causing the system issue. "

To avoid using up system resources, we were looking at supressing the warning messages. Other option before us is to schedule job on 27 or 28 every month, so it never encounters the 30/31 days issue.

We know to put PARMS('SQL,1,TOLWARN(YES)') in batch job, can serve our purpose, but I was just testing the same parm in SPUFI, but not getting the desired result because of reason mentioned in my previous post.

In spufi I am testing for this query.
Code:
--#SET TOLWARN NO                           
SELECT MONTH(DATE('2013-03-31') - 6 MONTHS) from sysibm.sysdummy1;



We have DB2 Version 9 Release 1
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 658
Location: Whitby, ON, Canada

PostPosted: Sat Apr 06, 2013 2:28 am    Post subject:
Reply with quote

--#SET TOLWARN YES is a called a 'functional comment'. It is supported by DSNTEP2/4.

DSNTEP2 <> SPUFI. It is commonly called 'batch SPUFI' but it is not the same program that you invoke via the DB2I panel.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Suppress value reported by BREAK in D... Learncoholic DFSORT/ICETOOL 3 Wed Aug 16, 2017 6:03 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts How to suppress retun code of partil ... mkk157 DB2 9 Fri May 27, 2016 6:59 am
No new posts ims program to put and get MQ messages fatenezzat COBOL Programming 1 Wed Feb 17, 2016 1:07 am
No new posts Problems in File-Aid / DB2 Spufi whil... amitc23 CLIST & REXX 6 Fri Feb 12, 2016 1:59 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us