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 20228Can 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 6576Is 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 24132Hi 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 3095Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
2 5306For 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 5380i 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 5809I 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 7391
what is the sqlcode -501
How can deadlocks be resolved?
What is coalesce in db2?
What is bind and rebind in db2?
How to view db2 table structure?
Define predicate?
What is the difference between spufi and qmf?
Where can you declare a cursor in a cobol-db2 program?
can we view the access paths created by dbrm ? how ? thx
How do I start db2 in windows?
What is release/acquire in bind?
Define data page.
What is collection in db2 bind?
What is an instance database?
What is the difference between drop table and delete table?