Data stage 7.5.1A connectivity with Teradata V2R6.2
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 18
- Joined: Mon Mar 26, 2007 1:02 am
Data stage 7.5.1A connectivity with Teradata V2R6.2
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,
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,
-
- Participant
- Posts: 18
- Joined: Mon Mar 26, 2007 1:02 am
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,
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,
Re: Data stage 7.5.1A connectivity with Teradata V2R6.2
Karthi,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,
Plesae post the query.
Syed.
Syed Ibrahim Abdul Gani,
Senior DW Consultant,
Singapore
+65 97457387
Senior DW Consultant,
Singapore
+65 97457387
-
- Participant
- Posts: 18
- Joined: Mon Mar 26, 2007 1:02 am
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA
Teradata v2r6 can store more than 18 digits
Actuall, in Teradata v2r6 can store more than 18 digits. Only the issue isthrobinson wrote:DECIMAL 18 is the largest decimal precision possible in Teradata. It is a Teradata limitation.
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
Senior DW Consultant,
Singapore
+65 97457387
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA