Loading data into CLOB columns using DRS Stage

CGI_SUREN · Post by **CGI_SUREN** » Thu Feb 05, 2009 3:18 pm

Has anyone loaded data into Oracle CLOB columns using DataStage? Using Dynamic Relational Stage (DRS) in a Parallel Job, when I try to load data into an Oracle table containing CLOB column, it is loading only 1 byte into the column.
Please let me know if you have any information on this.

chulett · Post by **chulett** » Thu Feb 05, 2009 3:28 pm

Have you tried searching the forums for "CLOB"? The issues with that (unsupported) data type have been discussed here quite a bit.

CGI_SUREN · Post by **CGI_SUREN** » Thu Feb 05, 2009 6:07 pm

I do not get anything when I search on "CLOB" or "LOB". Are you getting results when you search on "CLOB" or "LOB"

chulett · Post by **chulett** » Thu Feb 05, 2009 6:21 pm

Of course - an Exact Match search for CLOB returned 121 matches for me.