Moving to MT, losing SQL, so trying to get creative. I need to limit the record output of a Lawson Query in IPA to 1. I have tried NEXT=FALSE and MAX=1, but neither work. I can put a break condition in place, but we have had issues in the past using that.
The goal is to inactivate work assignments in GHR based on the last time record date in S3. I want to make this a one process deal and not use SQL to generate a file that a GHR MT process has to then handle, so if I can run a PRTIME query and only return one record if it exists, that speeds things up considerably. Is there a syntax in the Lawson Query Node to limit the results?
