View previous topic :: View next topic
|
Author |
Message |
jpdeshai
New User
Joined: 24 Jun 2007 Posts: 57 Location: US
|
|
|
|
Hi,
I have a problem as given below.(I tried searching in the forum, but could not get exact solution).
My input file length is 400 and I need to check the each record (all positions) in the file and if any records contains any GERMAN special characters (eg: ä, Ä, Ö) in any location that record needs to be Omitted and written into another file.
Because we are not able type the German special characters in the parm
card we need to check the characters in Hex format
There ASCII and EBCIDIC values ofr German sepcial Chars are given below FYR:
05 EBCDIC-SPL-CHAR-GERMAN.
10 FILLER PIC X(10) VALUE X'4363517153735777CCEC'.
10 FILLER PIC X(04) VALUE X'DCFC59B1'.
05 ASCII-SPL-CHAR-GERMAN.
10 FILLER PIC X(10) VALUE X'E4C4E9C9EBCBEFCFF6D6'.
10 FILLER PIC X(04) VALUE X'FCDCDFA3'.
Please let me know how to do this using SYNCSORT.
JP |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
Syncsort does allow for Substring Comparisons. With multiple outputs, it should be do-able.... |
|
Back to top |
|
|
jpdeshai
New User
Joined: 24 Jun 2007 Posts: 57 Location: US
|
|
|
|
Hi CICS Guy,
You are right. I tried with ALTSEQ, but could not get the solution.
Can any one help me out of this?
Thanks,
JP |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
jpdeshai wrote: |
You are right. I tried with ALTSEQ, but could not get the solution. |
Huh?
What does ALTSEQ have to do with SS?
Have you looked at the manual?
If you need a manual a phone call or email from the company's email should do the trick...
Check out this link for more information... |
|
Back to top |
|
|
jpdeshai
New User
Joined: 24 Jun 2007 Posts: 57 Location: US
|
|
|
|
If I am not worng, ALTSEQ gives us the facility to compare each char and convert/translate to another format right?
The Link you have given me did not serve my problem.
In my case, I do not know the location. the Special Char can be in any position and out of 14 Chars, any char can come in any postion.
Can you please suggest me? |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
ALTSEQ changes the sort sequence, use SS for substring comparisons...
Check the manual. |
|
Back to top |
|
|
Ajay Baghel
Active User
Joined: 25 Apr 2007 Posts: 206 Location: Bangalore
|
|
|
|
If you want to write records which remain after omitting records containing german characters to a file say 'goodfile':
Code: |
//SYSIN DD *
OPTION COPY
OUTFIL FNAMES=GOODFILE,OMIT=(1,80,SS,EQ,X'43',OR,
1,80,SS,EQ,X'63',OR,
1,80,SS,EQ,X'EC')
/* |
|
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
you can not substitute a single char for the german characters with the umlaut. the umlaut signifies that the char is an abbreviation.
ä = ae
ö = oe
ü = ue |
|
Back to top |
|
|
jpdeshai
New User
Joined: 24 Jun 2007 Posts: 57 Location: US
|
|
|
|
Hi Ajay,
Thanks for the Sort Card. It is working perfectly for me.
I didn't knew about the 'SS' function.
Thanks a lot. |
|
Back to top |
|
|
|