Data Stream In issue while writing the temporary table into Output mode "Append Existing"

[selvambt]

Info: Data Stream In (5): ODBC Driver version: 03.80
Error: Data Stream In (5): Error creating table "AYX2211164a87a9531542121fae3f69a889a1bc2d": SQL compilation error: error line 1 at position 268
Invalid number precision: 39. Must be between 0 and 38.
CREATE TABLE "AYX2211164a87a9531542121fae3f69a889a1bc2d" ("DC" varchar(4),"DC_NAME" varchar(4),"CREATED_DTTM" datetime,"OPERATION_DATE" date,"HOURS" NUMBER(5,0),"SHIFT" varchar(16777216),"SHIFT_BY_DAY" varchar(16777216),"WKND_FLAG" varchar(16777216),"SINGLES" NUMBER(39, 4),"MULTI" NUMBER(39, 4),"TOTAL_DIGITAL_UNITS" NUMBER(39, 4))

[apathetichell]

What kind of number is this prior to being fed in to the Datastream-IN? Is it a fixed-decimal 39.4? Can you change it to Double or say 38.4?

[selvambt]

Its NUMBER(10) only - How can I change in temporary table? when Datastream-IN trying to update temp table before updating the target table

[selvambt]

Thanks for the input and Now the issue is resolved