My first thought goes to libraries and library lists – I’m sure I read somewhere that there were changes in how libraries and lists were handled with regard to SQL. Do you have the library name specified in your SQL statement? Is it possible that there is indeed a file with the same name in another library with journalling active?
The SQL does have the Library Name specified for the File. I search the entire system looking for another file of the same name but found none. For now I gave in and Added a STRJRNPF statement for the file prior to applying the SQL to it. I hope to eventually find out however why the functionality changed. Thanks for you input Martin.