GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Mainframe  >  VSAM
Go To First  |  Previous Question  |  Next Question 
 VSAM  |  Question 27 of 35    Print  
How we can access the last record from KSDS file ?

  
Total Answers and Comments: 2 Last Update: November 29, 2007     Asked by: Samir Gupta 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
June 11, 2007 10:27:13   #1  
Yogendra Shinde        

RE: How we can access the last record from KSDS file ?...
Move High-values to key-field of the VSAM file this points to the last record of the KSDS file.
 
Is this answer useful? Yes | No
November 29, 2007 13:52:01   #2  
thesmarttechie Member Since: November 2007   Contribution: 2    

RE: How we can access the last record from KSDS file ?
Ya moving low-values and high-values to key points to the first and last records respectively.
If you want to process the records of a VSAM file sequentially use the START command.. Point the key to the first record and then read it like a normal flat file and sequentially process it till end of file..

 
Is this answer useful? Yes | No

 Related Questions

Latest Answer : What do you mean by record size? Are you asking about physical terms or logical? I can't say about current vsam but at one time the records were 512,1024,2048, and 4096. CIs which are the logical record could read multiple records and present them ...
Read Answers (11) | Asked by : Ranjit

Latest Answer : Average record length is the sub parameter of record size, which need to be defined while defining the vsamfile.  This sub parameter has a value which is less than or equal to another sub parameter of record size, the maximum record length. For a ...
Read Answers (2) | Asked by : javid

Latest Answer : aix is nothing but a file by which we can featch a records by using a key other than primary key. ...
Read Answers (2) | Asked by : Baskar

Latest Answer : No Jayakumar is right, that is the way of conversion of flat file to KSDS. First sort, then copy to KSDS. ...
Read Answers (4) | Asked by : james

For accessing a VSAM cluster sequentially, STARTBR, READNEXT, ENDBR commands are used. Suppose the VSAM cluster is sorted on the basis of a field (lets say age) and using STARTBR pointer is positioned on the record with name 'brijesh'. By using READNEXT that record is read. Now if i again use READNEXT, next record will be read(which could be the record with name other than 'brijesh'). If I want to read the next record with the same name (i.e. brijesh), whether RESETBR will be
Read Answers (1) | Asked by : Brijesh
Tags : Pointer

(i) The ISPF panel or a standard JCL is used for creation of a NON VSAM dataset. The AMS program is used to create the VSAM files. (ii) The information about the Non-VSAM files is stored as dataset labels 
View Question | Asked by : irinak

Latest Answer : To retrieve record from flat file you can use IDCAMS utility with REPRO command and can copy the data into either a VSAM data set or another flat file ...
Read Answers (2) | Asked by : jamirahmad mulla

Latest Answer : Corruption can happen in many ways. The dataset itself may be dirty, which can cause S0C7 abends in poorly written programs.CA/CI's can be corrupted, which may lead to S0C4 or Sx13 abends.Can you be more specific? The remedy is very different depending ...
Read Answers (1) | Asked by : Suresh

- whether record size is (5+alternate key length+n*pmy key length ) or (5+pmy key length + n*alternate key length) where 'n' is the no. of duplicate alternate keys.  
View Question | Asked by : kanchhana

Latest Answer : Ya, moving low-values and high-values to key,  points to the first and last records respectively. If you want to process the records of a VSAM file sequentially, use the START command.. Point the key to the first record and then read it like a normal ...
Read Answers (2) | Asked by : Samir Gupta


 Sponsored Links

 
Related Articles

N-Tier Architecture: Data Access Layer

N Tier Architecture Data Access Layer In an N Tier architecture the data access layer consists of components that aid one in the process of accessing the database When it is used correctly the data access layer serves as an abstract level for the structures of the database Simple changes that are ma
 

How to Access C++ Class Members

How to Access C Class Members In this C tutorial you will learn how to access Class members dot operator or class member access operator difference between struct and class and  scope resolution operator mosgoogle center It is possible to access the class members after a class is defined an
 

What are Data Access Tools

Data access is the process of entering a database to store or retrieve data. Data Access Tools are end user oriented tools that allow users to build structured query language (SQL) queries by pointing and clicking on the list of table and fields in the data warehouse. Thorough computing history, t
 

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 Access Path

In relational database management system (RDBMS) terminology, Access Path refers to the path chosen by the system to retrieve data after a structured query language (SQL) request is executed. A query may request at least one variable to be filled up with one value or more. A query may look like th
 

What is Access Point

An access point (AP; or also "WAP" for "wireless access point") is a node responsible for the formation of a wireless network through connection between wireless communication devices. It acts as a central transmitter and receiver of wireless radio signals, and is
 

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
 

VSAM Control Interval and Control Area

VSAM Control Interval and Control Area In this Mainframe tutorial you will learn about VSAM Control Interval What is a Control Interval in VSAM and Control Area what is VSAM control area attributes in the control area index component mosgoogle center What is a Control Interval in VSAM Control Interv
 

VSAM Structure

VSAM Structure In this Mainframe tutorial you will learn about VSAM Structure four major areas of VSAM structure what is VSAM cluster VSAM components Defining VSAM cluster and Example for defining VSAM clusters mosgoogle center There are four major areas in the structure of VSAM They are The Mas
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape