METHOD 1- libname hemi teradata user="&user." pw="&passwd." tdpid=***schema="*****" mode=teradata dbsliceparm=all; /* upload to generate a teradatatable*/ proc sql; create table db.table as select * from mytable; quit; It gives me this error. ERROR: Teradata insert: Numeric overflow occurred during computation. SQL statement was: USING ("Col1" DATE,"Col2" FLOAT,"Col3" FLOAT,"Col4" FLOAT,"Col5" DECIMAL(4,2),"Col6" DECIMAL(4,2))INSERT INTO db."table" ("Col1","Col2","Col3","Col4","Col5","Col6") VALUES (:"Col1",:"Col2",:"Col3",:"Col4",:"Col5",:"Col6"). Insert substitution values are not shown. WARNING: File deletion failed for db.table.DATA. Instead I tried this method 2 libname below and it worked. METHOD 2- libname hemi teradata user="&user." password="&passwd." tdpid="****" database=**mode=teradata bulkload=Yes fastload=yes; The table is created but missing a few rows i.e. 407 instead of 412 probably because of fastload and bulkload options. How do I fix this? Thanks for your help.
... View more