| Author |
Message |
Topic: ICETOOL: a splice question |
Sterling Price
Replies: 2
Views: 2060
|
Forum: Utilities Posted: Fri Jul 29, 2005 9:35 am Subject: ICETOOL: a splice question |
| Yes, that does exactly what I need. Thank you. I guess I was trying to make it too complicated. |
Topic: ICETOOL: a splice question |
Sterling Price
Replies: 2
Views: 2060
|
Forum: Utilities Posted: Thu Jul 28, 2005 10:45 pm Subject: ICETOOL: a splice question |
I'm having a splice problem involving duplicates. I have inserted "protection" records per previous posts I've read to preserve the duplicates, but can't seem to get what I need.
Here is the JCL (p ... |
Topic: DFSORT: convert spaces to packed zero |
Sterling Price
Replies: 4
Views: 4400
|
Forum: Utilities Posted: Wed Dec 22, 2004 12:01 pm Subject: DFSORT: convert spaces to packed zero |
| It works...thank you kolusu. |
Topic: DFSORT: convert spaces to packed zero |
Sterling Price
Replies: 4
Views: 4400
|
Forum: Utilities Posted: Wed Dec 22, 2004 10:29 am Subject: DFSORT: convert spaces to packed zero |
Greetings,
I hope this question hasn't already been answered elsewhere. I did the searches I could think of and didn't find anything.
I have an LRECRL=80 file in which I need to convert columns ... |
Topic: DFSort: splice problem |
Sterling Price
Replies: 2
Views: 2467
|
Forum: Utilities Posted: Tue Oct 19, 2004 3:46 pm Subject: DFSort: splice problem |
| Now I see...thank you Kolusu, it helped indeed. |
Topic: DFSort: splice problem |
Sterling Price
Replies: 2
Views: 2467
|
Forum: Utilities Posted: Tue Oct 19, 2004 2:12 pm Subject: DFSort: splice problem |
I'm attempting to splice two datasets (both LRECL=110, RECFM=FB) on a common key and the results I'm getting seem to contradict what I thought I knew about how splice works.
My goal is to keep only ... |
Topic: DFSort error: ICE046A 0 SORT CAPACITY EXCEEDED |
Sterling Price
Replies: 11
Views: 20862
|
Forum: Utilities Posted: Tue Oct 12, 2004 12:53 pm Subject: DFSort error: ICE046A 0 SORT CAPACITY EXCEEDED |
| Thanks Frank and Kolusu. I will pass these suggestions on to my colleague and report back with the results after she tries them. |
Topic: DFSort error: ICE046A 0 SORT CAPACITY EXCEEDED |
Sterling Price
Replies: 11
Views: 20862
|
Forum: Utilities Posted: Tue Oct 12, 2004 11:16 am Subject: DFSort error: ICE046A 0 SORT CAPACITY EXCEEDED |
| I'm posting this on behalf of a colleague who is having problems with a splice using an extremely large dataset. She has already tried adding more sortwork files. What else might she try to overcome t ... |
Topic: DFSORT: page header on grand total page |
Sterling Price
Replies: 4
Views: 4342
|
Forum: Utilities Posted: Fri Oct 01, 2004 11:32 am Subject: DFSORT: page header on grand total page |
Ah, now I see. Thanks.
(There is a report ID that must be in a certain position on the report on every page, or that page won't get defined correctly in our report archival software).
Thanks a ... |
Topic: DFSORT: page header on grand total page |
Sterling Price
Replies: 4
Views: 4342
|
Forum: Utilities Posted: Fri Oct 01, 2004 11:22 am Subject: DFSORT: page header on grand total page |
| Thank you! Do you happen to know if I need to move the grand total inside the "sections" brackets to do that? For some reason I have it in my head that trailer2 can only exist inside the sections. ... |
Topic: DFSORT: page header on grand total page |
Sterling Price
Replies: 4
Views: 4342
|
Forum: Utilities Posted: Fri Oct 01, 2004 10:15 am Subject: DFSORT: page header on grand total page |
| Sorry for the urgency. This is going in production today, and I was just informed it can't be processed by our report archival software because the grand total line produces a page feed but no new pag ... |
Topic: DFSORT: Odd date comparison problem |
Sterling Price
Replies: 8
Views: 6451
|
Forum: Utilities Posted: Tue Sep 14, 2004 11:07 am Subject: DFSORT: Odd date comparison problem |
| Thank you both very much. I am reviewing your code to make sure I understand before I integrate it into my job. As a side note, these dates are all for the month previous to the current month, so they ... |
Topic: DFSORT: Odd date comparison problem |
Sterling Price
Replies: 8
Views: 6451
|
Forum: Utilities Posted: Tue Sep 14, 2004 10:00 am Subject: DFSORT: Odd date comparison problem |
I have an 80-byte RECFM=FB file that contains, among other values, 3 dates
In columns 26-29, there is a packed date in the form:
0MYD
MYDC
for example,
0842
000C is 080402 or August 2, ... |
Topic: DFSort - possible to perform date arithmetic? |
Sterling Price
Replies: 4
Views: 5094
|
Forum: Utilities Posted: Tue Sep 14, 2004 6:12 am Subject: DFSort - possible to perform date arithmetic? |
| It worked perfectly. Thank you very much. |
Topic: DFSort - possible to perform date arithmetic? |
Sterling Price
Replies: 4
Views: 5094
|
Forum: Utilities Posted: Fri Sep 03, 2004 6:52 am Subject: DFSort - possible to perform date arithmetic? |
My end goal is to produce a report with a title containing the previous month and the year, in the form:
August , 2004 (if the job ran in September 2004)
or
December, 2004 (if the job ran in ... |
| |