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
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What are db2 objects?
How to connect to db2 database from windows command line?
What is db2 optimizer?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How do I change the column size in db2?
What is dbrm?
Is db2 a mainframe database?
What are the contents of dclgen?
What is the physical storage length of time data type?
What is db2 connect?
What is db2 look?
What is the difference between using bind () and rebind () methods of naming class?
Define sqlca.
Before you give the explain statement, what are the prerogatives?