Thanks for ur respnse.. please find below the table structure in Db2 and the piece of sas code to load the data used with passthorugh. CREATE TABLE "SOR_IDW"."table_name" ( "COMPANY" VARCHAR(7), "SPLITCLMTYPE" CHARACTER(2), "HAZARDS" VARCHAR(10), "DATEOCCURREDFROM" DATE, "DATEOCCURREDTO" DATE, "POSTCODE" VARCHAR(42), "EXCLUDING" VARCHAR(21), "EXCLUDING_WORDS" VARCHAR(151), "ADDITIONAL_WORDS_TO_SEARCH_WORDS" VARCHAR(71), "AUTHOR" VARCHAR(15), "DATE_CREATED" DATE ) SAS code : proc append DATA=&sourceLib..&sourceDataset. BASE= &TargetLib..&TargetTable. (BULKLOAD= YES BL_METHOD=CLILOAD) force; run; And the issue is with the column ADDITIONAL_WORDS_TO_SEARCH_WORDS.
... View more