Author |
Message |
Topic: Need suggestion on handling cursors in multiple tables |
pappu47
Replies: 1
Views: 1304
|
Forum: Database Posted: Tue Mar 04, 2008 9:32 pm Subject: Need suggestion on handling cursors in multiple tables |
I Need to create a flat file when there is any change in history files and if the record have multiple changes in that records i have write all the records(before and after) in to output file.Each fie ... |
Topic: How to recover corrupted dataset |
pappu47
Replies: 1
Views: 2805
|
Forum: Job Control Language(JCL) Posted: Tue Aug 09, 2005 4:43 am Subject: How to recover corrupted dataset |
Hi All,
All my outputs will store in different memebers of PDS,by mistake I gave only PDS name and forgot to give the memebr and executed the JOB so all the members were erased and it shows the dir ... |
Topic: Need to report how long particular ID is zero |
pappu47
Replies: 17
Views: 9834
|
Forum: Utilities Posted: Mon Apr 18, 2005 8:36 am Subject: Need to report how long particular ID is zero |
Kolusu,
I need to call temp files(TGEN1 to TGEN5)which are having date field added at end into COBOL pgm.
I just included STEP300 instead STEP300 in below code.
But the job abended.
//STE ... |
Topic: Need to report how long particular ID is zero |
pappu47
Replies: 17
Views: 9834
|
Forum: Utilities Posted: Tue Apr 12, 2005 12:52 am Subject: Need to report how long particular ID is zero |
Kolusu,
It's working fine..
Thanks a lot Kolusu
With regards,
pappu |
Topic: Need to report how long particular ID is zero |
pappu47
Replies: 17
Views: 9834
|
Forum: Utilities Posted: Mon Apr 11, 2005 9:05 am Subject: Need to report how long particular ID is zero |
Kolusu,
I have included my jcl and messages below .
ID is 11 bytes and starts at 17th position. and counter start at 109 and it's comp-3 variable and length is 5 bytes.
//JOBCARD
//STEP0100 ... |
Topic: Need to report how long particular ID is zero |
pappu47
Replies: 17
Views: 9834
|
Forum: Utilities Posted: Mon Apr 11, 2005 7:36 am Subject: Need to report how long particular ID is zero |
Kolusu,
I have coded the CON dd statement as you mentioned above.Just to come out from this abend I just included DCB parameters like RECFM=FB and LRECL=133.so now job abended with OUTREC FIELD OUT ... |
Topic: Need to report how long particular ID is zero |
pappu47
Replies: 17
Views: 9834
|
Forum: Utilities Posted: Mon Apr 11, 2005 3:27 am Subject: Need to report how long particular ID is zero |
Kolusu,
Sorry for giving you trouble I am able to fix above mentioned problem.Actual proble is I missed out continuation in outrec.Now I getting another abend for which the error message is
WER189 ... |
Topic: Need to report how long particular ID is zero |
pappu47
Replies: 17
Views: 9834
|
Forum: Utilities Posted: Mon Apr 11, 2005 2:42 am Subject: Need to report how long particular ID is zero |
Kolusu,
I have tried your code, first I got ABEND S013 because no TOOL in DD found in step200 so I included this in step200
//TOOLIN DD *
SORT FROM(CON) USING(CTL2)
After the inclusion of ... |
Topic: Need to report how long particular ID is zero |
pappu47
Replies: 17
Views: 9834
|
Forum: Utilities Posted: Thu Apr 07, 2005 8:43 am Subject: Need to report how long particular ID is zero |
Kolusu,
Always have 21 versions.and LRECL is 438 and record format is FB.
Pappu |
Topic: Need to report how long particular ID is zero |
pappu47
Replies: 17
Views: 9834
|
Forum: Utilities Posted: Thu Apr 07, 2005 1:45 am Subject: Need to report how long particular ID is zero |
Kolusu,
Can you explain how to read each version of file sort .
Pappu |
Topic: Need to report how long particular ID is zero |
pappu47
Replies: 17
Views: 9834
|
Forum: Utilities Posted: Wed Apr 06, 2005 4:49 am Subject: Need to report how long particular ID is zero |
Can any one suggest how to achieve my task.
I have a file(gdg) which is having 21 version.
I need to find ID's whenever there is an counter field is zero in each file and I have to report how long ... |
Topic: Need Help on SORT |
pappu47
Replies: 2
Views: 1801
|
Forum: Utilities Posted: Mon Jan 10, 2005 4:21 am Subject: Need Help on SORT |
Hi members,
I have an problem while sorting a files.
Example:-
I have 2 files in sortin and each file is having a header and data.I have to sort data records only not the headers.
My situation i ... |
|