Hello,
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.
Anna
big rowset
Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
- Support_Rick Offline
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
- Contact:
Re: big rowset
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.
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
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696