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
 

 

SYNCSORT: Removing last three columns from the input?

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

New User


Joined: 04 Jun 2008
Posts: 36
Location: Chennai

PostPosted: Mon Jul 06, 2009 10:40 am    Post subject: SYNCSORT: Removing last three columns from the input?
Reply with quote

Hi,

I got a new requirement, where i am going to get a input file of Record length 252 characters. But my old input file has the record length 133. So i need to remove all the records from 134 to 252 and copy it to other file which has the record length of 133 ie.. i need to omit the character from after 133.

My File type is : FB

Please help me fixing this?
Back to top
View user's profile Send private message

Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1288
Location: Chennai, India

PostPosted: Mon Jul 06, 2009 12:09 pm    Post subject: Reply to: SYNCSORT: Removing last three columns from the inp
Reply with quote

Guru,

Quote:
where i am going to get a input file of Record length 252 characters. But my old input file has the record length 133


Strange. Your input file should have got changed only for a specific business reason. Then why should you delete the data and convert ito a file of length 133?

Reason for the same?
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Jul 06, 2009 12:24 pm    Post subject:
Reply with quote

Quote:
I got a new requirement
But you did not post the old one yet... icon_biggrin.gif

What you have posted can be done just by using OPTION COPY in SYSIN for SORT and using LRECL=133 for SORTOUT -- but yes why do you want to do that as Aaru has asked?

And why do you use this
Quote:
last three columns from the input
as a subject line while this seems to be in no relation with body of your thread?

It's just Monday.. not a Psychic day you know...this other thread seems to be quite similar to your subject ...
http://www.ibmmainframes.com/viewtopic.php?p=197860#197860
Back to top
View user's profile Send private message
Guru Prasath

New User


Joined: 04 Jun 2008
Posts: 36
Location: Chennai

PostPosted: Mon Jul 06, 2009 1:27 pm    Post subject: Reply to: SYNCSORT: Removing last three columns from the inp
Reply with quote

Hi

Quote:
Strange. Your input file should have got changed only for a specific business reason.


Yes...But for the same business reason they are omitting these records for while passing this file to COBOL program,, Not strange icon_smile.gif

Anuj...

Sorry for the confusion...My team mate also raised the same ...Sorry again..

Yes. As you said we also thought the same option using OPTION COPY ... But we thought of doing this in efficient way...

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

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Jul 06, 2009 3:45 pm    Post subject:
Reply with quote

Quote:
we thought of doing this in efficient way
You need to define efficient? At the most you may use INREC along with OPTION COPY ...
Back to top
View user's profile Send private message
Guru Prasath

New User


Joined: 04 Jun 2008
Posts: 36
Location: Chennai

PostPosted: Thu Jul 09, 2009 12:39 pm    Post subject: Reply to: SYNCSORT: Removing last three columns from the inp
Reply with quote

Hi Anuj,

Yes....OPTION COPY itself did it...So we got the output...

Thanks for ur support.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Jul 09, 2009 2:25 pm    Post subject:
Reply with quote

You're welcome. icon_smile.gif
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 How to generate a new unique Input fi... for1ranjith CLIST & REXX 11 Sat Jul 01, 2017 12:09 pm
No new posts Need input in Scheduling Benchwarmer CA Products 5 Tue Jun 06, 2017 1:44 am
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm
No new posts Formating the Input file sreekusr DFSORT/ICETOOL 3 Fri Feb 17, 2017 10:40 pm


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