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
 
Output only three records into different PS Files

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
k.nitin

New User


Joined: 02 Apr 2007
Posts: 4
Location: chennai

PostPosted: Tue May 22, 2007 5:54 pm    Post subject: Output only three records into different PS Files
Reply with quote

Hi everyone,

There is an input file which contain some input records ,deleted records

and some pair of input and deleted records,I want to write the three into different ps files

example of input records:


inserts:
I - 00037000325697D10603000434040PRINGLES PAPRIKA 200G

I - 00037000325703D10603000438590PRINGLES CHS&ONION 200G


paired recoeds
I - 00038785010532W10603000007661AUSSIE MEGA INS COND 250
D - 00038785010532W10603000007661AUSSIE INS.DLY.COND.250M
I - 00038785010532W12132000007661AUSSIE MEGA INS COND 250
D - 00038785010532W12132000007661AUSSIE INS.DLY.COND.250M

deletes

D - 03171310006352W10712000411063LE PIAT D'OR WHITE 75CL X12
D - 03171310006352W52877000411063LE PIAT D'OR WHITE 75CL X12
D - 03171310006352W53274000411063LE PIAT D'OR WHITE 75CL X12


can any one of u help me out in this it would be a great help if u do so

thanking you,
Nitin
Back to top
View user's profile Send private message

Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Mon May 28, 2007 1:12 am    Post subject:
Reply with quote

It's not clear what you want to do. You show I records as both insert records and paired records, and D records as both paired records and delete records, but you don't explain the criteria you're using to decide which they are. You need to explain the rules for going from input to output.

Also, give the RECFM and LRECL of your input file.
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Skip records depends on count lakshmiibmmainframes DFSORT/ICETOOL 5 Sun Dec 24, 2017 9:51 pm
No new posts Compare two PS files using ICE TOOL f... SENTHIL MURUGAAN DFSORT/ICETOOL 5 Sun Dec 24, 2017 1:26 pm
No new posts Inefficient BUILD - VB records paddin... Daniel Prosser SYNCSORT 9 Thu Dec 14, 2017 3:52 pm
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts Merging 2 records at multiple rows wi... Bijesh DFSORT/ICETOOL 2 Wed Dec 06, 2017 1:50 am

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