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 22643Can 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 7922Is 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 27103Hi 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 3718Suppose 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 6530For 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 6869i 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 7411I 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 9652
Mention the definition of cobol in varchar field.
What is the default page size of buffer pools?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What does db2 blu stand for?
What are the 2 sqlcodes that are returned?
what are bind concepts in db2 cobol?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is the difference between db2 and oracle?
Explain in brief how does db2 determine what lock-size to use?
SET is the ANSI standard for variable assignment, SELECT is not. SET can only assign one variable at a time, SELECT can make multiple assignments at once. If assigning from a query, SET can only assign a scalar value. If the query returns multiple values/rows then SET will raise an error. SELECT will assign one of the values to the variable and hide the fact that multiple values were returned (so you'd likely never know why something was going wrong elsewhere - have fun troubleshooting that one) When assigning from a query if there is no value returned then SET will assign NULL, where SELECT will not make the assignment at all (so the variable will not be changed from it's previous value) As far as speed differences - there are no direct differences between SET and SELECT. However SELECT's ability to make multiple assignments in one shot does give it a slight speed advantage over SET.
What is the function of logging in the db2 database?
can we view the access paths created by dbrm ? how ? thx
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is the latest version of ibm db2?
What is load utility in db2?
