maximum length of varchar Stage variable
Posted: Fri Apr 06, 2012 3:56 am
Hi Everyone,
I have a scenario wherein i am doing vertical to horizontal pivot. This requires concatenating field to itself 80 times. The field length is 2000.This means the stage variable which is going to hold this value should be of length 160079(2000*80 + 79(field delimiter)).
Can someone confirm me what is the maximum length a stage variable or VarChar() field can have in datastage?
Is it ok if i give the field type as Varchar and leave the length as empty in both stage variable and corresponding field in transformer.
Thanks,
Suma
I have a scenario wherein i am doing vertical to horizontal pivot. This requires concatenating field to itself 80 times. The field length is 2000.This means the stage variable which is going to hold this value should be of length 160079(2000*80 + 79(field delimiter)).
Can someone confirm me what is the maximum length a stage variable or VarChar() field can have in datastage?
Is it ok if i give the field type as Varchar and leave the length as empty in both stage variable and corresponding field in transformer.
Thanks,
Suma