Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Data truncation error

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF
View previous topic :: :: View next topic  
Author Message
baljinders

New User


Joined: 21 Aug 2006
Posts: 72

PostPosted: Thu Apr 15, 2010 1:00 am    Post subject: Data truncation error
Reply with quote

Hi All,

Can anyone suggest what could be the problem here. I am trying to run JJSCAN on the JCL to check for errors, but i am getting the below message

Code:
                                                                   More:     +
******************************************************************************
* ISPV006                                                                    *
*                                                                            *
* Data truncation occurred                                                   *
* Data for CHAR format variable "LINEAREA" was too long.                     *
*                                                                            *
*                                                                            *
*                                                                            *
*                                                                            *
*                                                                            *
*                                                                            *
*                                                                            *
*                                                                            *
*                                                                            *
* Enter HELP command for further information regarding this error.           *
* Press ENTER key to terminate the dialog.                                   *
*                                                                            *


when i press help, i get the following description,

Code:
A severe error occurred under dialog:                                     
                                                                           
     Application : DSSI                                                     
                                                                           
     Function  . : Command   D0SEALLC                                       
                                                                           
     Service . . : ISREDIT                                                 
                                                                           
 Error message ID: ISPV006                                                 
                                                                           
 Press ENTER key for additional help information.                           
                                                                           
 The above information will be logged. You can print your log and give it to
 the system programmer responsible for the dialog specified previously.     


The jcl runs a program that reads the input file and produces the output file.

The Input file a VBS file with LRECL= 2000
The output file is a FB file wit LRECL = 500
Back to top
View user's profile Send private message

Pedro

Senior Member


Joined: 01 Sep 2006
Posts: 2033
Location: Silicon Valley

PostPosted: Thu Apr 15, 2010 1:09 am    Post subject: Reply to: Data truncation error
Reply with quote

Use LOOKAT to display the description for message ISPV006, then follow the 'user response' recommendation.
Back to top
View user's profile Send private message
baljinders

New User


Joined: 21 Aug 2006
Posts: 72

PostPosted: Thu Apr 15, 2010 1:24 am    Post subject:
Reply with quote

This is what i get from LOOKAT.

Code:
| | ISPV006 Data truncation occurred - Data for aaaaaaaa format variable |
| | "bbbbbbbb" was too long. | | | |________________________________________________________________________|


| Explanation: The variable value being updated is longer than the length
| specified on the VDEFINE for the variable in question.


| User Response: Contact the responsible programmer.


| Programmer Response: Ensure that the correct length was specified on the
| VDEFINE service. The length should have been specified as a fullword
| binary value. If this variable is being updated from a panel, make sure
| that the field length on the panel is not larger than the length specified
| on the VDEFINE service. Dialog Test can be used to trace the variable and
| the VDEFINE service.
Back to top
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 686
Location: Earth

PostPosted: Thu Apr 15, 2010 1:42 am    Post subject:
Reply with quote

Questions-
What are the properties of the concerned JCL PDS? (I mean Reclen etc?)
Does the JJSCAN work on any other JCL PDS with 80 BYTE length?
Back to top
View user's profile Send private message
baljinders

New User


Joined: 21 Aug 2006
Posts: 72

PostPosted: Thu Apr 15, 2010 1:54 am    Post subject:
Reply with quote

Thanks Agkshirsagar for your questions, they helped me solve my problem :-)

The problem was with the PDS defination. I was by defined with RECLEN of 800. changed it to 80 and it worked.

Thanks Pedro and Agkshirsagar for your help
Back to top
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 686
Location: Earth

PostPosted: Thu Apr 15, 2010 11:27 pm    Post subject:
Reply with quote

You are welcome.
Thanks for letting us know that the problem is solved now.
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 -> TSO/ISPF All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Data replication from multiple Db2 ta... kishpra DB2 5 Mon Mar 27, 2017 9:58 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us