ACS - Run SQL Script - is there a way to have it retain the last folder used?

If we iterate through the exact steps provided, the last path used is remembered. In the original request and the referenced Case (TS015526296), multiple LPARs are being used, but the steps provided only include the usage of 1 LPAR. We do not remember the last used path on a per LPAR basis nor do we plan on adding that support. That is likely the issue you are having has you navigate between LPARs and select different paths for opening and saving files. If you are using multiple LPARs, consider the suggestion we posted on Apr 5, 2024.

IBM Power Systems Development

I have shown the lengthy process in the attachment. Please review.

Thank you for submitting your Idea to enhance IBM i Access Client Solutions (ACS). We have read the referenced Case you opened with IBM Service as well as the description in your submitted IDEA to enhance Run SQL Scripts (RSS). Today, when using Open or Save in combination with ?IFS Stream File?, the starting default location is the last location referenced and it assumes the current connected system. Since you often navigate to other systems/lpars, it sounds like you would like RSS to default to both the last referenced location and last referenced system (regardless of the system RSS is currently connected). Defaulting to the last referenced system may introduce confusion for users that rarely visit other systems and expect the default to be the currently connected system. We could consider providing additional preferences for the ?IFS Stream File? option to allow the user to choose a preferred behavior. However, there may already be an existing solution.

If you need to reference a master location across systems, you could use a mapped network location. This could be anywhere in your PC network (including a mapped network drive to an IFS location in any of your lpars). When you need to update or reference the master location, use Open or Save and select the ?PC File? option. That option also remembers the last location referenced and it will be independent of the lpar to which ACS is connected. So when you need to reference the master location, you could use the ?PC File? network location. When you need to propagate the updates to the various lpars, you could Open the master location using the ?PC File? option and then do the save using the ?IFS Stream File? option. Would something like this meet the requirement?

IBM Power Systems Development