I am fairly new to Qlik.
Using Qlik replicate to load data from DB2 to Snowflake.
One of the tables that I am loading have timestamp datatype with length 13 in the source DB2 table.
When Qlik task runs its unable to create the table in Snowflake.
Qlik builds the create statement as below (the last 2 columns which have TIMESTAMP(13) datatype in DB2 do not have a datatype in the create statement that Qlik builds)
CREATE TABLE "SCHEMA_NAME"."TABLE_NAME" ( "ID" VARCHAR(19), "ACCT_NUM" NUMBER(15,0), "STAT_CD" VARCHAR(5), "DSPLY_TXT" VARCHAR(200), "RSN_CD" VARCHAR(5), "CREATION_TIMESTAMP" TIMESTAMP(6), "UPDATE_TIMESTAMP" TIMESTAMP(6), "START_TIMESTAMP" , "END_TIMESTAMP" )
If the source table/column datatype is TIMESTAMP(11) it is translated to TIMESTAMP(6) whereas TIMESTAMP(13) columns are not associated to a datatype when Qlik tries to create the table.
Error Message:
CREATE TABLE "SCHEMA_NAME"."TABLE_NAME" ( "ID" VARCHAR(19), "ACCT_NUM" NUMBER(15,0), "STAT_CD" VARCHAR(5), "DSPLY_TXT" VARCHAR(200), "RSN_CD" VARCHAR(5), "CREATION_TIMESTAMP" TIMESTAMP(6), "UPDATE_TIMESTAMP" TIMESTAMP(6), "START_TIMESTAMP" , "END_TIMESTAMP" ) [1022505] (cloud_imp.c:4160)
[TARGET_LOAD ]E: Error executing data handler [1022505] (streamcomponent.c:1998)
[TARGET_LOAD ]E: RetCode: SQL_ERROR SqlState: 42000 NativeError: 1003 Message: SQL compilation error:
In the DESIGNER - TABLE SETTINGS - TRANSFORM tried to change the datatype to DATETIME(6) similar to other TIMESTAMP columns, still getting the same error.
