Skip to content

big rowset

Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
  • anutta78 Offline
  • Posts: 5
  • Joined: Fri Sep 09, 2016 11:59 am

big rowset

Post by anutta78 »


How I can split rowset with 500K rows to parts, let say 65K each?

and then use it in For each loop to write files.

  • Support_Rick Offline
  • Support Specialist
  • Posts: 590
  • Joined: Tue Jul 17, 2012 2:12 pm
  • Location: Phoenix, AZ
  • Contact:

Re: big rowset

Post by Support_Rick »

If the file is already in a "rowset", then you don't have to "split it up"... just loop through the RowSet (Use a For-Each loop)...

Then, if you need to "split" at each 65k limit, just put a counter inside your loop then change destination files as you write out each record to a target file.
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Post Reply