How do I add a column to an existing table in db2?
No Answer is Posted For this Question
Be the First to Post Answer
What is dbrm in db2 database?
What is index in db2?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
What is the difference between drop table and delete table?
What is the default page size of buffer pools?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
What should be specified along with a cursor in order to continue updating process after commit?
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).
What is cloudant database?
Q3. How will you fetch duplicate values from a DB2 table?