Geeks Talk

Prepare for your Next Interview


Welcome to the Geeks Talk forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.

Remove first and last record using a sort card

This is a discussion on Remove first and last record using a sort card within the MainFrame forums, part of the Software Development category; How to remove first and last record using a sort card I have one input file. i want to remove the header and trailer from that file and file has ...

Go Back   Geeks Talk > Software Development > MainFrame
Register Blogs FAQ Tag Cloud Calendar Mark Forums Read
  #1 (permalink)  
Old 07-09-2009
Junior Member
 
Join Date: Jul 2009
Location: karnataka
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
jilujose is on a distinguished road
Remove first and last record using a sort card

How to remove first and last record using a sort card

I have one input file. i want to remove the header and trailer from that file and file has to be sorted.

Please reply ASAP.
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 07-12-2009
Junior Member
 
Join Date: Jul 2009
Location: India
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
jasveerjassi is on a distinguished road
Re: Remove first and last record using a sort card

Usually header & tralier are identified by a record type usually first few bytes .. First identify by looking at the source code ,what is the unique identification & then use this sort card

INCLUDE COND=(1,2,CH,NE,C'00',or,1,2,CH,NE,C'99')

Here if first 2 bytes are 00 or 88 , record would nto be copied
Reply With Quote
  #3 (permalink)  
Old 09-03-2009
Junior Member
 
Join Date: Sep 2009
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
guruumani is on a distinguished road
Re: Remove first and last record using a sort card

//SORTIP1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//*
//IN DD *
20080910 HEADER
04 1234
05 ZEEBRA
20080910 TRAILER
/*
//OUT DD SYSOUT=*
//TOOLIN DD *
SUBSET FROM(IN) TO(OUT) INPUT REMOVE HEADER TRAILER
//CTL1CNTL DD *
SORT FIELDS=COPY
/*

We can also use Header(n) Trailer(n) to remove n records
Reply With Quote
Reply

  Geeks Talk > Software Development > MainFrame

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads

Thread Thread Starter Forum Replies Last Post
control card murthyksrc MainFrame 1 04-20-2009 07:07 AM
Remove an application without "uninstall/Remove" option anushya Windows 8 12-10-2008 06:32 PM
Remove duplicates using sort and aggregator lazydev Data Warehousing 0 03-28-2008 07:18 AM
Credit Card Application maddali1982 Testing Issues 2 03-05-2008 01:38 AM
how can i sort numbers in an array with out Arrays.sort()? ramakris143 Java 0 11-14-2007 09:52 AM


All times are GMT -4. The time now is 03:33 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.3.1
Copyright © 2009 GeekInterview.com. All Rights Reserved