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

What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 19027

Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?

6 19249

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 6125

Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

8 23046

Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.

1 2859

Suppose if I need to update a column, how you do that using cursor?

Verizon,

2 6557

Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

Verizon,

2 4874

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 4773

How to define the a field which accepts value till 99999.99 in db2

3 6933

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 5254

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 6561

How to resolve -805 error in DB2?

Cap Gemini,

1 31432

How to resolve -803 sql code in DB2?

Cap Gemini,

3 39670

How to resolve -818 sql code in DB2?

Cap Gemini,

2 21796

How to resolve -502 sql code in DB2?

Cap Gemini,

2 21994


Post New DB2 Questions

Un-Answered Questions { DB2 }

Is db2 a database?

424


What is dclgen in db2?

444


What is db2 bind?

469


What r the comman abends in db2, jcl and cobol???????

1654


How does coalesce work?

432






What does db2 plan contain?

433


Can we insert update delete in view?

425


If I have a view which is a join of two or more tables, can this view be updateable?

484


What are union and union all?

392


How to execute stored procedures?

458


How can the duplicate values be eliminated from db2 select?

477


What is a trigger in the db2 database?

435


what is the role of the cursor in db2?

487


How do I copy a table in db2?

412


What is a db2 collection?

436