Answer / mithlesh

delete from table_name
where address = '456' and '678'.

Answer / siri

DELETE FROM TABLE WHERE ADDRESS IN('456','678')

Answer / prashant shettar

delete from (select rownumber() over() as rowid from tab1 )
where rowid = ( (select count(*) from tab1) - 1)

Answer / suv

We can use concept of cursor to delete particular row. The
row where the cursor is pointing will get deleted.

Please correct is wrong..

Answer / vaneesh khurana

I think better to perform this in following 2 queries

1. Select count(WS-COUNT) from TABLE;

2. DELETE FROM TABLE WHERE ROWCOUNT(*) IS WS-COUNT OR
(WS-COUNT-1);

Basically here the first row will give you the record count
and 2nd will delete the last and the 2nd last row.

What is sqlca’s maximum length?

0 Answers  

Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?

2 Answers  

What is Declaration Generator(DCLGEN)?

1 Answers  

when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,

For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  

What is the role of the data page in the db2 database?

0 Answers  

What are column-name qualifiers used?

1 Answers  

What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

4 Answers   Cap Gemini, Verizon,

What is package versioning? Please give an example.

1 Answers  

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,

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,

What is the use of dclgen in db2?

0 Answers