|
View previous topic :: View next topic
|
| Author |
Message |
rexx77
New User
Joined: 14 Apr 2008
Posts: 78
Location: Mysore
|
|
|
|
Hi Folks,
I am trying to use SYNCSORT Data dictionary feature , as my upstream files are created with meta attributes information . I am trying to extract the required fields using the column names available in SYMNAMES DD.
SYMNAMES Definition:
| Code: |
Asset_name,1,50,CH
Field1,51,32,ZD
Field2,*,5000,CH
Field3,*,10,CH
|
Sort statement is like below:
| Code: |
SORT FIELDS =(Asset name, A)
OUTREC FIELDS=(Asset_Name, 10X, Field1,10X,Field2,Field3)
|
1. Field 1 in input file is 32 length and ZD format, i want to convert that to 14 Packed decimal in the output. Do you know how to specify the conversion while mentioning the outrec fields
2. Field2 is around 5000 length and CHAR field. I want to extract first 100 characters from this field. How to do this?
Appreciate your inputs. |
|
| Back to top |
|
 |
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2286
Location: USA
|
|
|
|
Answer to 1.
After RTFM (did you read it?) it's getting clear that field format is converted (from ZD to PD) as
| Code: |
| FIELDS=(.....51,32,ZD,PD[,LENGTH=nn],.......) |
Same thing with dictionary name(s)
| Code: |
| FIELDS=(.....Field1,PD[,LENGTH=nn],.......) |
|
|
| Back to top |
|
|
rexx77
New User
Joined: 14 Apr 2008
Posts: 78
Location: Mysore
|
|
|
|
I added Length field as suggested , Here is my modified SORT statement
| Code: |
Field1,PD(,LENGTH=14),
|
It was substituted as below, during run time.
| Code: |
12,32,PD(,LENGTH=14)
|
I got SYNTAX error.
WER271A OUTREC STATEMENT : NUMERIC FIELD ERROR
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000 |
|
| Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2286
Location: USA
|
|
|
|
Correct syntax looks like this (copied from the manual)
| Code: |
OUTREC FIELDS=(1,10,ZD,PD,
11,4,FI,ZD,LENGTH=8) |
Please RTFM carefully
My square brackets used to specify the "optional parameter LENGTH", but not to be replaced with regular parenthesis!  |
|
| Back to top |
|
|
|
|
  |
All times are GMT + 6 Hours |
|
