SELECT statement limitations

This Q&A forum allows users to post and respond to "How Do I Do ....." questions. Please do not use to report (suspected) errors - you must use your regional help desk for this. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
Post Reply
RobboRobson
Posts: 7
Joined: Mon Jul 30, 2018 5:10 pm

SELECT statement limitations

Post by RobboRobson » Tue Oct 08, 2019 9:57 pm

Hi

I want to read through a large file containing about 10 milion records

I've used the following command:

Select Fields(*ALL) From_File(LDGP010) Io_Error(*NEXT) Val_Error(*NEXT)

But when running the form I'm getting the following error message appearing:

(0222) - Selection Record Limit of 10000 exceeded

I thought the limit for records only applied to lists and grids not actually looping through a large file?

Regards


Paul

RobboRobson
Posts: 7
Joined: Mon Jul 30, 2018 5:10 pm

Re: SELECT statement limitations

Post by RobboRobson » Tue Oct 08, 2019 10:37 pm

Please ignore someone had used the Connect_File in the program

Post Reply