MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 33 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Omit cond with High values.
Ram22

Replies: 16
Views: 13645

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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 ...
 
Page 1 of 3 Goto page 1, 2, 3  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group