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
 

 

Report generation

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

New User


Joined: 27 Apr 2009
Posts: 22
Location: mumbai

PostPosted: Sat Jun 20, 2015 2:01 pm    Post subject: Report generation
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7306

PostPosted: Sat Jun 20, 2015 2:47 pm    Post subject: Reply to: Report generation
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    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 Easytrieve report shalem CA Products 4 Sun Feb 26, 2017 9:08 am
No new posts Detailed Transaction History report f... Kyle Carroll CICS 5 Tue Oct 18, 2016 12:42 am
No new posts Easytrieve - Report writing - Only 1 ... Abhi Nature CA Products 2 Wed Sep 14, 2016 11:40 am
No new posts Random Password (in string format) ge... ezhavendhan COBOL Programming 10 Mon Aug 29, 2016 3:18 pm
No new posts Daily report to be extracted from CA ... polymathtarun DFSORT/ICETOOL 5 Mon Jul 11, 2016 4:33 pm


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