Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Question on SKIP=nL for Syncsort

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Michael Angelo Pagala

New User


Joined: 02 Mar 2007
Posts: 34
Location: somewhere in the middle

PostPosted: Thu Oct 28, 2010 7:26 pm    Post subject: Question on SKIP=nL for Syncsort
Reply with quote

Good Day,

I would just like to know what is wrong with the sort card below. I am not sure why the SKIP=nL parameter does not reflect on my output.

Sample Input:
Code:
MTC0000100690000067597
MTC0000300070001371906
MTC0000300070001970048
UN10000300076000288297
UN20000300076000288298
MTC0000400010001246826


Sort Card:
Code:
   SORT FIELDS=(1,3,CH,A,4,19,CH,A)                                 
   OUTFIL REMOVECC,                                                 
          OUTREC=(1:4,36,4X),                                       
          SECTIONS=(1,3,SKIP=2L,                                     
          HEADER3=('ACCOUNT NUMBER'),                               
          TRAILER3=('NUM OF RECS: ',COUNT=(EDIT=(TT)))),             
          HEADER2=(' THIS IS A TEST ',/,'-----------------------',2/)


Output
Code:
 THIS IS A TEST       
-----------------------
                       
                       
ACCOUNT NUMBER         
0000100690000067597   
0000300070001371906   
0000300070001970048   
0000400010001246826   
NUM OF RECS: 04       
ACCOUNT NUMBER         
0000300076000288297   
NUM OF RECS: 01       
ACCOUNT NUMBER         
0000300076000288298   
NUM OF RECS: 01       


I know I can put a 2/ on the header 3 to achieve the result I want..but I just want to know why the SKIP=nL is not applied.

I have tried reposition headers,trailers or anything I can think of..even if I think it does not matter..

using SYNCSORT FOR Z/OS 1.3.2.1R

thanks in advance
Back to top
View user's profile Send private message

Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2158
Location: @my desk

PostPosted: Thu Oct 28, 2010 8:11 pm    Post subject:
Reply with quote

Quote:
I know I can put a 2/ on the header 3 to achieve the result I want..but I just want to know why the SKIP=nL is not applied
What is the result you want? Have you posted it?
Back to top
View user's profile Send private message
Michael Angelo Pagala

New User


Joined: 02 Mar 2007
Posts: 34
Location: somewhere in the middle

PostPosted: Thu Oct 28, 2010 8:16 pm    Post subject:
Reply with quote

Arun Raj wrote:
Quote:
I know I can put a 2/ on the header 3 to achieve the result I want..but I just want to know why the SKIP=nL is not applied
What is the result you want? Have you posted it?


sorry about that..I just want to put two lines in between section

so the output should be like

Code:
 THIS IS A TEST       
-----------------------
                       
                       
ACCOUNT NUMBER         
0000100690000067597   
0000300070001371906   
0000300070001970048   
0000400010001246826   
NUM OF RECS: 04

       
ACCOUNT NUMBER         
0000300076000288297   
NUM OF RECS: 01   

     
ACCOUNT NUMBER         
0000300076000288298   
NUM OF RECS: 01


that is what I am expecting from the SKIP=2L parameter
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2158
Location: @my desk

PostPosted: Thu Oct 28, 2010 8:55 pm    Post subject:
Reply with quote

Just I am about to leave from office. I will check it later and get back in case you have n't reached a solution
Back to top
View user's profile Send private message
Michael Angelo Pagala

New User


Joined: 02 Mar 2007
Posts: 34
Location: somewhere in the middle

PostPosted: Thu Oct 28, 2010 8:59 pm    Post subject:
Reply with quote

the sort card is in the 1st post arun..thanks
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2158
Location: @my desk

PostPosted: Fri Oct 29, 2010 6:21 pm    Post subject:
Reply with quote

From what I saw, you need to OMIT the REMOVECC and run your job. The ANSI carriage control character at pos-1 tells the printer to leave as many blank lines after printing each SECTION. Below are the code descriptions.
Code:
Code  Interpretation
blank Space one line before printing
0     Space two lines before printing
-     Space three lines before printing
+     Suppress space before printing
Back to top
View user's profile Send private message
Michael Angelo Pagala

New User


Joined: 02 Mar 2007
Posts: 34
Location: somewhere in the middle

PostPosted: Tue Nov 02, 2010 7:17 am    Post subject:
Reply with quote

ok arun I will try that what you have suggested..thanks!
Back to top
View user's profile Send private message
Michael Angelo Pagala

New User


Joined: 02 Mar 2007
Posts: 34
Location: somewhere in the middle

PostPosted: Tue Nov 02, 2010 3:49 pm    Post subject:
Reply with quote

I removed the REMOVECC parameter and the SKIP=nL worked..but I don't need the Carriage Controls..I guess I just need to add spaces above the headers..

so I guess SKIP=nL will not work with REMOVECC.

