Author |
Message |
Topic: DFSORT- Selective Detail Records sorting with Headers |
dips
Replies: 1
Views: 1218
|
Forum: Utilities Posted: Wed Jan 10, 2007 4:14 am Subject: DFSORT- Selective Detail Records sorting with Headers |
Hi,
I am trying to sort a file using DFSORT. But the difficult part is that I have Record type 1 records and Record type 2 records. Only the record type 2 records should be sorted based on (4,4,CH, ... |
Topic: FB to VB coversion using DFSORT |
dips
Replies: 2
Views: 2004
|
Forum: Utilities Posted: Thu Oct 19, 2006 3:07 pm Subject: FB to VB coversion using DFSORT |
Hi All,
My requirement is to convert a FB file of 562 to VB file.
I know that the option FTOV is avialable which can be used. But the catch here is that when i convert its retaining the spaces a ... |
Topic: Split a file into 3 files based on key using DFSORT |
dips
Replies: 9
Views: 4585
|
Forum: Utilities Posted: Wed Jul 12, 2006 11:48 pm Subject: Split a file into 3 files based on key using DFSORT |
Thanks all for your responses.
The problem when I ran this job with my file was that there are too many records for each key. And as i was using the size of sequence number as 2 digits for every 100 ... |
Topic: Split a file into 3 files based on key using DFSORT |
dips
Replies: 9
Views: 4585
|
Forum: Utilities Posted: Wed Jul 12, 2006 7:22 am Subject: Split a file into 3 files based on key using DFSORT |
Hi,
Yeah Its working when I gave the data in SYSIN directly and tried.
When I tried it with my file it isnt working.
Let me check it out again.
Thanks a lot.
Deepa |
Topic: SORT work files |
dips
Replies: 4
Views: 2034
|
Forum: Utilities Posted: Wed Jul 12, 2006 6:56 am Subject: SORT work files |
Hi,
This is the sort job i submitted without WORK files and the input has 8103330. And I got the message saying Sort capacity exceeded. And when I gave Work files and ran it again, it ran to succes ... |
Topic: Split a file into 3 files based on key using DFSORT |
dips
Replies: 9
Views: 4585
|
Forum: Utilities Posted: Wed Jul 12, 2006 6:23 am Subject: Split a file into 3 files based on key using DFSORT |
Frank,
When i tried this example using the data I have, I found that each output file has more than 3 records. The reason being, that we restart the Sequence number after very 3 records and the rec ... |
Topic: Split a file into 3 files based on key using DFSORT |
dips
Replies: 9
Views: 4585
|
Forum: Utilities Posted: Tue Jul 04, 2006 5:32 am Subject: Split a file into 3 files based on key using DFSORT |
Thanks Frank!! |
Topic: SORT work files |
dips
Replies: 4
Views: 2034
|
Forum: Utilities Posted: Tue Jul 04, 2006 3:38 am Subject: SORT work files |
Hi,
Using Sort work files lets us process more records and also I believe it speeds up sorting.
I there any startndard to be followed while giving the size of Work files?
Also how do we decid ... |
Topic: Split a file into 3 files based on key using DFSORT |
dips
Replies: 9
Views: 4585
|
Forum: Utilities Posted: Mon Jul 03, 2006 9:44 am Subject: Split a file into 3 files based on key using DFSORT |
Hi,
I have a file of the below format.
001AAA
001AAB
001AAC
001AAD
001AAE
001AAF
001AAG
001AAH
001AAI
001AAJ
002BAA
002BAB
002BAC
002BAD
002BAE
002BAF
003BAA
003BAB
003BAC
003 ... |
|