DSXchange

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

Why is it a problem?

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

Oracle does that.

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

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