Posted: Thu May 17, 2007 3:18 pm Post subject: format reqd for a report dataset
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.
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.
Joined: 01 Feb 2007 Posts: 1075 Topics: 7 Location: At Home
Posted: Fri May 18, 2007 4:42 am Post subject:
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.
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