1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category
DB2 Interview Questions
Questions Answers Views Company eMail

Update command

 1 3629

What is cursor?

 2 4578

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

UST,

2 6512

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 3292

what is the responsibility of the construction superintendent

Almco,

1652

What is difference between *omit and *nopass?

IBM, TCS,

1 6901

How to find last record before record through SQLRPGLE?

IBM,

1 8669

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

IBM,

1 4549

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

Accenture,

1 3405

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

Accenture,

1 5673

How to resolve deadlock issue

IBM,

5 17919

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

HSBC, IBM,

2 8731

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 8530

what is the use of cursors?

iGate,

3 6045

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 7226

Post New DB2 Questions

Un-Answered Questions { DB2 }

How to find primary key of a table in db2?

596

What does sqlcabc has?

622

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2262

What is data manager?

596

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1644




How to access db2 tables in mainframe?

604

Are views updateable?

635

What is isolation level in db2?

571

Can there be more than one cursor open for any program?

650

What is blu acceleration in db2?

594

What happens in bind step in a db2 program?

557

what is utility for parm lib

1863

What is difference between rollback and commit?

612

What is the role of the data page in the db2 database?

578

What is a Foreign Key?

646

For More Un-Answered { DB2 } Questions Click Here