How do I add a column in db2?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,


What is database reorganization?

0 Answers  


i want to maintain uniqueness on pdf without make lf??????????

0 Answers  


can i code union in cobol-db2 pgm ?

4 Answers   Patni,


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

0 Answers  






What do you need to do before you do EXPLAIN ?

1 Answers  


What do you mean by cursor?

0 Answers  


how can i pull up a query which was previously stored in qmf

3 Answers  


Are views updateable?

0 Answers  


Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers  


What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 Answers  


where will u check for sqlcode ?

2 Answers   TCS,


Categories