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
 
Error in SQL-PLIST3 'Above value truncated after 115 bytes.

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

New User


Joined: 19 Jan 2009
Posts: 62
Location: hyderabad

PostPosted: Wed Sep 06, 2017 1:34 pm    Post subject: Error in SQL-PLIST3 'Above value truncated after 115 bytes.
Reply with quote

Hello Everyone,
While executing one MPP in IMS region(say Pgm A) , it was getting timeout abend 0240.
On analysis, i saw that it had a called module (Pgm B)which fetches data from DB2 .

Code:
EXEC  SQL                                         
   SELECT  transport                                                           
     FROM   XXX                                 
    WHERE  route   = :CP972200.route-number
END-EXEC                                           

Blank values were moved to this field(route-number) .It is defined to be a not null field though.
This query failed and Fault analyser output showed the below.

Code:
 A user abend 0240 occurred in module DFSPCC20 CSECT DFSPCC20 at offset X'1FA6'


Code:
 SQL-PLIST3 = ......Pgm-name..1..l.......Q.........J.XSQLDA 
              NOTE: Above value truncated after 115 bytes.   

Could you please help me in understanding the exact issue which caused the timeout abend?
Back to top
View user's profile Send private message

Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1868
Location: UK

PostPosted: Wed Sep 06, 2017 2:23 pm    Post subject:
Reply with quote

Find out the how your host variable was populated with blanks - probably your input is in error.
Back to top
View user's profile Send private message
rikdeb

New User


Joined: 19 Jan 2009
Posts: 62
Location: hyderabad

PostPosted: Wed Sep 06, 2017 2:26 pm    Post subject:
Reply with quote

Yes Nic.. Input was erroneous. It should not be blank. But just curious to know about how this resulted in timeout or more detail about the SQL-PLIST3 error.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1788
Location: NY,USA

PostPosted: Wed Sep 06, 2017 3:29 pm    Post subject:
Reply with quote

Talk to DBA, it must have been a table space scan for blank.
Back to top
View user's profile Send private message
rikdeb

New User


Joined: 19 Jan 2009
Posts: 62
Location: hyderabad

PostPosted: Wed Sep 06, 2017 5:21 pm    Post subject:
Reply with quote

Ok. thanks Rohit and Nic. Will check that.
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 FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 1 Mon Sep 18, 2017 4:31 pm
No new posts Reply MQ open error Vignesh Sid COBOL Programming 5 Thu Sep 07, 2017 6:02 pm
No new posts WER268A OUTREC STATEMENT : SYNTAX E... frozenblood87 SYNCSORT 12 Sat Aug 26, 2017 9:45 pm
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm

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