Hi All
Need help to create a csv file from some data which is extracted from input file
Input file:
1. RUN DATE: 06/02/11 2. SYSTEM: EP0Z 3. PROBLEM TYPE: 0016
-------- ---- ----
4. JOB NUMBER: 4301 5. JOB NAME: EP0Z080P 6. STEPNAME: EPZSTP06
---- -------- --------
7. TIME NOTIFIED: 23:55 8. WHO NOTIFIED: CHINMAY SAHOO
------- --------------------
9. HELPERS: ABEND.DATA
---------------------------------
10. WHAT WAS WRONG?:
CC 16 IN EPZSTP06 PROGRAM EPZ00080
ERROR ON SECTION : 24701-DEP-PROD-VR-CHECK
ERR MSG : SELECT MSHP CH MCURS SQL CD : -180
SUBS ID : 072426609
11. HOW WAS THIS PROBLEM HANDLED?:
COPIED THE PROD FILE 'EP00P.EPZ00080.INPUT.TRIGG(0)'
TO TEST FILE 'EP00T.EPZ00080.INPUT.TRIGG.G2310BKP'.
BELOW PROCESS WAS FOLLOWED
A. WE SEARCHED FOR THE SUBSCRIBER WHICH HAS SHOWN IN SYSOUA
DURING FIRST ABEND SUBS ID : 72426609
B. WE THEN FIND OUT THE SUBS ID WHICH WAS BEFORE THIS SUBSID AND
HAVE RECTYPE AS 'SP'.ALL RECORDS FOR THIS SUBSCRIBER ID WITH REC
TYPE SP WERE REMOVED.
I want to cut RUN DATE, WHAT WAS WRONG details and SQL CD which is SQL code and create a csv file from these 3 data.
please help