StrataFrame Forum

DDT Database Import

http://forum.strataframe.net/Topic7033.aspx

By Richard Keller - 2/20/2007

DDT Database Import converts Decimal(18,6) to Int.

Richard

By Trent L. Taylor - 2/21/2007

We'll look into this.  Thanks.
By Bastian Töpfer - 8/27/2008

Hi,



any news about that? I have the same issue with decimal(18,4) and decimal(18,5)

This is very important and urgent to me. Planned to roll out to the first customer tomorrow and I cant if that doesnt work.



thanks for your help,





Bastian
By Bastian Töpfer - 8/27/2008

Oh, ... that was in the wrong topic.

I actually meant that this happens when I deploy a ddt package not when I import a database
By Dustin Taylor - 9/2/2008

Sorry for the delay on this Bastian, we were all out of the office for labor day this weekend.

I believe we handled the above on an import a while back, but I'll need to reproduce the scenario you are describing on a deployment so we can work through it (if it still manifests.) I know you are in a rush for this so it is high on the priority list. I'll get back to you once I know more.

Thanks,

Dustin

By Dustin Taylor - 9/2/2008

Bastian,

I've been trying to reproduce the issue you are describing but so far everything I've tried has come accross without issue. Creating and outlining a new table in the DDT with two decimal fields (one 18,4 and one 18,5) comes accross just fine after deployment.

Are you on the latest version of the framework? The 1.6.6 beta listed here is actually very stable (it will be released officially as soon as the documentation updates are completed.)

By Larry McIntosh - 12/29/2008

I have found the DDT Import database structure converted all my numeric data types to "int".  It imported decimal types properly but not numeric.  For example, the DDT import for numeric(10,2) shows the data type as "Int" but the detail shows Size: 9, Precision: 10, Scale: 2 as for a numeric data type.  The import was from an SQL 2005 database.
By Trent L. Taylor - 1/2/2009

Larry,

Sorry for the delay here.  Our responses are generally much quicker than this but we are not in the office this week.  I will add this to the list and check into it next week.  Thanks for the heads up! Smile

By Govinda Berrio - 2/25/2009

I'm having this problem too. I have SF ver1.6.6.



Also, in the DDT Modify Table Structure screen, why isn't there a Numeric type in the Data Type drop down?



Thanks