Page 1 of 1

To create a sequential sheet using DFSORT

PostPosted: Sun Oct 11, 2015 7:32 am
by shivanshu26shiv
We need to create a sheet of all DESC variables given below, so can we do this using dfsort (since there are thousands of jobs) ?

File's layout::

----+----1----+----2----+----3----+----4----+----5----+----6----+----7--
   JOB-1 JOBNAME JOBNAME-DESC           /*REMARKS */ 
       SUBAPPL  SUBAPPL-DESC
       tag      'TAG-DESC'                                             
       run      RUN-DESC
       DELAYSUB DELAYSUB-DESC
   ENDJOB     
 
JOB-2 JOBNAME JOBNAME-DESC           /*REMARKS */         
------------------------------             
------------------------------


The sheet's (LRECL 120/FB) layout is of,

JOBNAME-DESC    |   SUBAPPL-DESC  |  TAG-DESC |  RUN-DESC      |     DELAYSUB-DESC  |   REMARKS   


Any hint would be appreciated...

Code'd

Re: To create a sequential sheet using DFSORT

PostPosted: Sun Oct 11, 2015 12:50 pm
by enrico-sorichetti
the explanation is at least muddy,
while the problem might be clear to You, it was not clear for us.

suggestions ...
when posting data use the code tags to preserve the alignment

with
1234567890abcd
          ABCD


without
1234567890abcd
ABCD

when describing the problem do not use Your organisation jargon
we spend enough time trying to understand Your problem and giving You a solution
so You should not make us waste time also trying to understand Your jargon

what in &hell is a sheet ?

just speak in terms of records, position, length, format

show the input and the expected output - use the code tags

Re: To create a sequential sheet using DFSORT

PostPosted: Sun Oct 11, 2015 2:27 pm
by BillyBoyo
Your sample data just looks like headings: what is the actual data like? Is the data "pipe-delimited" or in fixed positions?

If pipe-delimited, the PARSE and OUTFIL reporting features with multiple lines; if not, then just the OUTFIL reporting features.

Re: To create a sequential sheet using DFSORT

PostPosted: Mon Oct 12, 2015 1:49 am
by shivanshu26shiv
Got it BillyBoyo, sorry for that ambiguous query...please see the below format,


Input:
ABC11111      /*REMARKS-1*/
   DEF22222
GHI33333

ABC44444      /*REMARKS-2*/
   DEF55555
GHI66666

-------------------
-------------------



Expected Output:
 ABC    DEF    GHI   REMARKS
11111  22222  33333  REMARKS-1
44444  55555  66666  REMARKS-2
-------------------
-------------------


Where ABC,DEF,GHI are same for each of the 1000 jobs,