Under what circumstances will DB2 allow an SQL statement to
update more than one primary key value at a time?
Answer / vinod babu bachina
Never. Such processing could produce duplicate values
violating entity integrity. Primary keys must be updated one
at a time.
| Is This Answer Correct ? | 2 Yes | 1 No |
Can we able to find all the Table names under a Particular Plan?
Which catalog tables contain authorization information?
what is the use of commit ? and what is the syntax?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What is db2 catalog database?
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is cursor with hold option in db2?
if i made sme changes in sub pgm wht r the things to be done for this ?
What is the role of schema in the db2 database?
What do you mean by between and in? Is between inclusive of specified range values?
What is a correlated sub query?