GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Mainframe
Go To First  |  Previous Question  |  Next Question 
 Mainframe  |  Question 43 of 51    Print  
what is the option in file-aid tool to fetch a particular record when a file contains million of records?

  
Total Answers and Comments: 1 Last Update: September 17, 2007     Asked by: sdresh 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
September 17, 2007 13:18:12   #1  
Ksakthi        

RE: what is the option in file-aid tool to fetch a par...

Once you give your dataset name
Give "Q" in the selection Criteria Usage

You will get a screen like this

          AND
Cmd   /OR  Position Length  RO   Data Value    
---    ---      --------    ------     --    ------------------------------------
___           _____   _____     EQ ____________________________________

                     
Under each field you have to specify the position number and length of your key or field name then give your search value under Datavalue

This will get your exact record


 
Is this answer useful? Yes | No

 Related Questions

I have 3 files . 2 files have millions of records.These 2 files have one ( empnumber) common record field. i want to put those records in 3rd file , such that which records having same number in key field (empnumber)in these two files ?
Read Answers (9) | Asked by : mark

Can i call 5 pgms using static call n 3 pgms using dynamic call in a single pgm, if then how many load modules will be there? What about the compiler option(parm)to use?
Read Answers (6) | Asked by : upendar

When an output file from Mainframes has compressed fields, how do you uncompress them and save the file as a text?
Read Answers (2) | Asked by : Sreenivasan NS

Latest Answer : Endevor is a Version Control Tool. Through this tool we can get the code from production side and do the changes in code. It will create a version for the changes program. Through that we can easily find the changed program. This tool uses to compile ...
Read Answers (6) | Asked by : Kiran

What is code of copy from ps file to gdg file and copy from gdg file to ps file in jcl.how i can do?
Read Answers (5) | Asked by : Ajay Kumar Tiwari

Program for employee master creation and update and listing.hint: employee master creation file contains 10 records of 10 employees as.Emp code ename designation jd bp sl etc?
Read Answers (2) | Asked by : sachin borase

Latest Answer : Changeman is a version and configuration control software for Mainframe, which gives you (the standard) facilities like bundling the related components (programs, JCLs etc) of a release together, version control for installation / rollback of components, ...
Read Answers (4) | Asked by : gugangugan

I want to know that is it possible by using COBOL programming? 
Latest Answer : Not going by the previous complicated ways u can check ur emulator software for file uploading facility.Go into the option 6 in the TSO screen then in ur emulator's menu select Transfer File -> Upload File from PC and browse the file u want ...
Read Answers (2) | Asked by : shivani

How to use start keyword in index(ksds) file ? Explain with real time situation where you would use this.
View Question | Asked by : naveen

(1)How many bytes will take the redefine in this situation 01 a pic 9(2). 01 b redefines pic 9(2).(2)What is null & not null value in db2?(3)What is changeman tool in the mainframes environment and tell about package, freeze in changeman
View Question | Asked by : sumanth


 Sponsored Links

 
Related Articles

What is Data File

In a logical data model, the conceptual data model which is based on the business semantic is being defined. Thus, entities and relationships and corresponding table and column design, object oriented classes, and XML tags, among other things are being laid regardless of the database will be physica
 

What is the use of COUNT with DISTINCT option

COUNT is a group function returns result by summarizing multiple rows. All group by value function will have the usage of DISTINCT or ALL option and so is the COUNT which uses the DISTINCT option. DISTINCT option is used to enforce uniqueness and  if combined with COUNT is used to
 

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de
 

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof
 

Mainframe Features

Mainframe Features In this Mainframe tutorial you will learn about features of Mainframe Processing power memory capacity performance computing multiple operating system time sharing reliability serviceability availability clustering technology and other features available in Mainframe mosgoogle cen
 

Importance of Proper English during Job Interview

Importance of Proper English during Job Interview Your job interview is crucially important and it will determine whether or not you will get the job Depending on the type of job you re going for it is very important for you to use proper English In most cases jobs which offer higher salaries will h
 

Finding The Right Student Loan Option

Finding The Right Student Loan Option Finding the right student loan can be a struggle to many students It is one major decision that can make or break a student’ s future financial stability If you make the mistake of getting a student loan that you cannot properly manage as you go along
 

How To Choose a CRM Tool

How To Choose a CRM Tool While CRM is a powerful tool many companies find that choosing a good programs is a difficult task This has been the case regardless of industries Many companies realize that providing a high level of service to their partners and customers is an important part of being succ
 

PHP Tutorials - File manipulation (Part-2)

File manipulation Part 2 In this PHP Tutorial you will learn the 2nd Part of File Manipulation Reading lines from a file Reading arbitrary amounts of data from a file Writing to a file Creating directories Removing a directory and Opening a directory for reading mosgoogle Reading lines from a file T
 

PHP Tutorials – File manipulation (Part 1)

PHP Tutorials File manipulation Part 1 In the PHP Tutorial You will learn about File manipulation Part 1 Checking file existence A file or directory Determining file size Creating and deleting files and Opening a file for writing reading or appending mosgoogle Checking file existence You can test
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape