Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Query about SYNCSORT OUTFIL OUTREC

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

New User


Joined: 26 Apr 2007
Posts: 49
Location: Delhi

PostPosted: Tue Jun 12, 2007 11:22 am    Post subject: Query about SYNCSORT OUTFIL OUTREC
Reply with quote

In Syncsort, what does the following mean?
OUTFIL OUTREC=(2X,
006,08,
1X,
019,20,
1X,
045,20,

Thanks
Back to top
View user's profile Send private message

vicky10001
Warnings : 1

Active User


Joined: 13 Jul 2005
Posts: 136

PostPosted: Tue Jun 12, 2007 11:42 am    Post subject:
Reply with quote

Q)In Syncsort, what does the following mean?
OUTFIL OUTREC=(2X,
006,08,
1X,
019,20,
1X,
045,20,


Answer
The o/p file is reformatted for 2 spaces ,from pos 6th to 8 bytes will move the data o/p file,1 space ...etc
Back to top
View user's profile Send private message
Mahua Mitra

New User


Joined: 26 Apr 2007
Posts: 49
Location: Delhi

PostPosted: Tue Jun 12, 2007 12:22 pm    Post subject:
Reply with quote

You mean, in the first case that is 2X, 006,08
4th and 5th byte is spaces , 6th to 13th byte is data?
or 6th to 8th byte is data??
if that is the case,then what abt the first 3 bytes?
Back to top
View user's profile Send private message
ibmmainframesyntel

Active User


Joined: 26 Feb 2007
Posts: 126
Location: Chennai

PostPosted: Tue Jun 12, 2007 12:44 pm    Post subject:
Reply with quote

Hi Mitra,


OUTFIL OUTREC=(2X,
006,08,
1X,
019,20,
1X,
045,20,


According to ur control card,

2X- Two spaces in first two position in output file.
006,08 - data from input file is moved to 3rd-10th position in output file
1X - one space is in 11th position of output file.
019,20 - data from input file is moved to 12th- 31st position in output file
1X - one space is in 32nd position of output file.
045,20- data from input file is moved to 33rd- 52nd position in output file


006,08 - means - In input file from 6th position,8 bytes is moved to output file

019,20 - means - In input file from 19th position,20 bytes is moved to output file

045,20 - means - In input file from 45th position,20 bytes is moved to output file
Back to top
View user's profile Send private message
ibmmainframesyntel

Active User


Joined: 26 Feb 2007
Posts: 126
Location: Chennai

PostPosted: Tue Jun 12, 2007 12:48 pm    Post subject:
Reply with quote

Ur output will be..

123456789012345678901234567890123456789012345678901234567890
XXDATA1....XDATA2.........................XData3........................................
Back to top
View user's profile Send private message
Mahua Mitra

New User


Joined: 26 Apr 2007
Posts: 49
Location: Delhi

PostPosted: Tue Jun 12, 2007 1:36 pm    Post subject:
Reply with quote

Thank u so much
Mahua
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 HEX value search in a DB2 query maxsubrat DB2 2 Wed Oct 04, 2017 3:04 pm
No new posts Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm
No new posts WER268A OUTREC STATEMENT : SYNTAX E... frozenblood87 SYNCSORT 12 Sat Aug 26, 2017 9:45 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us