TDExpress161003_Sles11:~/training # fastload < cload.fld =================================================================== = = = FASTLOAD UTILITY VERSION 16.10.00.00 = = PLATFORM LINUX = = PID 15436 = = = =================================================================== =================================================================== = = = Copyright 1984-2017, Teradata Corporation. = = ALL RIGHTS RESERVED. = = = =================================================================== **** 17:10:47 Processing starting at: Wed Jun 7 17:10:47 2023 =================================================================== = = = Logon/Connection = = = =================================================================== 0001 .logon 127.0.0.1/testuser, **** 17:10:47 RDBMS error 8017: The UserId, Password or Account is invalid. **** 17:10:47 Unable to log on Main SQL Session **** 17:10:47 FastLoad cannot continue. Exiting. =================================================================== = = = Exiting = = = =================================================================== **** 17:10:47 Total processor time used = '0.02 Seconds' . Start : Wed Jun 7 17:10:47 2023 . End : Wed Jun 7 17:10:47 2023 . Highest return code encountered = '12'. **** 17:10:47 FDL4818 FastLoad Terminated TDExpress161003_Sles11:~/training # gedit cload.fld TDExpress161003_Sles11:~/training # fastload < cload.fld =================================================================== = = = FASTLOAD UTILITY VERSION 16.10.00.00 = = PLATFORM LINUX = = PID 15449 = = = =================================================================== =================================================================== = = = Copyright 1984-2017, Teradata Corporation. = = ALL RIGHTS RESERVED. = = = =================================================================== **** 17:11:38 Processing starting at: Wed Jun 7 17:11:38 2023 =================================================================== = = = Logon/Connection = = = =================================================================== 0001 .logon 127.0.0.1/test, **** 17:11:38 Teradata Database Release: 16.10.00.03 **** 17:11:38 Teradata Database Version: 16.10.00.03 **** 17:11:38 Number of AMPs available: 2 **** 17:11:38 Current CLI or RDBMS allows maximum row size: 64K **** 17:11:38 Character set for this job: ASCII 0002 SET RECORD VARTEXT ","; **** 17:11:38 Now set to read 'Variable-Length Text' records **** 17:11:38 Delimiter character(s) is set to ',' **** 17:11:38 Command completed successfully 0003 RECORD 2; **** 17:11:38 Starting record number set to : 2 0004 BEGIN LOADING customer ERRORFILES error_dce, error_upi ; **** 17:11:38 Session count 2 returned by the DBS overrides user-requested session count **** 17:11:38 Number of FastLoad sessions connected = 2 **** 17:11:38 FDL4808 LOGON successful **** 17:11:39 Number of AMPs available: 2 **** 17:11:39 BEGIN LOADING COMPLETE 0005 DEFINE fcid (VARCHAR(100)), fcname (VARCHAR(100)), fdob (VARCHAR(100)), fcustcatg(VARCHAR(100)) FILE=/root/training/customer.csv ; **** 17:11:39 FDL4803 DEFINE statement processed =================================================================== = = = Insert Phase = = = =================================================================== 0006 INSERT INTO customer (cname,cid,dob,custcatg) VALUES (:fcname,:fcid,:fdob (FORMAT 'YYYY-MMM-DD'),:fcustcatg); **** 17:11:39 Number of recs/msg: 158 **** 17:11:39 Starting to send to RDBMS with record 2 **** 17:11:39 Sending row 8 **** 17:11:39 Finished sending rows to the RDBMS **** 17:11:39 Acquisition Phase statistics: Elapsed time: 00:00:00 (in hh:mm:ss) CPU time: 0.02 Seconds MB/sec: N/A MB/cpusec: 0.01 =================================================================== = = = End Loading Phase = = = =================================================================== 0007 END LOADING; **** 17:11:39 END LOADING COMPLETE Total Records Read = 8 - skipped by RECORD command = 1 - sent to the RDBMS = 7 Total Error Table 1 = 1 Total Error Table 2 = 2 Total Inserts Applied = 3 Total Duplicate Rows = 1 Start: Wed Jun 7 17:11:39 2023 End : Wed Jun 7 17:11:39 2023 **** 17:11:39 Application Phase statistics: Elapsed time: 00:00:00 (in hh:mm:ss) 0008 LOGOFF; =================================================================== = = = Logoff/Disconnect = = = =================================================================== **** 17:11:39 Logging off all sessions **** 17:11:39 Total processor time used = '0.18 Seconds' . Start : Wed Jun 7 17:11:38 2023 . End : Wed Jun 7 17:11:39 2023 . Highest return code encountered = '0'. **** 17:11:39 FDL4818 FastLoad Terminated TDExpress161003_Sles11:~/training #