View previous topic :: View next topic
|
Author |
Message |
srinathds83
New User
Joined: 17 Jul 2007 Posts: 41 Location: pune
|
|
|
|
Hi,
I have written below Sort card for getting the common record from file 1 and 2, unpaired from File 1 and Unpaired from File 2.
Code: |
JOINKEYS FILES=F1,FIELDS=(1,300,A)
JOINKEYS FILES=F2,FIELDS=(1,300,A)
JOIN UNPAIRED,F1,F2
REFORMAT FIELDS=(F1:1,300,F2:1,300,?)
OPTION COPY
OUTFIL FNAMES=OUT12,INCLUDE=(601,1,CH,EQ,C'B'),
BUILD=(1,300)
OUTFIL FNAMES=OUT01,INCLUDE=(601,1,CH,EQ,C'1'),
BUILD=(1,300)
OUTFIL FNAMES=OUT02,INCLUDE=(601,1,CH,EQ,C'2'),
BUILD=(301,300) |
i am getting Below error:
Code: |
JOINKEYS FILES=F1,FIELDS=(1,300,A)
JOINKEYS FILES=F2,FIELDS=(1,300,A)
JOIN UNPAIRED,F1,F2
REFORMAT FIELDS=(F1:1,300,F2:1,300,?)
*
OPTION COPY
OUTFIL FNAMES=OUT12,INCLUDE=(601,1,CH,EQ,C'B'),
BUILD=(1,300)
OUTFIL FNAMES=OUT01,INCLUDE=(601,1,CH,EQ,C'1'),
BUILD=(1,300)
OUTFIL FNAMES=OUT02,INCLUDE=(601,1,CH,EQ,C'2'),
BUILD=(301,300)
WER161B ALTERNATE PARM USED
WER268A REFORMAT STATEMENT: SYNTAX ERROR |
Is ? is not allowed to use in Sort card? Please correct |
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
Quote: |
Joined: 17 Jul 2007 |
Being in forum for 6 years you still not sure where to ask what
Does synsort allow '?' ?
what does the manual say about them? |
|
Back to top |
|
|
srinathds83
New User
Joined: 17 Jul 2007 Posts: 41 Location: pune
|
|
|
|
Pandora-Box wrote: |
Quote: |
Joined: 17 Jul 2007 |
Being in forum for 6 years you still not sure where to ask what
Does synsort allow '?' ?
what does the manual say about them? |
I have written the Sort card according to the manual. but while running it stating Syntax error. Please help me out on this. |
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
Probably you might be still using old version |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
? is DFSORT only. Look at Syncsort examples here of JOINKEYS to see how to do the same thing (long way around, and you have to be careful). |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
srinathds83,
The Syncsort equivalent (UNTESTED) of your card will look somewhat like this.
Code: |
JOINKEYS FILES=F1,FIELDS=(1,300,A)
JOINKEYS FILES=F2,FIELDS=(1,300,A)
JOIN UNPAIRED,F1,F2
REFORMAT FIELDS=(F1:1,300,F2:1,300),FILL=X'FF'
SORT FIELDS=COPY
OUTFIL FNAMES=OUT01,INCLUDE=(301,1,CH,EQ,X'FF'),
BUILD=(001,300)
OUTFIL FNAMES=OUT02,INCLUDE=(001,1,CH,EQ,X'FF'),
BUILD=(301,300)
OUTFIL FNAMES=OUT12,SAVE,BUILD=(1,300) |
|
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
That should do it, Arun.
Good to see you back. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Bill Woodger wrote: |
Good to see you back. |
Thanks Bill. nice to see you all |
|
Back to top |
|
|
|
|