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

scanning a field in multiple recrds before writing to output


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
srujanasangu

New User


Joined: 12 Apr 2010
Posts: 2
Location: India

PostPosted: Fri Jun 10, 2011 12:21 pm
Reply with quote

I have an input file as below,
input file:
OPCDAILY1 1106061655 C
OPCDAILY2 1106081027 S
OPCDAILY3 1106081027 C
OPCDAILY4 1106081027 E
OPCDAILY5 1106081027 C
OPCDAILY6 1106081027 C

output file should be:
application OPCDAILY4 ended in error

Input file is FB, reclen 80. 3 fields are from pos 1-16, 17-28, 29.

Even if one record has E in pos 29, output should say 'application ended in error' irrespective of other record's pos 29.
if any of the record has E at pos 29, the output file should have 'application xxx(pos 1-16) ended in error'.
if any of the record has S at pos 29, the output file should have 'jobs are started'
only if all the records has C at pos 29, the output file should have 'jobs are complete'.

please help me out in doing this.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


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

PostPosted: Fri Jun 10, 2011 9:21 pm
Reply with quote

What output do you want for the following input records:

Input 1
OPCDAILY1 1106061655 S
OPCDAILY2 1106081027 E
OPCDAILY3 1106081027 S
OPCDAILY4 1106081027 E

Output 1 ?

Input 2
OPCDAILY1 1106061655 S
OPCDAILY2 1106081027 S
OPCDAILY3 1106081027 S

Output 2?
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts Sortjoin and Search for a String and ... DFSORT/ICETOOL 1
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Grouping by multiple headers DFSORT/ICETOOL 7
Search our Forums:

Back to Top