| View previous topic :: View next topic |
| Author |
Message |
Magesh_J Intermediate

Joined: 21 Jun 2014 Posts: 259 Topics: 54
|
Posted: Thu Apr 09, 2015 12:13 pm Post subject: |
|
|
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 |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12401 Topics: 75 Location: San Jose
|
Posted: Thu Apr 09, 2015 1:14 pm Post subject: |
|
|
| 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 |
|
 |
Magesh_J Intermediate

Joined: 21 Jun 2014 Posts: 259 Topics: 54
|
Posted: Thu Apr 09, 2015 2:02 pm Post subject: |
|
|
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 |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12401 Topics: 75 Location: San Jose
|
Posted: Thu Apr 09, 2015 3:29 pm Post subject: |
|
|
| 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 |
|
 |
Magesh_J Intermediate

Joined: 21 Jun 2014 Posts: 259 Topics: 54
|
Posted: Thu Apr 16, 2015 10:04 am Post subject: |
|
|
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 |
|
 |
|
|
|