MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

format reqd for a report dataset

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Job Control Language(JCL)
View previous topic :: View next topic  
Author Message
radkrish
Beginner


Joined: 12 Aug 2005
Posts: 102
Topics: 19

PostPosted: Thu May 17, 2007 3:18 pm    Post subject: format reqd for a report dataset Reply with quote

Hi,

Code:
[,Command ===>,                                                ,Scroll ===>,CSR ,
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
********************************* Top of Data **********************************
     FILE-ID   :-             A-ABGD

     RECORDS RECIEVED EARLIER
       1301                  1073                  1094                  1216

     AVERAGE   :                    1,124
     RECORDS ARRIVED THIS TIME:-         1169
     VARIANCE PERCENTAGE FROM AVERAGE :-          4 %

     TOTAL COST RECEIVED EARLIER
               23,650,938             2,348,901             8,709,778

     AVERAGE   :                     8,872,005
     TOTAL COST ARRIVED THIS TIME:-          23,222,065
     VARIANCE PERCENTAGE FROM AVERAGE :-              161 %

     THE FOLLOWING RECORDS HAS COST OVER THE THRESHOLD (           50,000 )
     ADN                       PART                      QTY
     A50052FL000              683L136G13                    1.00
     A50052FL000              683L137G13                    1.00
     A50052GM000              683L269G03                    1.00
     A50052GM000              683L270G03                    1.00
     A50052FL000              683L136G13                    1.00
     A50052FL000              683L137G13                    1.00
     L10052B1998              6042T03G21                   51.00
     703052FC000              5099T12G03                    3.00


Above, I have shown a sample of file. The reqmt now is to extract into csv formated file so that all the above details to capture in the best formatted way. is it possible through JCL?
Can anyone tell me the way how to extract this in csv using sort tools or others in jcl.
Any fine format which is easier to code it and present in csv. Positions are respected to the colum number provided.

regds,
radkrish
Back to top
View user's profile Send private message
radkrish
Beginner


Joined: 12 Aug 2005
Posts: 102
Topics: 19

PostPosted: Thu May 17, 2007 3:28 pm    Post subject: Reply with quote

need a format which can be extracted in csv and loaded to informatica region when required. Ffield names(header) can be short....values are important

Hope Iam clear with my query.
Thanks in advance
Back to top
View user's profile Send private message
radkrish
Beginner


Joined: 12 Aug 2005
Posts: 102
Topics: 19

PostPosted: Thu May 17, 2007 4:16 pm    Post subject: Reply with quote

Let me explain about the report :
RECORDS RECIEVED EARLIER has 3 values - previous three month values.
TOTAL COST RECEIVED EARLIER has 3 values - prev 3 month values.

Code:
THE FOLLOWING RECORDS HAS COST OVER THE THRESHOLD (           50,000 )
     ADN                       PART                      QTY
     A50052FL000              683L136G13                    1.00
     A50052FL000              683L137G13                    1.00


it is th list of records listed for the condtion exceeding the threshold limit.

regds,
radkrish
Back to top
View user's profile Send private message
Nic Clouston
Advanced


Joined: 01 Feb 2007
Posts: 1075
Topics: 7
Location: At Home

PostPosted: Fri May 18, 2007 4:42 am    Post subject: Reply with quote

no you cannot do it via JCL - but you may be able to do it using a utility and certainly via another sort of program.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Job Control Language(JCL) All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group