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))
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?
Its NUMBER(10) only - How can I change in temporary table? when Datastream-IN trying to update temp table before updating the target table
Thanks for the input and Now the issue is resolved
User | Count |
---|---|
56 | |
27 | |
25 | |
23 | |
21 |