CREATE TABLE R_EXTRACT (
ID INTEGER NOT NULL,
TIME TIMESTAMP DEFAULT SYSTIMESTAMP NOT NULL,
CONTENTS CLOB NOT NULL,
) TABLESPACE "LOG";
INSERT INTO R_EXTRACT (ID, CONTENTS) VALUES (1,'This is a test extract file');
I then configured a project within Director with a database task that executes the following sql against that database:
SELECT CONTENTS FROM RTI_EXTRACT WHERE ID = 1
I then added a second task which writes the resultset (which should only be the contents of one column) out to a file.
I tried using both a ‘Write Fixed-Width’ and ‘Write CSV’ tasks, however both resulted in the following error when executing the project.
“Data ttype 'CLOB' is currently not supported by this task”
Can Linoma advise what datatypes are supported for what write tasks? Is there a better way within Director of doing what I have tried to achieve?
Since I don't know exactly what you're trying to do, I can't tell you the best way to do it. I'd recommend that you call us at 1-800-949-4696 and take the option for Support or send an e-mail to firstname.lastname@example.org.