Query export problem

[Rob]

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)

[Rob]

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.