I need to retrieve data from large SQL tables into multiple under 2G dbf files. At one time I knew how to do this, but I've lost it. I know I used cursors in a script like

DEFINE MyCursor CURSOR FOR
SELECT * FROM BigOleSQLTable

OPEN MyCursor

FETCH NEXT FROM MyCursor
WHILE @@FETCH_STATUS = 0
   FETCH NEXT FROM MyCursor
  BEGIN
END

CLOSE MyCursor
DEALLOCATE MyCursor

Can somebody help me flesh this out to create multiple result cursors. Thanks.