GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Mainframe  >  DB2
Go To First  |  Previous Question  |  Next Question 
 DB2  |  Question 197 of 198    Print  
Attributes to Read & Write DB2 file
What are the attributes that needs to be defined in order to read & write DB2 file in Cobol program?


  
Total Answers and Comments: 0 Last Update: June 25, 2009     Asked by: vincekumar 
  
 Sponsored Links

 

No answers are posted for this question yet.
Be the first to answer it!


 Related Questions

These are attributes of one table that have matching values in a primary key in another table, allowing for relationships between tables.  
Latest Answer : Foreign Keys are keys used in a table as an attribute and are primary keys of some other table ...

SPUFI stands for SQL processing using file input. It is the DB2 interactive menu-driven tool used by developers to create database objects.  
Latest Answer : SPUFI : SQL Processing Using File Input, it supports the on-line execution of SQL statements from a TSO terminal ...

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
No. The table and its view are created anew, but the programs accessing the view do not need to be changed if the view and attributes accessed remain the same.  

The three types are shared, update and exclusive. Shared locks allow two or more programs to read simultaneously but not change the locked space. An exclusive lock bars all other users from accessing 
Latest Answer : 3 types of locks are SHARE EXCLUSIVE UPDATE ...

If there is an index on the attributes tested an IN is more efficient since DB2 uses the index for the IN. (IN for index is the mnemonic).  
Latest Answer : hi  vipin sharma,IN subselects  can also uesd in corelated sub queries.IN subselects  needs  to specify  the vlues u want to search.EXISTS    subselects  doesn't need any to specify values . it searches ...

. It is a write to disk that may occur before or long after a commit. The write is controlled by the buffer manager.  

This is a key concept for any relational database. Isolation level is the manner in which locks are applied and released during a transaction. For DB@ a 'repeatable read' holds all locks untile 
Latest Answer : Isolation level means the extent to which the transaction isolates the data is accessed ...

Latest Answer : File opening modes areInput mode , output mode, extend mode, inputoutput mode. corresponding disposition codes in JCL.Inputmode--------  "Read" the file       SHR    (DISP)outputmode--------"write" the ...

Latest Answer : Record will be appeand in the file. ...

Latest Answer : How does you get record no from 5 to 15 from a dataset of 100 records?         ...


 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
 

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
 

How to Improve Your Vocabulary While You Read

How to Improve Your Vocabulary While You Read Reading is The Key Perhaps the best method you can use to improve your vocabulary is to read When I say read I m not just talking about comic books mainstream magazines or celebrity tabloids I m talking about reading materials that are actually challengi
 

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
 

HR Interview - HR Interview Mistakes You Will Want To Avoid

HR Interview Mistakes You Will Want To Avoid The job interview can be a stressful process This is especially true for those who are going after a competitive position Your nonverbal communication combined with the answers you give during the interview will determine if you are hired mosgoogle While
 

HR Interview - Behavioral HR Interviews

Behavioral HR Interviews As the name implies a behavioral interview is an interview that is held by a human resources department to determine if an applicant has the behaviors that are appropriate for a job The company must know how an applicant will behave in a certain situations mosgoogle The logi
 

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