datatype maxsize in datastage

vitumati · Post by **vitumati** » Mon Mar 21, 2011 7:20 am

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?

ray.wurlod · Post by **ray.wurlod** » Mon Mar 21, 2011 4:50 pm

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.

vamsi.4a6 · Post by **vamsi.4a6** » Thu Jun 14, 2012 12:23 am

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

chandra.shekhar@tcs.com · Thu Jun 14, 2012 12:56 am

@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.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 14, 2012 2:07 am

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