Oracle Temporary table creation

albasir · Post by **albasir** » Thu Mar 27, 2008 9:00 am

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

kcbland · Post by **kcbland** » Thu Mar 27, 2008 9:12 am

Why is it a problem?

albasir · Post by **albasir** » Thu Mar 27, 2008 9:16 am

column length has been varied in the output Oracle table...

ray.wurlod · Post by **ray.wurlod** » Thu Mar 27, 2008 5:35 pm

Oracle does that.

chulett · Post by **chulett** » Thu Mar 27, 2008 5:51 pm

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. ??

Yuan_Edward · Post by **Yuan_Edward** » Thu Mar 27, 2008 7:17 pm

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

DSXchange

Oracle Temporary table creation

Oracle Temporary table creation

Re: Oracle Temporary table creation