what is the option in file-aid tool to fetch a particular record when a file contains million of records.
thanks in advance,
naresh.
How to fetch a particular record in File-Aid.
-
- Posts: 8
- Joined: Tue Jun 17, 2008 6:26 pm
- Skillset: cobol,jcl,vsam,db2,cics
- Referer: friend
- dick scherrer
- Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
Re: How to fetch a particular record in File-Aid.
Hello naresh and welcome to the forums,
Possibly a better approach would be to process the file in batch using your sort product and copy only some few (or a single) record(s) to a new file. This new "selected" file would be far more efficient to use online.
Possibly a better approach would be to process the file in batch using your sort product and copy only some few (or a single) record(s) to a new file. This new "selected" file would be far more efficient to use online.
Hope this helps,
d.sch.
d.sch.
-
- Posts: 62
- Joined: Wed Apr 23, 2008 1:37 pm
- Skillset: Mainframe - JCL, COBOL, VSAM, DB2, REXX, CICS
- Referer: Internet Search
- Location: Chennai, India
- Contact:
Re: How to fetch a particular record in File-Aid.
Hello Naresh,
In addition to what dick mentioned and a little explanatory way,
I dont know whether you have noticed that, FILEAID has batch processing option also. If you want to read a particular record you can give the key value or search using a value and submit it in batch process using the option available in FILEAID. it will create a JCL for you and the output can be captured either in the spool or mention an output dataset name.
Hope this helps...
In addition to what dick mentioned and a little explanatory way,
I dont know whether you have noticed that, FILEAID has batch processing option also. If you want to read a particular record you can give the key value or search using a value and submit it in batch process using the option available in FILEAID. it will create a JCL for you and the output can be captured either in the spool or mention an output dataset name.
Hope this helps...
-
- Similar Topics
- Replies
- Views
- Last post
-
- 4
- 1679
-
by Robert Sample
View the latest post
Sat Aug 29, 2020 12:58 am
-
-
Create multiple records based on one record within a file.
by chillmo » Thu Aug 11, 2022 3:54 am » in Syncsort/Synctool - 5
- 7709
-
by sergeyken
View the latest post
Fri Aug 12, 2022 2:23 am
-
-
-
Copy partial record after a string in a record using SORT.
by Esmayeelhusen » Thu May 04, 2023 3:03 pm » in DFSORT/ICETOOL/ICEGENER - 16
- 4379
-
by Esmayeelhusen
View the latest post
Mon May 22, 2023 3:50 pm
-
-
- 2
- 1412
-
by PRDVCF
View the latest post
Thu Nov 17, 2022 9:58 pm
-
-
compare substring in the same record
by samb01 » Mon Jun 12, 2023 1:08 pm » in DFSORT/ICETOOL/ICEGENER - 10
- 2957
-
by sergeyken
View the latest post
Tue Jun 13, 2023 11:04 pm
-