Data type to choose

sundar · Post by **sundar** » Tue Aug 07, 2007 5:43 am

Hi,

My Database is SQL Server.

I am able to import table definition from the database.

when i try to view data from the ODBC stage, i am getting the error
CHECK DATASTAGE IS SETUP CORRECTLY.

when I delete this column MESSAGE LONGVARCHAR of length
2147483647 from column definition, i am able to view the data.

what datatype that i should use for this colummn MESSAGE or is any other way to solve.

please help me in solving this issue.

Thanks & Regards
Sundar

chulett · Post by **chulett** » Tue Aug 07, 2007 6:32 am

What is the datatype of this 'message' field in your database? Some types, like TEXT fields, are not easily supported - if they are supported at all.

DS_SUPPORT · Post by **DS_SUPPORT** » Tue Aug 07, 2007 9:16 pm

For TEXT datatype, we are using Varchar(2000) and the jobs are running fine.

sundar · Post by **sundar** » Wed Aug 08, 2007 2:02 am

Hi

Thanks to Everyone.

Datatype for the Column MESSAGE in database is TEXT.

In Datastage i typed varchar 2000 for this column,but it is throwing the same error.

ERROR CALLING SUBROUTINE:DSD.Browse (Action = 3): check

Datastage is setup correctly in project

Thanks
Sundar

chulett · Post by **chulett** » Wed Aug 08, 2007 6:45 am

Hmmm... actually, I was thinking of some conversations I'd recently had on the subject of TEXT fields in Sybase, not SQL Server. Since I know Jack about the latter, I'll bow out and let others help.