Joined: 02 Dec 2002 Posts: 155 Topics: 25 Location: N.Ireland
Posted: Tue Dec 03, 2002 5:11 am Post subject:
Hariharan,
I don't know whether SARBCH can do that. However you can use the second JCL to save the index to a dataset and use SORT to extract the coulmns you need.
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Tue Dec 03, 2002 11:15 am Post subject:
As Sjreejith points out, once you create a sequential file, you can use DFSORT/ICETOOL to create a report or extract specific columns. If the file is RECFM=FBA, the first position will contain a carriage control character, so the data starts in position 2.
If you just want to extract selected fields to another data set, you can do that using DFSORT's INREC, OUTREC or OUTFIL OUTREC statement. For example:
where p1,m1 is the starting position and length of the jobname, p2,m2 is the starting position and length of the date, and p3,m3 is the starting position and length of the time. Many editing options are available with INREC, OUTREC and OUTFIL OUTREC.
If you want to print a report with the extracted fields, you can use the DISPLAY operator of DFSORT's ICETOOL to do that quite easily. For example:
In particular, see "DFSORT Application Programming Guide" which describes all of the DFSORT and ICETOOL statements in detail. _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Joined: 02 Dec 2002 Posts: 429 Topics: 18 Location: Germany
Posted: Fri Oct 29, 2004 12:48 am Post subject:
Go into SDSF, DA and look for the Sar started task, it might be View.., it might be SAR... This all depends upon your shop. Once you find the started task you will find the dataset name qualifiers in the PARM. For example:
IEFPROC EXEC PGM=SARSTC,PARM='CAXXX1.NSHR.VIEW,&OPT',
The Sardatabase will be called CAXXX1.NSHR.VIEW.SARDBASE.D0000...
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
Posted: Wed Oct 12, 2005 4:25 am Post subject:
Kumarsivarajan,
Click on the "quick manuals" link on the top of this page. Scroll to "Utilities" section. Now click on DFSORT Application Programming Guide. Read chapter 6.0 Using ICETOOL which will answer your queries.
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Wed Oct 12, 2005 9:46 am Post subject:
Kumar,
f1, f2 and f3 represent formats. If the data is character, you would use CH format. If the data is numeric, you would use the numeric format (e.g. PD, ZD, BI, FI, FS, UFF, SFF) that corresponds to the way the data is stored. You can also use various SMF, TOD and ETOD date and time formats if that's what the data represents.
For complete details on the DISPLAY operator of DFSORT's ICETOOL, see:
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