Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
sundar
Participant
Posts: 30 Joined: Thu Sep 01, 2005 10:34 am
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
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
DS_SUPPORT
Premium Member
Posts: 232 Joined: Fri Aug 04, 2006 1:20 am
Location: Bangalore
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
Participant
Posts: 30 Joined: Thu Sep 01, 2005 10:34 am
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
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers