Hi Friends,
I have column "Comment" in my source I'm getting 8000 character for that column.
Can datastage support 8000 character for in cloumn. ?
what is the max datatype for VarChar fields in datastage?
datatype maxsize in datastage
Moderators: chulett, rschirm, roy
datatype maxsize in datastage
Abhinav
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DataStage has no limit, but most database servers do. If you import the table definition it will give you the correct data type, whether it's VarChar or LongVarChar.
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.
Could you please clarify below doubts for datatype maxsize in datastage?
1)If the DataStage has no limit for datatype when to use smallint,bigint,integer in datastage?
2)when i gone through the post in the link
viewtopic.php?t=146172&highlight=overflow
I understood that there is some limit for signed Integer,unsigned integer etc datatypes
I am totally confused whether datatypes in datastage is having any maximum limit or not ?
Please correct me if i am wrong
1)If the DataStage has no limit for datatype when to use smallint,bigint,integer in datastage?
2)when i gone through the post in the link
viewtopic.php?t=146172&highlight=overflow
I understood that there is some limit for signed Integer,unsigned integer etc datatypes
I am totally confused whether datatypes in datastage is having any maximum limit or not ?
Please correct me if i am wrong
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: