Author |
Message |
Topic: addition - final total only |
ranga_subham
Replies: 1
Views: 1666
|
Forum: Utilities Posted: Thu Feb 20, 2014 3:56 am Subject: addition - final total only |
Hi, I am using below given ICETOOL to sum up input records and expected to get only final number but getting all records along with final sum.
//SORT0001 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT ... |
Topic: Easytrieve code snippet - pull strings with "DCG" |
ranga_subham
Replies: 12
Views: 9896
|
Forum: Utilities Posted: Tue Feb 04, 2014 3:20 am Subject: Easytrieve code snippet - pull strings with "DCG" |
Kolusu, thank you.......I've got the expected results |
Topic: Easytrieve code snippet - pull strings with "DCG" |
ranga_subham
Replies: 12
Views: 9896
|
Forum: Utilities Posted: Wed Jan 29, 2014 9:43 am Subject: all I could do |
Kolusu, this is all I could do with my Easytrieve knowledge (learning though)
//STEP0100 EXEC PGM=EZTPA00
//SYSPRINT DD SYSOUT=*
//SYSOUT DD ... |
Topic: Easytrieve code snippet - pull strings with "DCG" |
ranga_subham
Replies: 12
Views: 9896
|
Forum: Utilities Posted: Wed Jan 22, 2014 8:59 pm Subject: Easytrieve code snippet - pull strings with "DCG" |
wow......its increased to 1000......great news....I will take some more time to finish my easytrieve progam and put it here..... try and error |
Topic: Easytrieve code snippet - pull strings with "DCG" |
ranga_subham
Replies: 12
Views: 9896
|
Forum: Utilities Posted: Wed Jan 22, 2014 6:12 am Subject: Easytrieve code snippet - pull strings with "DCG" |
Papadi/Kolusu, from doco, I learnt that only 100 parse are supported. A programmatic approach would not have such limitation......pls correct me if I am wrong....thanks again. |
Topic: Easytrieve code snippet - pull strings with "DCG" |
ranga_subham
Replies: 12
Views: 9896
|
Forum: Utilities Posted: Wed Jan 22, 2014 6:09 am Subject: thanks |
Kolusu, thank you very much for SORT solution. I did not know that it was difficult to achieve it by Easytrieve due to its limited functionality (read it from one of your posts).
Thanks again. |
Topic: Easytrieve code snippet - pull strings with "DCG" |
ranga_subham
Replies: 12
Views: 9896
|
Forum: Utilities Posted: Mon Jan 20, 2014 2:44 am Subject: thanks |
Thanks Kolusu.....I will try this |
Topic: Easytrieve code snippet - pull strings with "DCG" |
ranga_subham
Replies: 12
Views: 9896
|
Forum: Utilities Posted: Sat Jan 18, 2014 9:52 pm Subject: Easytrieve code snippet - pull strings with "DCG" |
Hi, Can you please help me with EASYTRIEVE code to achieve below output?
Input:- LRECL=400,RECFM=FB
INPUT1 DCG01 DCG02 ABY98 CLR84 DCM45
INPUT2 DCX09 FLJ94 DCG05 MAR85
INPUT3 FIN44 FPT34 DCR03 ... |
Topic: Checking date format |
ranga_subham
Replies: 3
Views: 3169
|
Forum: Utilities Posted: Thu Apr 26, 2012 7:24 am Subject: reply |
sqlcode, actually, I want to correct the data by replacing any other character with "-" in those positions so that our process does not omit but consider them. Right now, its been handled by ... |
Topic: Checking date format |
ranga_subham
Replies: 3
Views: 3169
|
Forum: Utilities Posted: Tue Apr 24, 2012 8:56 am Subject: Checking date format |
Hi,
Request you to let me know how to check whether received date format is correct or not using SORT. Our file has records like this in the below given format and this should be checked for correc ... |
Topic: Can we use PGM=IKJEFT1A to submit a batch job? |
ranga_subham
Replies: 7
Views: 7239
|
Forum: Job Control Language(JCL) Posted: Sat Feb 26, 2011 2:36 am Subject: Can we use PGM=IKJEFT1A to submit a batch job? |
Hi,
We have a production job that runs 5 days a week through CA-7. Can we introduce a new step into it to use PGM=IKJEFT1A to submit another batch job that does SORT? If it had to be IKJEFT1A then ... |
Topic: How to copy remaining records to output dataset with IDCAMS |
ranga_subham
Replies: 9
Views: 7084
|
Forum: Utilities Posted: Tue Feb 22, 2011 10:49 am Subject: How to copy remaining records to output dataset with IDCAMS |
Oh Yeah.........Thanks a lot. I should've tried SKIP alone for last option........
One more thing, I've tried FROMNUMBER, FROMADDRESS and FROMKEY options but none works on a PS dataset |
Topic: How to copy remaining records to output dataset with IDCAMS |
ranga_subham
Replies: 9
Views: 7084
|
Forum: Utilities Posted: Tue Feb 22, 2011 9:45 am Subject: How to copy remaining records to output dataset with IDCAMS |
Yes, that worked for first set but how about the remaining records? It fails only for the last option ! |
Topic: How to copy remaining records to output dataset with IDCAMS |
ranga_subham
Replies: 9
Views: 7084
|
Forum: Utilities Posted: Tue Feb 22, 2011 8:52 am Subject: How to copy remaining records to output dataset with IDCAMS |
I've tried the REPRO with FROMNUMBER and TONUMBER but it ends with MAXCC=12 because my input file is a flat file and not an RRDS |
Topic: How to copy remaining records to output dataset with IDCAMS |
ranga_subham
Replies: 9
Views: 7084
|
Forum: Utilities Posted: Tue Feb 22, 2011 5:40 am Subject: How to copy remaining records to output dataset with IDCAMS |
I have tried using REPRO without COUNT but it ends with MAXCC=12 |
|