External tables in Win server

Hi! I am testing external tables with IDS 11.70 on a Windows-server, and get the following error: 17.12.2012 12:39 Executing statement: Create external table ext_xyz (col1 integer, col2 char(20)) USING (DATAFILES ("DISK:d:\\\\temp\\\\xyz.unl"), FORMAT "DELIMITED"); Exec Time: 00:00:00,102; Statement executed 17.12.2012 12:39 Executing statement: insert into ext_xyz select tabid, tabname from systables;SQL Error (-26154): Could not open file: (file, errno)=(d:\\\\temp\\\\xyz.unl,13). Error Position: Ln: 7 Col: 56 Any ideas? I have tried all variations using slashes back and forward and the file exists on the server. Thanks, Lauri Pietarinen

Hello. -26154 Could not open file: errno, filename. An error occurred when the database server tried to open the file. Check the accompanying error for more information. Possible causes include missing file or incorrect permissions. According to your message, errno 13 means: 13 /* Permission denied */So check file permissions, correct them, and run again. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: lauri.pietarinen@relational-consulting.com > Subject: External tables in Win server [29099] > Date: Mon, 17 Dec 2012 05:45:43 -0500 > > Hi! > > I am testing external tables with IDS 11.70 on a Windows-server, and get the > following error: > > 17.12.2012 12:39 Executing statement: > Create external table ext_xyz (col1 integer, col2 char(20)) USING (DATAFILES > ("DISK:d:\\\\temp\\\\xyz.unl"), FORMAT "DELIMITED"); > Exec Time: 00:00:00,102; Statement executed > > 17.12.2012 12:39 Executing statement: > insert into ext_xyz select tabid, tabname from systables;> SQL Error (-26154): Could not open file: (file, errno)=(d:\\\\temp\\\\xyz.unl,13). > Error Position: Ln: 7 Col: 56 > > Any ideas? I have tried all variations using slashes back and forward and the > file exists on the server. > > Thanks, > Lauri Pietarinen > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Hi Marini, This file is a database file? The permission is Informix:Informix 660? Celso Cabral Coimbra Administrador de Banco de Dados ClearTech Ltda "Trust at the heart of Communications" Tel. (11) 3576-4509 -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Alexandre Marini Enviada em: segunda-feira, 17 de dezembro de 2012 10:26 Para: ids@iiug.org Assunto: RE: External tables in Win server [29100] Hello. -26154 Could not open file: errno, filename. An error occurred when the database server tried to open the file. Check the accompanying error for more information. Possible causes include missing file or incorrect permissions. According to your message, errno 13 means: 13 /* Permission denied */So check file permissions, correct them, and run again. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: lauri.pietarinen@relational-consulting.com > Subject: External tables in Win server [29099] > Date: Mon, 17 Dec 2012 05:45:43 -0500 > > Hi! > > I am testing external tables with IDS 11.70 on a Windows-server, and > get the following error: > > 17.12.2012 12:39 Executing statement: > Create external table ext_xyz (col1 integer, col2 char(20)) USING > (DATAFILES ("DISK:d:\\\\temp\\\\xyz.unl"), FORMAT "DELIMITED"); Exec Time: > 00:00:00,102; Statement executed > > 17.12.2012 12:39 Executing statement: > insert into ext_xyz select tabid, tabname from systables; SQL Error > (-26154): Could not open file: (file, errno)=(d:\\\\temp\\\\xyz.unl,13).> Error Position: Ln: 7 Col: 56 > > Any ideas? I have tried all variations using slashes back and forward > and the > file exists on the server. > > Thanks, > Lauri Pietarinen > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Thanks! Now it works. Lauri