View previous topic :: View next topic
|
Author |
Message |
kcs4u2004 Warnings : 1 New User
Joined: 21 Apr 2008 Posts: 56 Location: Chennai
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Is this a JCL, SORT, COBOL or whatever question ? |
|
Back to top |
|
|
kcs4u2004 Warnings : 1 New User
Joined: 21 Apr 2008 Posts: 56 Location: Chennai
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
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 |
|
|
kcs4u2004 Warnings : 1 New User
Joined: 21 Apr 2008 Posts: 56 Location: Chennai
|
|
|
|
yes,but for some records the filed value is there...but for some records it is not populating.... |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
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 |
|
Back to top |
|
|
chaky
New User
Joined: 28 May 2009 Posts: 20 Location: Bangalore
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
|