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
maximum length of varchar Stage variable
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 7
- Joined: Mon Oct 30, 2006 12:19 am
Note: Please take note of this IBM tech note: :D
Parallel Engine data sets and sort operations with VARCHAR/NVARCHAR columns may require the maximum length specified to store data on disk.
http://www-01.ibm.com/support/docview.w ... wg21458132
Parallel Engine data sets and sort operations with VARCHAR/NVARCHAR columns may require the maximum length specified to store data on disk.
http://www-01.ibm.com/support/docview.w ... wg21458132
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
- Participant
- Posts: 41
- Joined: Sat Jun 06, 2009 11:13 pm
- Location: Kolkata
Not true. Did you know that max length is also not 999999999 (nine nines)?nayanpatra wrote:The maximum length of a varchar field can be of 255.
Max length it will accept is 2^31 - 1 (2 to the power of 31, minus 1), or you can leave it blank. Try it for yourself.
I have seen some IBM tech notes that suggest max length is 2^31 - 5...
This is the kind of info I would expect to find in the Parallel Job Developer's Guide chapter 2 section on data types. However, it is not documented there.
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
- Participant
- Posts: 91
- Joined: Wed Apr 20, 2005 7:59 pm
- Location: U.S.