in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
ALTER TABLENAME
ADD COLUMN <COLUMN NAME> <DATATYPE>(<SIZE>)
Is This Answer Correct ? | 1 Yes | 0 No |
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is scrollable cursor in db2?
What is lock escalation in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is runstats db2?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
what is the difference between where clause and having clause
can we update the table by using cursors can anyone post the query?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is the SQL Communications Area and what are some of its key fields?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is the advantage in De-normalizing tables in DB2?