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 

DFSORT include condition
Goto page Previous  1, 2, 3
 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities
View previous topic :: View next topic  
Author Message
Magesh_J
Intermediate


Joined: 21 Jun 2014
Posts: 259
Topics: 54

PostPosted: Thu Apr 09, 2015 12:13 pm    Post subject: Reply with quote

Thanks for the quick response and advise.

Yes, we need Short records into the output.

We should not modify the input file at any cost. i.e padding binary zeros or space or etc. Because if we do so, then output file will be modified.

I thought VLSCMP will not modify the input record.

please advise.

Thanks
Magesh
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12401
Topics: 75
Location: San Jose

PostPosted: Thu Apr 09, 2015 1:14 pm    Post subject: Reply with quote

Magesh_J wrote:

Yes, we need Short records into the output.

We should not modify the input file at any cost. i.e padding binary zeros or space or etc. Because if we do so, then output file will be modified.

I thought VLSCMP will not modify the input record.


Magesh_J,

VLSCMP does not modify the record, but lets say you are validating a field at position 72 with an INCLUDE condition but the record is only 65 bytes. i.e the record does not even contain the field that you are validating. Since you have VLSCMP the short record is padded with binary zeros. With relational condition LE you are including that record in the output which I doubt you really want.
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Magesh_J
Intermediate


Joined: 21 Jun 2014
Posts: 259
Topics: 54

PostPosted: Thu Apr 09, 2015 2:02 pm    Post subject: Reply with quote

Hi Kolusu,

Is it condition NE or LE.

The actually scenario is The 'Z' record always have record length more than 380. Which mean when DFSORT validate 'Z' records, ideally it will not be a short record.

But rest of the records like R,V,etc may have Short records.

Regards,
Magesh
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12401
Topics: 75
Location: San Jose

PostPosted: Thu Apr 09, 2015 3:29 pm    Post subject: Reply with quote

Magesh_J wrote:
Hi Kolusu,

Is it condition NE or LE.


Magesh_J,

It is BOTH. You comparing padded binary zero's against Space. So Binary zeros are NOT equal and also LESS than Space. So both conditions will select the short records
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Magesh_J
Intermediate


Joined: 21 Jun 2014
Posts: 259
Topics: 54

PostPosted: Thu Apr 16, 2015 10:04 am    Post subject: Reply with quote

Hi Kolusu,

Yes, I need all short records into the output.

I need to make sure if these 5 fields are not having spaces.

If five fields are having spaces, i need to exclude those records.

If any of these fields are not spaces.. i.e binary zero or a value or etc i need those output into the field.

in other way, I am authorized to ignore only 'Z' records having spaces in all those 5 fields.


Regards,
Magesh
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities All times are GMT - 5 Hours
Goto page Previous  1, 2, 3
Page 3 of 3

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group