What's after FETCH nnn rows.

Post by **KavalJeet** » Sat Oct 03, 2020 5:37 pm

Hi Friends,

I've a huge table in production. Which I need to unload. It's taking a lot of time to unload this table. I thought to unload it in 'pieces' like unload some rows of it then rest of it. To do that, I used FETCH FIRST nnnnn rows from the table, this is order by a column. But now how do I unload rest of the table of next set of 'nnnnn' from the table?

Can someone please let me know.

Post by **Anuj Dhawan** » Sun Oct 04, 2020 9:53 pm

Did you consult with your DBA?

Mainframe, MVS and zOS Discussion

What's after FETCH nnn rows.

What's after FETCH nnn rows.

Re: What's after FETCH nnn rows.

Create an account or sign in to join the discussion

Create an account

Sign in