LONGVARCHAR datatype usage in Universe stage

sujaoschin · Post by **sujaoschin** » Tue Oct 21, 2008 1:10 am

I am having the input columns with datatypes of

COLUMN NAME-DATATYPE-LENGTH
1)ASSETNUM-VARCHAR-12
2)DESCRIPTION-LONGVARCHAR-4857600

Condition is 'If the assetnum is repeated, then concatenate all the description values

Eg-
assetnum description
1 apple
2 mango
1 mandarin

Ans should be (output) -
Assetnum description
1 apple,mandarin
2 mango

So I created a Universe for these columns. When I gave 'CREATE TABLE REPHIST_UNV(ASSETNUM VARCHAR(12), AS_DESCRIPTION_LD LONGVARCHAR(4857600)); in Edit DDL tab of Universe stage I am getting this error.

Column 'DESCRIPTION' use SQL types that are not supported by this data source. Is there any other datatype for Universe to store the CLOB datatype?

ArndW · Post by **ArndW** » Tue Oct 21, 2008 4:40 am

Stay with longvarchar; DataStage server strings can be as long as you wish (limitation is how much virtual address space your process can allocate, not an actual number-of-bytes one).

ray.wurlod · Post by **ray.wurlod** » Tue Oct 21, 2008 1:41 pm

Use VARCHAR(65532) - UniVerse does not have a LONG VARCHAR data type.

sujaoschin · Post by **sujaoschin** » Thu Oct 23, 2008 7:22 pm

Thanks. Instead of using universe stage I tried with sort and transformer ( stage variable ) for concatenation. It worked.