Hi Community,
I’m trying to execute a directory query in InterSystems IRIS using %SQL.Statement
, but encountering an unexpected error.
Details:
The following command confirms that the directory exists:
Set dirPath="\\MYNETWORK_DRIVE\DFS-Shared_Product\GXM"
Write ##class(%File).DirectoryExists(dirPath)
It returns 1
, meaning the path is valid and accessible.
However, when I try to execute this SQL query: