Hi,
i am trying to create a oracle temporary table from datastage job.
Oracle table should contain 3 columns with datatypes
NUMBER (10)
NUMBER (5)
NUMBER (2)
So, i am using the following datatypes in the DS job
NUMERIC (10)
NUMERIC(5)
NUMERIC(2)
Now, my job creates a table with the following datatypes
NUMBER (19)
NUMBER (10)
NUMBER (10)
So, i tried the user defined CREATE TABLE option with the oracle generated DDL but it is not preparing correctly in DS job.
How to get rid of this problem?
Thanks
Oracle Temporary table creation
Moderators: chulett, rschirm, roy
Oracle Temporary table creation
V'TH LUV
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No. It should create the columns based on your metadata in the job. Decimal gets translated to NUMBER and the Length will be the precision used. I've never seen the behaviour alledged here - define it with one size and it is created with a different size. ??
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 73
- Joined: Tue May 10, 2005 6:21 pm
- Location: Sydney
Re: Oracle Temporary table creation
Have you ever tried to use DECIMAL(10), DECIMAL(5), DECIMAL(2) instead of NUMBERIC.
albasir wrote:
So, i am using the following datatypes in the DS job
NUMERIC (10)
NUMERIC(5)
NUMERIC(2)
Thanks
Edward Yuan