How do I add a column in db2?
No Answer is Posted For this Question
Be the First to Post Answer
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..
What is database reorganization?
i want to maintain uniqueness on pdf without make lf??????????
can i code union in cobol-db2 pgm ?
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.
What do you need to do before you do EXPLAIN ?
What do you mean by cursor?
how can i pull up a query which was previously stored in qmf
Are views updateable?
Can you tell me how can you find out the # of rows updated after an update statement?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
where will u check for sqlcode ?