View previous topic :: View next topic |
Author |
Message |
manesh Beginner
Joined: 11 Apr 2006 Posts: 12 Topics: 5
|
Posted: Mon Feb 11, 2008 4:49 pm Post subject: Inspect a field and extract using Outrec in ICETOOL/Sort |
|
|
Hi,
I have have field in the file starting at 100 with length 30.I need to inspect each byte for space and extract till that point (Space) using Outrec.
INPUT
xxxxxxxxxxx xxxxxxx
Output should be
xxxxxxxxxxx
Please help in doing this in ICETOOL Or Sort.
I tried searching in the forum but couldn't find any thing which helps.
Regards,
Manesh. |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
Posted: Mon Feb 11, 2008 5:02 pm Post subject: |
|
|
manesh,
Try the following DFSORT control cards
Code: |
//SYSIN DD *
SORT FIELDS=COPY
INREC PARSE=(%00=(ABSPOS=100,ENDBEFR=C' ',FIXLEN=030)),
OVERLAY=(100:%00)
|
Hope this helps... _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
manesh Beginner
Joined: 11 Apr 2006 Posts: 12 Topics: 5
|
Posted: Mon Feb 11, 2008 5:40 pm Post subject: |
|
|
Kolusu,
Thanks a Lot for your reply.
I am getting following error, Code: |
SYNCSORT FOR Z/OS 1.1BR TPF2B U.S. PATENTS: 4210961, 5117
z/OS
PRODUCT LICENSED FOR CPU
SYSIN :
SORT FIELDS=COPY
INREC PARSE=(%00=(ABSPOS=13,ENDBEFR=C' ',FIXLEN=020)),
*
OVERLAY=(13:%00)
WER268A INREC STATEMENT : SYNTAX ERROR
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
|
Starting position of field is 13 and length is 20.
Do i need to use different Syntax for SYNCSORT.
Regards,
Manesh |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
Posted: Mon Feb 11, 2008 6:06 pm Post subject: |
|
|
manesh,
My job works fine with DFSORT which has supported the PARSE function since April, 2006. You are using Syncsort.
I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort. _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
manesh Beginner
Joined: 11 Apr 2006 Posts: 12 Topics: 5
|
Posted: Tue Feb 12, 2008 11:08 am Post subject: |
|
|
Kolusu,
Thanks for your support.
I can also use SAS or EASYTRIEVE.
Please help me solving this using SAS or EASYTRIEVE.
Starting position of field is 13 and length is 20.
Regards,
Manesh |
|
Back to top |
|
|
amargulies Beginner
Joined: 10 Jan 2007 Posts: 123 Topics: 0
|
Posted: Tue Feb 12, 2008 11:19 am Post subject: |
|
|
manesh wrote: | SYNCSORT FOR Z/OS 1.1BR TPF2B |
manesh wrote: | Do i need to use different Syntax for SYNCSORT |
You are running an older version of SyncSort. PARSE is supported in SyncSort for z/OS 1.3. _________________ Alissa Margulies
SyncSort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com |
|
Back to top |
|
|
|
|