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

Report generation


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

New User


Joined: 27 Apr 2009
Posts: 23
Location: mumbai

PostPosted: Sat Jun 20, 2015 2:01 pm
Reply with quote

Hi All,

I have to validate the input file(Variable block) and write the invalid(non numeric) records to output file1 and valid records to output file2. Here in the invalid records file i have to say why the records are invalid.
For example input file has 5 fields say

Employee num,salary,date of joining,date of leaving,Branch
Code:

Employee Num - PIC X(5)
Salary - numeric-PIC 9(12)V9999
Date of joining -PIC X(10)
date of leaving - PIC X(10)
Branch - X(5)


Code:
12345 300000 2015-01-01 2016-01-05 abcde
23456 40000000 2013-01-01 2014-02-02 xyzab
34567 40.0000 2013-01-01 2013-04-01 txdce



Now i want to validate each and every field in put file,for example say the salary field is having invalid record(40.00000-its non numeric,i will put the check for salary filed as nonnumeric) then i have to write the records into output file(all the five fileds should be written in the output file),so as per our example the output filed should contain 34567 40.0000 2013-01-01 2013-04-01 txdce and at the end of record it should say salary filed is invalid.If 2 fields are invalid says salary and date then at the end of file it should say salay and date of joining are invalid.

so in the output it should write as
Code:

34567 40.0000 2013-01-01 2013-04-01 txdce salary invalid


if more than 2 fields are invalid then it should be
Code:

34567 40.0000 2013-01-01 2013-04-01 txdce salary invalid,date invalid



Is it possible in SORT.

Thanks,
Chez

Code'd
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Sat Jun 20, 2015 2:47 pm
Reply with quote

Yes, there is NUM, there is ADDDAYS, and SQZ for the messages.
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 DFHPI1008 JSON generation failed COBOL Programming 0
No new posts Need help on formatting a report DFSORT/ICETOOL 14
No new posts Creating Report using SORT DFSORT/ICETOOL 7
No new posts Started task using a generation dataset JCL & VSAM 7
No new posts Ca7 long running jobs report All Other Mainframe Topics 1
Search our Forums:

Back to Top