to read a paragraph data(clob datatype)

ds_ram · Post by **ds_ram** » Thu Jun 07, 2007 11:06 pm

Hi,
We have a requirement to read a text data which is running in paragraphs with newlines in between. The source is a sequential file. We have defined LongVarChar in DataStage to read this column as the target database will have CLOB datatype for this column. But still when I tried to view the record in the Seq File stage, it puts the record in a disordered way. can any one help me how to read such a record and load the same?

Thanks in advance.

chulett · Post by **chulett** » Thu Jun 07, 2007 11:12 pm

A "disordered way"? You may want to explain what that means.

Sounds like you haven't even gotten to the CLOB part yet. Are you having a problem simply trying to read the file because there are newlines in one field? Move the Columns tab in the Sequential File stage over to the right and change the 'Contains terminators' option for that column to 'Yes', see if that helps...

ray.wurlod · Post by **ray.wurlod** » Fri Jun 08, 2007 1:33 am

If it's a text file, simply mark the column "contains line terminators" (scroll right in the Columns grid to find this setting).

chulett · Post by **chulett** » Fri Jun 08, 2007 6:36 am

Huh... guess there's an echo in here here here.

ds_ram · Post by **ds_ram** » Fri Jun 08, 2007 7:36 am

The source is a text file only which has 3 columns. One of the columns is to be populated to a clob datatype field in target. I will try the option of specifying contains terminators. Sorry for the delayed reply.