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

How to resolve -917 sql code in DB2?

Cap Gemini,

3 15275

How to resolve -407 sql code in DB2?

Cap Gemini,

9 27881

How to resolve -504 sql code in DB2?

Cap Gemini,

2 17481

What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

 2 13079

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

 4 6451

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

Wipro,

8 9292

What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

 1 7130

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

 2 5206

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

UST,

4 6544

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

UST,

3 5941

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

 3 6331

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

iGate,

2 7586

how can we find nth max salary from A table

IBM,

5 23580

how to take the back up of the DB2 table.

 7 19499

Can a array declared with an index be displayed(readable format) in spool?

Syntel, UST,

4 5730

Post New DB2 Questions

Un-Answered Questions { DB2 }

What do you mean by cursor?

576

What does runstats do in db2?

598

Why cursor is used in db2?

565

How to compare data between two tables in db2?

652

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

634




What is copy pending status in db2?

625

What is difference between alias and synonym in db2?

633

What is innodb buffer pool?

553

What's The Error Code For Unique Index Voilation?

642

What is phantom read in db2?

630

How to resolve deadlock issue

17920

What are packages in db2?

589

Why do we bind in db2?

609

What is cursor stability in db2?

796

Differentiate between cs and rr isolation levels? Where do you specify them?

570

For More Un-Answered { DB2 } Questions Click Here