Author |
Message |
Topic: Omit cond with High values. |
Ram22
Replies: 16
Views: 13645
|
Forum: Utilities Posted: Fri Apr 20, 2007 12:22 pm Subject: Omit cond with High values. |
Thanks Kolusu,
This worked. Sorry Mervyn, I did not notice the missing 'CH' . Thanks again every one.
Regards & Thanks,
Ram |
Topic: Omit cond with High values. |
Ram22
Replies: 16
Views: 13645
|
Forum: Utilities Posted: Fri Apr 20, 2007 10:23 am Subject: Omit cond with High values. |
Mervyn,
This code, for Syncsort says as Invalid format. Below is the error
SYSIN :
SORT FIELDS=(33,46,CH,A) ... |
Topic: Omit cond with High values. |
Ram22
Replies: 16
Views: 13645
|
Forum: Utilities Posted: Thu Apr 19, 2007 3:50 pm Subject: Omit cond with High values. |
Phantom,
My requirement is perfect as you thought. I need to omit a record only if it has all 261 positions with high values.
Regards & Thanks,
Ram |
Topic: Position Problem with TRAILER1 |
Ram22
Replies: 3
Views: 2039
|
Forum: Utilities Posted: Thu Apr 19, 2007 3:42 pm Subject: Position Problem with TRAILER1 |
Thanks a lot Frank and Kolusu.
Kolusu,
Just to clarify,
In the I posted
The problem I am facing here is the record count is starting from 264 instead of 263
not 261
Any ways thanks both fo ... |
Topic: Position Problem with TRAILER1 |
Ram22
Replies: 3
Views: 2039
|
Forum: Utilities Posted: Thu Apr 19, 2007 2:57 pm Subject: Position Problem with TRAILER1 |
Hi,
I am trying the following sort statement.
SORT FIELDS=COPY
OUTFIL INCLUDE=ALL,
TRAILER ... |
Topic: Omit cond with High values. |
Ram22
Replies: 16
Views: 13645
|
Forum: Utilities Posted: Thu Apr 19, 2007 12:15 pm Subject: Omit cond with High values. |
Amarqulies,
My requirement is to check for the first 261, thats the reason I am facing problem. Otherwise to chek only one position your solution might have worked.
Ram |
Topic: Omit cond with High values. |
Ram22
Replies: 16
Views: 13645
|
Forum: Utilities Posted: Thu Apr 19, 2007 10:40 am Subject: Omit cond with High values. |
Mervyn, I am extreamly sorry but I could not understand your suggestion. Can you please explain in detail.
Ram |
Topic: Omit cond with High values. |
Ram22
Replies: 16
Views: 13645
|
Forum: Utilities Posted: Thu Apr 19, 2007 10:05 am Subject: Omit cond with High values. |
All,
Any help is appreciable. I am trying many combinations to achieve this. I tried taking the solutions which involves similar situations, but could end without result.
Pls let me know if I ... |
Topic: Omit cond with High values. |
Ram22
Replies: 16
Views: 13645
|
Forum: Utilities Posted: Wed Apr 18, 2007 3:59 pm Subject: Omit cond with High values. |
Just to add more, the sort card I used Is:
SORT FIELDS=(33,46,CH,A)
SUM FIELDS=NONE,XSUM
OMIT COND=(1,100,CH,EQ,X'FF')
Again, to explain more I am trying to f ... |
Topic: Omit cond with High values. |
Ram22
Replies: 16
Views: 13645
|
Forum: Utilities Posted: Wed Apr 18, 2007 3:50 pm Subject: Omit cond with High values. |
Hi all,
I am using Syncsort. I tried using the below Omit cond to remove the record which has high values in the first 262 positions. After the sort the record still exists. I tried reducing the nu ... |
Topic: frm 2 files based on key match apnd clm values : SORT |
Ram22
Replies: 10
Views: 4994
|
Forum: Utilities Posted: Tue Mar 14, 2006 8:06 pm Subject: frm 2 files based on key match apnd clm values : SORT |
Kolusu,
This explanation helped me a lot. Thanks a lot again.
Regards & Thanks,
Ram |
Topic: frm 2 files based on key match apnd clm values : SORT |
Ram22
Replies: 10
Views: 4994
|
Forum: Utilities Posted: Mon Mar 13, 2006 11:08 pm Subject: frm 2 files based on key match apnd clm values : SORT |
Kolusu,
I just want to add one more clarification in answering one of your questions
3. What is the pos and format of the fields which needs to merged and compared?
Pos: 18 and length is 5 &am ... |
Topic: frm 2 files based on key match apnd clm values : SORT |
Ram22
Replies: 10
Views: 4994
|
Forum: Utilities Posted: Mon Mar 13, 2006 9:22 pm Subject: frm 2 files based on key match apnd clm values : SORT |
Kolusu,
Its really a wonderful sort. But I am a basic user of Sort. I tried to understand first step of handling the file with duplicates, but believe me it is very complex for me to understand.
... |
Topic: frm 2 files based on key match apnd clm values : SORT |
Ram22
Replies: 10
Views: 4994
|
Forum: Utilities Posted: Fri Mar 10, 2006 11:19 am Subject: frm 2 files based on key match apnd clm values : SORT |
Thanks in tons Kolusu. I shall try this and come back with results. Thanks again.
Regards & Thanks,
Ram |
Topic: frm 2 files based on key match apnd clm values : SORT |
Ram22
Replies: 10
Views: 4994
|
Forum: Utilities Posted: Thu Mar 09, 2006 5:18 pm Subject: frm 2 files based on key match apnd clm values : SORT |
Kolusu,
Please find the answers below:
1. What is the max no: of dups for each key in file B?
5
2. what is the LRECL and RECFM of both input and output files
LRECL : 80
RECFM: FB ... |
|