Search found 1 match

Go to advanced search

by elmoro
Mon Jun 20, 2016 1:44 pm
Forum: Assembler & PL/I.
Topic: Query to Delete First 1000 Records from a Table 'DB2 on Z/OS'
Replies: 4
Views: 2107

Query to Delete First 1000 Records from a Table 'DB2 on Z/OS'

Hi,

In my database one table contains more than 70 million records, now I want to delete the records by selecting first 10,000 records one by one with a subselect from ..

Please tell me the query to delete first 10,000 rows from the table based on subquery between two tables.

Thanks & Regards,

Go to advanced search