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



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

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

Postby dkuma14 » Fri Oct 14, 2016 7:52 pm

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.
dkuma14
 
Posts: 15
Joined: Thu Oct 13, 2016 7:34 pm
Has thanked: 7 times
Been thanked: 0 time

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

 

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

Postby Robert Sample » Fri Oct 14, 2016 7:56 pm

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.
Robert Sample
Global moderator
 
Posts: 3367
Joined: Sat Dec 19, 2009 8:32 pm
Location: East Dubuque, Illinois
Has thanked: 1 time
Been thanked: 222 times

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

Postby enrico-sorichetti » Fri Oct 14, 2016 7:59 pm

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,
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2643
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

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

Postby dkuma14 » Fri Oct 14, 2016 8:44 pm

@ 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
You do not have the required permissions to view the files attached to this post.
dkuma14
 
Posts: 15
Joined: Thu Oct 13, 2016 7:34 pm
Has thanked: 7 times
Been thanked: 0 time

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

Postby enrico-sorichetti » Fri Oct 14, 2016 8:51 pm

topic locked as requested
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2643
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

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

Postby Robert Sample » Fri Oct 14, 2016 8:53 pm

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.
Robert Sample
Global moderator
 
Posts: 3367
Joined: Sat Dec 19, 2009 8:32 pm
Location: East Dubuque, Illinois
Has thanked: 1 time
Been thanked: 222 times

Previous

Return to JCL

 


  • Related topics
    Replies
    Views
    Last post