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
 

 

Matching records and rewriting in a file

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

New User


Joined: 22 Oct 2006
Posts: 43

PostPosted: Fri Jun 01, 2007 12:41 am    Post subject: Matching records and rewriting in a file
Reply with quote

Hi All,

i have a job at hand to incorporate the logic to fulfil the following requirement:

I have 2 Files. INPUT file and the Translation FILE

INPUT file is of 561 Byte length (FB). The value coming at Pos 551-552 (2Bytes) is to be checked at Pos 1 -2 (2Byte) in Translation File (80Byte-FB).If a match is found,then pick up corresponding value from POS 4-5
(2byte) in Translation file and overwrite it at Pos 551-552 in INPUT file.

i have a limitation of not coding a NEW COBOL program due to code movement issue.

Any ideas to do this would be highly appreciated.
Back to top
View user's profile Send private message

ihatesugar
Warnings : 1

New User


Joined: 22 Oct 2006
Posts: 43

PostPosted: Fri Jun 01, 2007 1:02 am    Post subject: Re: Matching records and rewriting
Reply with quote

I tried using ICETOOL,Splice command it doesnt seem to work. This being can urgent requirement can someone help me with this?
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: Fri Jun 01, 2007 1:03 am    Post subject:
Reply with quote

Quote:
I tried using ICETOOL,Splice command it doesnt seem to work


Then you're probably not using it correctly.

Please show an example of the records in each input file (relevant values only) and the expected output records. If there are duplicates within either file, show that in your example.
Back to top
View user's profile Send private message
ihatesugar
Warnings : 1

New User


Joined: 22 Oct 2006
Posts: 43

PostPosted: Fri Jun 01, 2007 1:09 am    Post subject: Re: Matching records and rewriting
Reply with quote

DATA in INPUT FILE POS 561-562(Key)

01
02
03
04
05
..
..
..


DATA in TRANSLATION FILE
POS 1-2 POS 3-4
01 AL
02 SE
05 TD


so my INPUT file must be modified at POS 561-562 with value from POS 3-4 of TRANSLATION file if a match is found in translation file


hope i was able to state my requirement clearly
Back to top
View user's profile Send private message
ihatesugar
Warnings : 1

New User


Joined: 22 Oct 2006
Posts: 43

PostPosted: Fri Jun 01, 2007 1:16 am    Post subject: Re: Matching records and rewriting
Reply with quote

The JOB runs fine but in the SPOOL it says DFSORT not Licensed on this System.

what needs to be done in this case. Is this utility Shop specific.

what could be the alternative.

thanks for your quick response.
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: Fri Jun 01, 2007 2:03 am    Post subject:
Reply with quote

Quote:
The JOB runs fine but in the SPOOL it says DFSORT not Licensed on this System.


I assume you received message ICE149A. Here's a link to the Explanation for that message:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CM20/2.2.145?SHELF=&DT=20060721170811&CASE=

Ask your System Programmer if your site is licensed to use DFSORT, and if so why he/she hasn't defined DFSORT properly as licensed.
Back to top
View user's profile Send private message
ihatesugar
Warnings : 1

New User


Joined: 22 Oct 2006
Posts: 43

PostPosted: Thu Jul 05, 2007 8:30 am    Post subject: Re: Matching records and rewriting
Reply with quote

Sorry for the late reply... i was able to achieve the same using SYNCTOOL, as my shop didnt support DFSORT but had SYNCSORT instead..

Thanks all for your valuable replies.
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 splitting a file abdulrafi DFSORT/ICETOOL 2 Fri Mar 24, 2017 11:51 am
No new posts Receive a file using PCOMM macro Harald.v.K IBM Tools 0 Thu Mar 23, 2017 6:50 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Formatting VB File Learncoholic DFSORT/ICETOOL 3 Mon Mar 20, 2017 12:29 pm
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm


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