Geeks Talk

Prepare for your Next Interview




Copying records in SORT or ICETOOL

This is a discussion on Copying records in SORT or ICETOOL within the MainFrame forums, part of the Software Development category; Hi, My dataset have multiple records, say 100. I want to start copy records only after a record contain a specific value that may be in a specific position. Secondly ...


Go Back   Geeks Talk > Software Development > MainFrame

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 08-22-2008
Junior Member
 
Join Date: Aug 2008
Location: India
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
subratghose is on a distinguished road
Copying records in SORT or ICETOOL

Hi,
My dataset have multiple records, say 100. I want to start copy records only after a record contain a specific value that may be in a specific position. Secondly I want to stop copying rest records if certain record contains a specific value. Can it be done using SORT/ICETOOL utilities?
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 08-22-2008
Junior Member
 
Join Date: Aug 2008
Location: Hyderabad
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
eminem123 is on a distinguished road
Re: Copying records in SORT or ICETOOL

You can use the selcopy tool which is apt for writing files, modifying data after checking for position based conditons.The SELCOPY statements can be coded in the SYSIN
for eg
//infile dd dsn=...... .data, disp=shr
//outfile dd dsn.... .data, disp =shr
//sysin dd *
read infile
if pos 30 eq 'M' or pos 32 eq 'N'
then mod pos 30 00
then mod pos 32 AA

write file=outfile
Reply With Quote
  #3 (permalink)  
Old 09-01-2008
Junior Member
 
Join Date: Apr 2008
Location: Noida
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
prasenjit_in is on a distinguished road
Re: Copying records in SORT or ICETOOL

You can use the sort utility(Include fields=) and for combining two conditions use the AND operator.
Reply With Quote
  #4 (permalink)  
Old 09-01-2008
Junior Member
 
Join Date: Apr 2008
Location: Noida
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
prasenjit_in is on a distinguished road
Re: Copying records in SORT or ICETOOL

//Sysin DD *
Sort fields= Copy
Include Fields=(20,5,EQ,C' RAJ'),Format=CH
| | |
| | |
Position | |
Length |
Specific Value
Reply With Quote
Reply

  Geeks Talk > Software Development > MainFrame


Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
Copying from one GDG base to other farhana MainFrame 4 10-16-2008 08:00 AM
How to sort two records between two dates without using between Geek_Guest SQL 4 12-14-2007 05:15 AM
how can i sort numbers in an array with out Arrays.sort()? ramakris143 Java 0 11-14-2007 09:52 AM
about copying bookmarks.... psuresh1982 Web Design 0 07-09-2007 08:54 AM
I want to sort out 200 to 300 records Geek_Guest Career Advice 0 06-10-2007 06:18 AM


All times are GMT -4. The time now is 11:46 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved