IBM MAINFRAME GURU Forum
  Home      Forum      Online Tutorials      Interview Questions      Mainframe Books      IT News
 


Home  >  Discussion Forum  >  DB2 INTERVIEW QUESTIONS
    

DB2 INTERVIEW QUESTIONS

No of Questions : 135
Goto page 1, 2, 3 ... 12, 13, 14  Next



DB2 INTERVIEW QUESTIONS
how to disable automatic storage?
Question : how to disable automatic storage

View Answer(2)

what causes a table to become locked
Question : why table gets locked?

View Answer(2)

A question was askesd to me in interview
Question : how many databases are possible in db2?

View Answer(3)

Number of records fetched in a cursor
Question : Hi friends,

I need to know the number of records selected by a cursor before processing the first record fecthed by cursor. Does any variable of SQLCA will store the number of records by the cursor ?. Any other possible way apart from using select count(*) with the cursor where clause condition ?


View Answer(2)

CHECKPOINT
Question : What is the example of CHECKPOINT? Can u please explain me with an example?

View Answer(2)

Again CURSOR
Question : Can a CURSOR be declared in both working-storage section and procedure division? If yes then what is the difference between these two?

View Answer(1)

CURSOR
Question : Is it possible to declare a cursor for UPDATE of table? and How?

View Answer(6)

What is BIND parameter
Question : What is BIND parameter and what are the BIND parameters in IBM DB2?

View Answer(3)

If (Input File = Table) -> Write-to (Output file)
Question : Input File:

abc123
def455
ghi347

Db2 Table data:

amnjgh
def798
anh762
ksj934
ghi121

Output file:

def798
ghi121


How will you do this with cursor?
Can we do this without cursor? If yes, how?


P.S: Not using the CODE tags for highlighting purposes...Thanks!

View Answer(1)

DB2 check utility ??
Question : Can someone explain me about DB2 check utility ??

View Answer(4)

Goto page 1, 2, 3 ... 12, 13, 14  Next

Home  >  Discussion Forum  >  DB2 INTERVIEW QUESTIONS


   

IBM MAINFRAME - COBOL Interview Questions( 59 )

IBM MAINFRAME - DB2 Interview Questions ( 110 )

IBM MAINFRAME - JCL Interview Questions( 52 )

IBM MAINFRAME - CICS Interview Questions( 70 )

IBM MAINFRAME - VSAM Interview Questions( 22 )





Google
 
Web mainframegurukul.com









 
Online ABEND Reference ||  JCL References ||  COBOL References ||  VSAM References ||  Tutorials by Drona Series ||  SQL tutorial ||  BOOKS  ||  SiteMap    || Simple JCL Tutorials  || JCL Tutorial from MainframeGurukul.com   || Simple JCL Tutorial - Chapter1   ||  DB2 Interview questions   || JCL Interview Questions   || COBOL Interview Questions   || VSAM Interview Questions   || CICS Interview Questions   || < simple DB2 SQL tutorial



Drona Educational Forums - Mainframe Cobol DB2 CICS Board
Copyright ? 2005 mainframegurukul.com. All rights reserved

DB2.html