IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SYNCSORT: Removing last three columns from the input?


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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: 1287
Location: Chennai, India

PostPosted: Mon Jul 06, 2009 12:09 pm
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

Superior Member


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

PostPosted: Mon Jul 06, 2009 12:24 pm
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 ...
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
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

Superior Member


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

PostPosted: Mon Jul 06, 2009 3:45 pm
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
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

Superior Member


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

PostPosted: Thu Jul 09, 2009 2:25 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Remote Unload of CLOB Columns DB2 6
No new posts Increase the number of columns in the... IBM Tools 3
No new posts force tablespace using LISTDEF input DB2 1
Search our Forums:

Back to Top