I'm trying to export to .CSV from a query. It works for small files but I have files with 400k records and 700k records. It stops working on those. In the test section of the query, it hard exits. When I use PROCESS, it gets stuck.
Is there a limit on the file size?
I tried chopping it down to 100k records but still not working.
(Version 2020 on Win10)
Update
Tried on Version 2023. Same problem.
Tried using "*Tools/QRYEXPORT" on Version 2026. That failed but gave me an error message "Memory Limits Reached
Increase '-SZ'"
I set 'SZ' to 512000 and QRYEXPORT worked.
Problem solved. Hope this helps somebody.