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
 
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: 7314

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 Copying part of the report using SARBCH Aedulla CA Products 1 Tue Oct 24, 2017 9:24 am
No new posts Report cost in CA-dispatch Nileshkul CA Products 3 Wed Jun 07, 2017 10:32 pm
No new posts SMTP the current generation number of... Jyothi Kulunde JCL & VSAM 4 Thu May 04, 2017 4:08 pm
No new posts Splitting of single report to seperat... abdulrafi TSO/ISPF 7 Mon Mar 27, 2017 3:59 pm
No new posts Easytrieve report shalem CA Products 4 Sun Feb 26, 2017 9:08 am

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