DSXchange

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?

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.

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

@vamsi.
For numeric datatypes, you can use what we are having here in my project.
If the length(or no. of digits) <= 5 then Smallint,
6 < length <=10 then Integer,
11 < length <= 19 then Bigint,
length > 20 then Decimal.

Your original question specified a character string. Data type sizes are all specified precisely in Chapter 2 of the Parallel Job Developer's Guide.