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 is check constraint. Explain with example.
What is the clustering index in the db2 database?
What is a bind in db2?
Is db2 free?
List some fields from sqlca?
What is the physical storage length of date data type?
What is runstats and reorg in db2?
What is the picture clause of null indicator variable?
What's The Error Code For Unique Index Voilation?
Name the lockable units in DB2?
How do you pull up a query which was previously saved in qmf?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
can all users have the privilage to use the sql statement select * (dml)?
What is a page in db2?