Description

Created a Tandem Enscribe data source and imported a record from my DDL describing the file. I made sure that the fully qualified Tandem Enscribe file was in the Connect meta data. Using the Studio Query Tool to access the table I see the following error message:

Failed to test table: [J0036] = server.internalError (query.query): HY000 General error DB_ENS_IO ENSCRIBE error 13 : The filename was not specified in proper form.; (OPEN/FILE_OPEN_) [A00D] Failed to open table datasource:table
table. Reason is: [J0036] = server.internalError (query.query): HY000 General error DB_ENS_IO ENSCRIBE error 13 : The filename was not specified in proper form.; (OPEN/FILE_OPEN_) [A00D] Failed to open table datasource:table


Solution

The fully qualified format for a Tandem file is "\NODE.$VOL.SUBVOL.FILE". In Connect you should not specify the node name as the file must be on the Tandem server machine that is running Connect. You should use the "$VOL.SUBVOL.FILE" format.