Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

DB2 Interview Questions
Questions Answers Views Company eMail

Update command

1 2999

What is cursor?

2 3552

Request to database but database is not available so what is was abend is raised?

UST,

2 5342

Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 2453

what is the responsibility of the construction superintendent

Almco,

1242

What is difference between *omit and *nopass?

IBM, TCS,

1 5964

How to find last record before record through SQLRPGLE?

IBM,

1 7858

how to execute qcmdexc in rpgle?plz write code also?

IBM,

1 3910

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

Accenture,

1 2516

My SQL is not performing well. Describe how will you fine tune it?

Accenture,

1 4781

How to resolve deadlock issue

IBM,

5 12707

can any body explain about plan and pakage in detail....

HSBC, IBM,

2 7400

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

ADP,

4 7081

what is the use of cursors?

iGate,

3 4841

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

iGate,

2 6079


Post New DB2 Questions






Un-Answered Questions { DB2 }

What is with ur in db2?

149


Can you tell me how can you find out the # of rows updated after an update statement?

193


What is a cursor in programming?

166


How do I import data from excel to db2?

170


How to create backup table in db2?

169






What are the contents of a dclmgen?

208


What is runstats and reorg in db2?

171


Why do chiropractors use drop table?

165


What is buffer pool?

180


How to find the maximum value in a column in the db2 database?

184


Which component is used to execute the sql statements?

211


What is performance tuning db2?

154


What is the use of runstats in db2?

149


How to check table size in db2 sap?

158


What is the difference between plan and package in db2?

170