To create a sequential sheet using DFSORT



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

To create a sequential sheet using DFSORT

Postby shivanshu26shiv » Sun Oct 11, 2015 7:32 am

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
shivanshu26shiv
 
Posts: 33
Joined: Mon Jun 01, 2015 8:45 pm
Has thanked: 4 times
Been thanked: 0 time

Re: To create a sequential sheet using DFSORT

Postby enrico-sorichetti » Sun Oct 11, 2015 12:50 pm

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
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 3006
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 165 times

Re: To create a sequential sheet using DFSORT

Postby BillyBoyo » Sun Oct 11, 2015 2:27 pm

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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: To create a sequential sheet using DFSORT

Postby shivanshu26shiv » Mon Oct 12, 2015 1:49 am

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,
shivanshu26shiv
 
Posts: 33
Joined: Mon Jun 01, 2015 8:45 pm
Has thanked: 4 times
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post