Hi ,
I have a file created by a server job with data type integer(10) and while I'm designing a parallel job I mentioned it as varchar(255), my question is what is the maximum varchar length I can give in datastage. Because when ever I import a meta data it gives me varchar(255) , is varchar(255) maximum or I can define varchar(1023) for integer(10) field.
Thanks,
Raju
Maximum length of a varchar field
Moderators: chulett, rschirm, roy
Maximum length of a varchar field
somaraju
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Because text files don't have data types (other than "text") VarChar(255) is used as a default. DataStage has a really high limit on length of a VarChar (64K ?); however some databases limit it (for example to 1024) making you use Long VarChar for anything larger.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This is what's called an "unbounded VarChar".
These have a specific storage strategy in Data Sets, which ordinarily store data (even bounded VarChar) in fixed width format, because it's far more efficient to pack and unpack.
These have a specific storage strategy in Data Sets, which ordinarily store data (even bounded VarChar) in fixed width format, because it's far more efficient to pack and unpack.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.