|
View previous topic :: View next topic
|
| Author |
Message |
G SRINIVASA RAO
New User
Joined: 14 Sep 2016
Posts: 3
Location: INDIA
|
|
|
|
Hi,
Could someone help me on error for the sort card where i am striping few columns and sorting 2 fields of I/P VB file(LRECL=2016) and writing to O/P VB file(LRECL=2004). And also file contains a trailer.
Sortcard:
| Code: |
OPTION VLSHRT
INREC IFTHEN=(WHEN=INIT,BUILD=(1,4,5:C'1',6:5)),
IFTHEN=(WHEN=(6,7,CH,EQ,C'0000000'),OVERLAY=(5:C'9'))
SORT FIELDS=(5,1,CH,A,18,7,CH,A,32,5,CH,A)
OUTREC BUILD=(1,4,6:18,2000) |
Error:
| Code: |
INREC RECORD LENGTH = 2017
POTENTIALLY INEFFICIENT USE OF INREC
OUTREC RECORD LENGTH = 2005 |
Thanks in advance..
Thanks!
Srinivas
Coded |
|
| Back to top |
|
 |
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK
|
|
|
|
What do you mean by'striping' (to add stripes) or do you mean 'stripping'?
Please show the whole message including the message identifier. There does not appear to be an error there but a warning. And, based on those 3 lines, what have you done to try and resolve it - apart from posting on a forum? |
|
| Back to top |
|
|
G SRINIVASA RAO
New User
Joined: 14 Sep 2016
Posts: 3
Location: INDIA
|
|
|
|
Hi Nic,
Its a typo. It is 'stripping'
Below code worked for me. removed record length from Outrec build.
| Code: |
OPTION VLSHRT
INREC IFTHEN=(WHEN=INIT,BUILD=(1,4,5:C'1',6:5)),
IFTHEN=(WHEN=(6,7,CH,EQ,C'0000000'),OVERLAY=(5:C'9'))
SORT FIELDS=(5,1,CH,A,18,7,CH,A,32,5,CH,A)
OUTREC BUILD=(1,4,6:18)
|
Thanks!
Srinivas
Code'd |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
I don't think the VLSHRT is giving you any benefit.
The warning was indeed caused by the erroneous 2000. However, it looks as though you could cut down further in INREC as there is data getting into the SORT which is not on the output records. |
|
| Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2287
Location: USA
|
|
|
|
G SRINIVASA RAO,
The right sequence of efforts should be:
1) read SYNCSORT manuals, and/or other related topics/forums
2) code the statements in accordance with clearly defined rules
3) try to run your job
4) analyze the error message(s); consult with the manuals; try to fix them
5) ask at the forum what you did wrong?
Actually what you're doing is the following
1) code whatever comes first to your mind
2) run the job you have no idea about
3) ask at the forum why something you don't understand is not working somehow you don't know how? |
|
| Back to top |
|
|
G SRINIVASA RAO
New User
Joined: 14 Sep 2016
Posts: 3
Location: INDIA
|
|
|
|
Thanks Tyrannosaurus for your suggestion.
Only after trying all the options which you mentioned above I contacted the forum. In parallel I was trying to resolve the issue.
I have no intention to waste anyone's time.
thanks!
Srinivasa Rao |
|
| Back to top |
|
|
|
|
  |
All times are GMT + 6 Hours |
|
