DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
karthik_j013
Participant



Joined: 26 Mar 2007
Posts: 18

Points: 129

Post Posted: Wed Feb 20, 2008 7:07 am Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Server
OS: Unix
Hi,

Can I know whether Data Stage 7.5.1A is compatible with Teradata V2R6.2.
I am facing the issues in select query if the decimal datatype length is more than 18.

Please let me know on this.

Thanks,
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43085
Location: Denver, CO
Points: 222463

Post Posted: Wed Feb 20, 2008 8:00 am Reply with quote    Back to top    

Why not let us know what the 'issues' are that you are having?

_________________
-craig

"You can never have too many knives" -- Logan Nine Fingers
Rate this response:  
Not yet rated
karthik_j013
Participant



Joined: 26 Mar 2007
Posts: 18

Points: 129

Post Posted: Wed Feb 20, 2008 9:46 pm Reply with quote    Back to top    

I am using Teradata API as my source stage. And the table in the back end have Decimal(38,0) now the value of that Decimal is around (20,0).

But the Teradata API stage (Data Stage 7.5.1A) giving an error: Overflow occurred computing an expression involving DEMOTEST1.A1

But if the value of the decimal is <= (18,0). It works fine.

Is this the tool limitations or something else.

Please suggest me on this.

Thanks,
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43085
Location: Denver, CO
Points: 222463

Post Posted: Wed Feb 20, 2008 11:04 pm Reply with quote    Back to top    

'Computing an expression'? Are you manipulating this decimal field in your sql or just trying to select it? Perhaps you could post your sql.

_________________
-craig

"You can never have too many knives" -- Logan Nine Fingers
Rate this response:  
Not yet rated
abdulgani
Participant



Joined: 14 Jun 2006
Posts: 10
Location: Singapore
Points: 97

Post Posted: Thu Feb 28, 2008 1:43 am Reply with quote    Back to top    

karthik_j013 wrote:
Hi,

Can I know whether Data Stage 7.5.1A is compatible with Teradata V2R6.2.
I am facing the issues in select query if the decimal datatype length is more than 18.

Please let me know on this.

Thanks,


Karthi,

Plesae post the query.

Syed.

_________________
Syed Ibrahim Abdul Gani,
Senior DW Consultant,
Singapore
+65 97457387
Rate this response:  
Not yet rated
karthik_j013
Participant



Joined: 26 Mar 2007
Posts: 18

Points: 129

Post Posted: Fri Mar 07, 2008 5:56 am Reply with quote    Back to top    

It is a simple query.

SELECT A1,A2 FROM DEMOTEST1;
Rate this response:  
Not yet rated
throbinson


since April 2010

Group memberships:
Premium Members, Heartland Usergroup

Joined: 13 Nov 2002
Posts: 299
Location: USA
Points: 1780

Post Posted: Fri Mar 07, 2008 7:22 am Reply with quote    Back to top    

DECIMAL 18 is the largest decimal precision possible in Teradata. It is a Teradata limitation.
Rate this response:  
Not yet rated
Obiwon666
Participant



Joined: 17 Jan 2007
Posts: 22

Points: 200

Post Posted: Fri Mar 07, 2008 7:25 am Reply with quote    Back to top    

Hi,

TTU 8.2 is supported and certified with DataStage 7.5.2 and above (7.5.3, 8.0X,..), so it could be the reason.
Rate this response:  
Not yet rated
abdulgani
Participant



Joined: 14 Jun 2006
Posts: 10
Location: Singapore
Points: 97

Post Posted: Fri Mar 07, 2008 7:30 am Reply with quote    Back to top    

throbinson wrote:
DECIMAL 18 is the largest decimal precision possible in Teradata. It is a Teradata limitation.


Actuall, in Teradata v2r6 can store more than 18 digits. Only the issue is
datastage 7.5.1A drivers are not campatible to handle more than 18 digits.
If it is integer we can use bigint. If really decimal values need to go for work arround to ODBC upgrade or need to store the value as varchar.

Hope this will help.

Syed

_________________
Syed Ibrahim Abdul Gani,
Senior DW Consultant,
Singapore
+65 97457387
Rate this response:  
Not yet rated
throbinson


since April 2010

Group memberships:
Premium Members, Heartland Usergroup

Joined: 13 Nov 2002
Posts: 299
Location: USA
Points: 1780

Post Posted: Fri Mar 07, 2008 7:42 am Reply with quote    Back to top    

I was going by the Teradata pdf documentation for V2R6.0
-- 1143.pdf pg. 73.
Quote:
n the precision. The range is from 1 through 18


Was it added for the .2 release of V2R6?
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours