Creating Tables with Relativity

I'm using relativity to create temporary workfiles via ODBC -- 

Does anybody know how to create the file in a different directory than the install directory for relativity -- hopefully this is possible to do from within the query -- because I'd like different temp tables to be placed in different directories to help organize them

For example -- the following query works

CREATE TABLE tester
(
col1 CHAR(10),
col2 CHAR(100),
col3 CHAR(50),
col4 CHAR(1),
col5 decimal (10, 7)
);

but I was hoping that something like this would work somehow

CREATE TABLE tester @FILENAME=/tmp/tester.tmp.data
(
col1 CHAR(10),
col2 CHAR(100),
col3 CHAR(50),
col4 CHAR(1),
col5 decimal (10, 7)
);

creates a file /opt/microfocus/relativity/data-server/tester.tbl

I was hoping to have this file be located elsewhere --

/tmp/tester.tmp.data

I have figured out how to use the following commands to move the path of the file -- however it still ends up leaving an empty file tester.tbl sitting in the install directory.

{call DBA_ListFileConns()};

{call DBA_ModifyPathName('CCKJ ', '/tmp/tester.tmp.data', '')};

{call RDB_CreateFile('tester')};

 

 

Tags: