IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

data is not getting populated to the field


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
kcs4u2004
Warnings : 1

New User


Joined: 21 Apr 2008
Posts: 56
Location: Chennai

PostPosted: Wed Jun 17, 2009 7:55 pm
Reply with quote

I am executing a cobol program.The program receives data from other team database thats db2 database.There is an indicator feld in output to which the value will be retrieved from database only,not from the input file.The value is Y or N.so the issue is for most of the records IND field is getting populated as N or Y,but for some records it is coming as "spaces".
I checked the output files,the records where IND field is space they do not have data in some other fields also.its consistency maintained thorugh out the file.but in program there is no such condition when this indicator is getting populated,when not.

can anyone give some solution to this,how to know the reason....
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Wed Jun 17, 2009 7:59 pm
Reply with quote

Is this a JCL, SORT, COBOL or whatever question ?
Back to top
View user's profile Send private message
kcs4u2004
Warnings : 1

New User


Joined: 21 Apr 2008
Posts: 56
Location: Chennai

PostPosted: Wed Jun 17, 2009 8:46 pm
Reply with quote

its a mainframe question,As I am running a jcl to find out the reason and not a cobol doubt ofcourse,so asked in this forum........
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Jun 17, 2009 9:01 pm
Reply with quote

from the confusing info of the first post ...
You are dealing with a field that should contain a Y or a N,
but for some reason the field contains blanks

right ??
Back to top
View user's profile Send private message
kcs4u2004
Warnings : 1

New User


Joined: 21 Apr 2008
Posts: 56
Location: Chennai

PostPosted: Wed Jun 17, 2009 9:41 pm
Reply with quote

yes,but for some records the filed value is there...but for some records it is not populating....
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Jun 17, 2009 9:50 pm
Reply with quote

looks like You have to go back to find where the mishap occurs,
very little we can tell, You just described the error symptoms, with very little we can work on icon_confused.gif
Back to top
View user's profile Send private message
chaky

New User


Joined: 28 May 2009
Posts: 20
Location: Bangalore

PostPosted: Wed Jun 17, 2009 10:46 pm
Reply with quote

kcs4u2004,

One Possibility i can think of....

If I have understood correctly you are getting few records correct and few records are not getting populated. So first step should be like we should take the record for whom the values are not getting populated (I assume that we have some unique key or something to recognize). Then after taking that key we should check in the database what value we are getting. If we don't get any answer there then we need to step in for that record by Xped or Intertest.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Jun 17, 2009 11:36 pm
Reply with quote

Hello,

Quote:
its a mainframe question,As I am running a jcl to find out the reason and not a cobol doubt ofcourse,so asked in this forum........
You need to take some time and think of how to post information.

Basically everything posted in almost every part of the forum is a mainframe question. . .

As for "running a jcl" - every batch job "runs a jcl". This part of the forum is for questions concerning the use of and problems with jcl.

Yours is probably not a jcl problem. Only a guess, but i suspect that the input file or the db2 table or the code is incorrect. You need to isolate which. Sometimes blanks or other unwanted values happen when a database read is done, the value is "not found" and processing continues anyway. . .

If you provide something to actually work with, someone may have a suggestion.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts SCOPE PENDING option -check data DB2 2
No new posts Check data with Exception Table DB2 0
No new posts JCL EXEC PARM data in C Java & MQSeries 2
Search our Forums:

Back to Top