Interested to Buy Any Domain ? << Click Here >> for more details...
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 22442Can 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 7826Is 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 26853Hi 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 3667Suppose 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 6438For 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 6734i 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 7249I 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 9500
How does cobol compile db2 program?
Are view updateable?
i want to maintain uniqueness on pdf without make lf??????????
How would you find out the total number of rows in a db2 table?
Why do we bind in db2?
What is blu acceleration in db2?
Is it possible using max on a char column?
What is consistency token in db2?
On which levels locks can be applied?
What is a plan and package in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is the use of value function?
What is image copy in db2?
Can we delete records from view?
What is check constraint in db2?
