Answer Posted / magesh
delete from (select row_number() over() as COLUMN1 from
TABLE_OWNER.TABLE_NAME )
where COLUMN1=20000000;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are db2 objects?
What is dpf in db2?
What is declare cursor?
Before you give the explain statement, what are the prerogatives?
How to find the maximum value in a column in the db2 database?
Mention the definition of cobol in varchar field.
What is a bind in db2?
What is package in cobol db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
Why do we need reorg in db2?
What is the use of value function?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
what is db2 restart?
Which command is used to remove all rows from a table?
What is buffer pool in the db2 database?