|
|
| Author |
Message |
rkarthik22
New User
Joined: 18 Apr 2009
Posts: 34
Location: india
|
|
|
|
Hi all,
Below is the one to remove the leading spaces of the field and left shift the values.
| Code: |
1,11,SQZ=(SHIFT=LEFT,MID=C' ')
|
Can anyone pls provide for, Removing Leading Zeroes and left shift the values
Field Position - 1 to 11
type - numeric
LRECL - 4000
As of now, i am using some thing like this:
| Code: |
1,11,SQZ=(SHIFT=LEFT,MID=C'0')
|
but the zeroes are not removed...
Thanks in Advance. |
|
| Back to top |
|
 |
References
|
|
 |
Sambhaji
Active Member
Joined: 16 Feb 2007
Posts: 841
Location: Pune, India
|
|
|
|
| Quote: |
As of now, i am using some thing like this:
| Code: |
| 1,11,SQZ=(SHIFT=LEFT,MID=C'0') |
but the zeroes are not removed...
|
Yes. Correct. It is working as expected. 
You need to check respective sort product manual to check for what MID is used. I think you have misunderstood.. |
|
| Back to top |
|
|
rkarthik22
New User
Joined: 18 Apr 2009
Posts: 34
Location: india
|
|
|
|
I will check the Manual.
Our shop uses SYNCSORT FOR Z/OS 1.3.0.2R
(I also tried with the below one
SQZ=(SHIFT=LEFT,PREBLANK=C'0')
no use...)
Thanks for your Help!! |
|
| Back to top |
|
|
|
|
