Author |
Message |
Topic: Select only the first group of records |
hungerbuehler
Replies: 2
Views: 1715
|
Forum: Utilities Posted: Sat Dec 19, 2009 9:06 am Subject: Select only the first group of records |
Hi Frank,
Thank you very much.
It works absolute perfect.
Best regards
hungerbuehler |
Topic: Select only the first group of records |
hungerbuehler
Replies: 2
Views: 1715
|
Forum: Utilities Posted: Mon Dec 14, 2009 12:33 pm Subject: Select only the first group of records |
Hi,
I search a trick to extract (only) the first group of records in a file. The not selected should be saved in a separate output data set.
The input file has no headers or trailers. The group-key ... |
Topic: Create Total-Amount from two different keys |
hungerbuehler
Replies: 4
Views: 2137
|
Forum: Utilities Posted: Mon Dec 14, 2009 11:45 am Subject: Create Total-Amount from two different keys |
Hi Frank,
Thank you very much for your support.
With your example....it works!!!
Best Regards
Hungerbuehler |
Topic: Create Total-Amount from two different keys |
hungerbuehler
Replies: 4
Views: 2137
|
Forum: Utilities Posted: Wed Dec 09, 2009 12:49 am Subject: Create Total-Amount from two different keys |
many thanks for the answer,
The input file has following format:
RECFM=FB
LRECL=200
Are you trying to get separate totals for each "key" in each of the two columns? Why do you get ne ... |
Topic: Create Total-Amount from two different keys |
hungerbuehler
Replies: 4
Views: 2137
|
Forum: Utilities Posted: Tue Dec 08, 2009 12:53 pm Subject: Create Total-Amount from two different keys |
Hi all,
I'm trying to create a file with a new colums totals. One of the sum-calculation is negative:
This is an example from the input-file:
All numbers are in PD-format, length=16
Start-pos ... |
Topic: Add header-records into a data-file |
hungerbuehler
Replies: 5
Views: 2920
|
Forum: Utilities Posted: Tue Feb 10, 2009 4:14 am Subject: Add header-records into a data-file |
Hi Kolusu,
Many thanks for your help. It works perfect.
DFSORT and this forum are great!
Best regards |
Topic: Add header-records into a data-file |
hungerbuehler
Replies: 5
Views: 2920
|
Forum: Utilities Posted: Tue Feb 03, 2009 2:16 pm Subject: Add header-records into a data-file |
Hi kolusu,
Both files (header-file and data-file) have the RECFM=FB and the LRECL=80
many thanks.
Best regards
Daniel Hungerbuehler |
Topic: Add header-records into a data-file |
hungerbuehler
Replies: 5
Views: 2920
|
Forum: Utilities Posted: Tue Feb 03, 2009 12:46 pm Subject: Add header-records into a data-file |
Hi all,
I'm trying to merge 2 files.
The first file is a header-file, the second is a data-file.
In both files are the first four character the group-identification (Id)
Header-file:
0001 ... |
Topic: remove a part (with same key) from the Dataset |
hungerbuehler
Replies: 5
Views: 3065
|
Forum: Utilities Posted: Tue Mar 27, 2007 11:21 pm Subject: remove a part (with same key) from the Dataset |
Many thanks for your help. It works perfect.
DFSORT and this forum are great!
Best regards
hungerbuehler |
Topic: remove a part (with same key) from the Dataset |
hungerbuehler
Replies: 5
Views: 3065
|
Forum: Utilities Posted: Mon Mar 26, 2007 6:42 am Subject: remove a part (with same key) from the Dataset |
Many many thanks. It works fantastic.
It was a very good idea with the seqnum.
Today i saw following test-cases:
There are several header-lines for a block.
An example:
Inputfile:
1000 h ... |
Topic: remove a part (with same key) from the Dataset |
hungerbuehler
Replies: 5
Views: 3065
|
Forum: Utilities Posted: Sun Mar 25, 2007 1:00 pm Subject: remove a part (with same key) from the Dataset |
Hi all,
I m trying to remove the first record-block with the same key. The key changes with every job-run.
The key is in the digits 1-4. But the key changes every job-run. I need only the records ... |
|