can I alter a table (e.g. adding a column) when other user
is selecting some columns or updating some columns from the
same table?
Answer / s
No, Because it requires an EX lock on the DBD to make
alters to the table description.
Is This Answer Correct ? | 5 Yes | 0 No |
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
What does db2 stand for?
What is the use of predicate?
How would the varchar column remarks defined?
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
How connect db2 database to datastage?
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
How do you insert a record with a nullable column?