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 is not getting populated to the field

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: data is not getting populated to the field
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: 8593
Location: Back in jolly old England

PostPosted: Wed Jun 17, 2009 7:59 pm    Post subject:
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    Post subject: Reply to: data is not getting populated to the field
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Wed Jun 17, 2009 9:01 pm    Post subject: Reply to: data is not getting populated to the field
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    Post subject: Reply to: data is not getting populated to the field
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Wed Jun 17, 2009 9:50 pm    Post subject: Reply to: data is not getting populated to the field
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    Post subject:
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

Site Director


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

PostPosted: Wed Jun 17, 2009 11:36 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts INVALID FIELD OR CONSTANT IN SORTOF ?? Ron Klop DFSORT/ICETOOL 8 Wed Jan 11, 2017 3:44 pm
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 0 Mon Jan 02, 2017 11:16 am
No new posts JES2 JEC: Use UNIX Pipes to Pass Data... Virendra Shambharkar JCL & VSAM 21 Tue Dec 20, 2016 6:55 pm


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