Quote:
The REMOVECC parameter generates reports that do not include ANSI carriage control
characters that specify printer actions (for example, skipping a line or ejecting a page).

quoted from the manual

thanks for the help again Arun
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2158
Location: @my desk

PostPosted: Tue Nov 02, 2010 4:19 pm    Post subject:
Reply with quote

You're welcome icon_smile.gif
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Nov 02, 2010 8:52 pm    Post subject:
Reply with quote

Hello,

Quote:
but I don't need the Carriage Controls..
To have the sort generate the spacing you want you do need "the Carriage Controls". . .

Why might you believe otherwise?

Why generate extra data lines when the "skip" provides exactly what you show you want?
Back to top
View user's profile Send private message
Michael Angelo Pagala

New User


Joined: 02 Mar 2007
Posts: 34
Location: somewhere in the middle

PostPosted: Tue Nov 02, 2010 9:27 pm    Post subject:
Reply with quote

Hi dick,

If I understand correctly the REMOVECC removes the ANSI carriage control characters that specify printer actions..since I will just show and give the report in a flat file..I do not want the CC chars to be shown..

I just assumed this because when I remove the REMOVECC parameter the ouput did skip every section but have a single space in between them even if I declared SKIP=2L but it has a special char in between..

I tried SKIP=3L and the same happened but with a diff char in between..and tried SKIP=5L also..

output of SKIP=2L
Code:
1 THIS IS A TEST       
 -----------------------
                       
                       
 ACCOUNT NUMBER         
 0000100690000067597   
 0000300070001371906   
 0000300070001970048   
 0000400010001246826   
 NUM OF RECS: 04       
0                       
 ACCOUNT NUMBER         
 0000300076000288297   
 NUM OF RECS: 01       
0                       
 ACCOUNT NUMBER         
 0000300076000288298   
 NUM OF RECS: 01


output of SKIP=3L
Code:
1 THIS IS A TEST       
 -----------------------
                       
                       
 ACCOUNT NUMBER         
 0000100690000067597   
 0000300070001371906   
 0000300070001970048   
 0000400010001246826   
 NUM OF RECS: 04       
-                       
 ACCOUNT NUMBER         
 0000300076000288297   
 NUM OF RECS: 01       
-                       
 ACCOUNT NUMBER         
 0000300076000288298   
 NUM OF RECS: 01


output of SKIP=5L
Code:
1 THIS IS A TEST       
 -----------------------
                       
                       
 ACCOUNT NUMBER         
 0000100690000067597   
 0000300070001371906   
 0000300070001970048   
 0000400010001246826   
 NUM OF RECS: 04       
-                       
0                       
 ACCOUNT NUMBER         
 0000300076000288297   
 NUM OF RECS: 01       
-                       
0                       
 ACCOUNT NUMBER         
 0000300076000288298   
 NUM OF RECS: 01


since I am not very knowledgeable in SORT esp reports..I assumed this special chars are useful or are interpreted if the report is actually printed or published, etc..and these chars are the CC chars..

thanks
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Nov 02, 2010 11:37 pm    Post subject:
Reply with quote

Hello,

Quote:
I assumed this special chars are useful or are interpreted if the report is actually printed or published, etc..and these chars are the CC chars..
Yes.

I don't yet understand why a "flat file" needs the additional blank lines. If some computer process is to use the data, the blank lines shouldn't be needed. If the data is to be read as a real report (by a person), the removecc wouldn't be used to preserve the spacing. . .

Probably i am misunderstanding something. . .
Back to top
View user's profile Send private message
Michael Angelo Pagala

New User


Joined: 02 Mar 2007
Posts: 34
Location: somewhere in the middle

PostPosted: Wed Nov 03, 2010 9:10 am    Post subject:
Reply with quote

hi,

sorry for the confusion..this flat file is just a validation file or summary file of some data that I will use for 3 days only..I just want to format the data so it can be easily understand..I can use ezy trieve for it but I want to try SORT since I am not familiar with it..and I have the excuse to practice it all day icon_biggrin.gif

thanks
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Nov 03, 2010 9:42 am    Post subject: Reply to: Question on SKIP=nL for Syncsort
Reply with quote

Quote:
sorry for the confusion..
Not to worry. Some days i'm slower than others icon_smile.gif

Sounds like you are good to go with either approach icon_cool.gif

Good luck,

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 3 Fri Dec 02, 2016 9:47 am
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am
No new posts Syncsort - NULL in Integer field chec... nartcr SYNCSORT 4 Thu Oct 06, 2016 6:47 am
No new posts ICETOOL/SYNCSORT - SYSPRINT output nartcr DFSORT/ICETOOL 17 Wed Oct 05, 2016 10:46 pm
No new posts Fault Analyzer - listings question. egrove IBM Tools 4 Thu Aug 11, 2016 5:31 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us