LOTOFILE Error
Posted in 1999
After upgrading informix universal server 9.14 to informix foundation 2000 we have 2 problems with LOTOFILE. Informix Foundation 2000 9.20UC2-2 LLD.1.20.UC2 is installed 1.With the following SQL: -------------------------------- select LOTOFILE (images.image,'/images/image1!','server'), LOTOFILE (images.annot,'/images/annotation1!','server') from images where doc_nr = 1 and page = 0 Overwritting of a file does not work. I receive the error: (U0001) -17: File exists In version 9.14 this was no problem to overwrite files. 2.With the following SQL: -------------------------------- select LOTOFILE (images.image,'/nfs/images/image1!','server'), LOTOFILE (images.annot,'/nfs/images/annotation1!','server') from images where doc_nr = 1 and page = 0 Writting the lobs to a nfs directory I receive (U0001) - 13: Permission denied I checked the permissions on the mounted nfs directory and it seems to be OK, also with version 9.14 this was running without any problems. Where is my problem? should be anything with the rights of the LLD Datablade running? -- Philipp Gruenig Tecno Software Molerweg 42 2540 Grenchen Switzerland