Page 2 of 2

Re: JCL to unload a DB2 table having C and L type fields.

PostPosted: Fri Oct 14, 2016 7:52 pm
by dkuma14
Ya you are correct . It seems none of them are clob might I got confused Yesterday so mentioned CLOB, I apologise.

Here I am writing what I actually looking for.

I have already attached the table fields description Please have a look into that.

Issue :- While I am running a Job to unload all fields into a file I am not getting the value for fields in the output file which is marked in RED in the attached screenshot of the table description. But the values for others fields which is not marked in red are getting unloaded into output file.


Looking for -- Does someone have MAINFRAME JOB which will unload 'ALL FIELDS'' (both either marked in red or not marked in red , Please refer earlier attached screenshot having table description from which I want to unload data.) from that table into a output file.



If now I am able to make you all understand what I am looking for then please provide me Mainframe Job for that.

Re: JCL to unload a DB2 table having C and L type fields.

PostPosted: Fri Oct 14, 2016 7:56 pm
by Robert Sample
Issue :- While I am running a Job to unload all fields into a file I am not getting the value for fields in the output file which is marked in RED in the attached screenshot of the table description. But the values for others fields which is not marked in red are getting unloaded into output file.
You may THINK this, but so far you have posted NOTHING to support this allegation. Until and unless you post output data (using the CODE button to preserve spacing), we have nothing to go on since we have no idea if what you are saying is true or not.

Re: JCL to unload a DB2 table having C and L type fields.

PostPosted: Fri Oct 14, 2016 7:59 pm
by enrico-sorichetti
how have You determined that those fields are not unloaded ?

remember if You have to <send> that data to a pc
all the numeric data fields must be converted to text

again speck to Your support,
hard to believe that it is the first time that the task is done in Your organisation

and RTFM

and, remember, nobody will provide a running job for You,

Re: JCL to unload a DB2 table having C and L type fields.

PostPosted: Fri Oct 14, 2016 8:44 pm
by dkuma14
@ RObert Sample

Just for your believe I am attaching the data in that fields.

1. When I ran the same query in QMF I have values for those fields (which is marked in red) in the output screen.

2. Same query when I am running through a JCL unload JOb values for those fields which is marked in red are not present.
So I am not assuming anything when I said values for few fields are not getting unloaded through that JCl.

If you have any solution for this issue then you please suggest me or we can close this discussion here only. Thanks all of you for help :)


@Enrico - That is not the issue of sending file from mainframe to text format or other format . i have done it 30 mints back only and many more times.

Issue is I want all fields value in that output file rest I will take care.

Thanks

Re: JCL to unload a DB2 table having C and L type fields.

PostPosted: Fri Oct 14, 2016 8:51 pm
by enrico-sorichetti
topic locked as requested

Re: JCL to unload a DB2 table having C and L type fields.

PostPosted: Fri Oct 14, 2016 8:53 pm
by Robert Sample
You did not look at the data in hexadecimal, so you don't know what the precise value is between columns 71 and 80 of your output data set. And your statement
Hera at position in between 70-80 value for fields PRC_RDG_FAC_NO should be there which is missing.
is completely and totally WRONG -- there is a question mark in column 80, which represents the DB2 unload of that particular data. Whether or not it is what you want it to be is an entirely different question. But the fact is, DB2 is unloading SOMETHING into the output data set for the variables you think are not being unloaded -- and hence your entire set of posts is basically trash as you are not getting what you say you are getting.