Hello friends -
I am trying to run a fast load for the source file which has data in quotes and i am getting the below errror
**** 16:20:37 Expected DISPLAY_ERRORS, NOSTOP or a valid delimiter
after the VARTEXT keyword
TD version i am using is 14 i have pressed enter at the last reocrd but still getting same error and below is my script....please help...
DROP TABLE DUMMY_UV;
DROP TABLE DUMMY_ET;
DROP TABLE DUMMY;
CREATE TABLE DUMMY, NO FALLBACK
( ID INTEGER,
SET RECORD VARTEXT DELIMITER ',' QUOTE YES '"';
BEGIN LOADING DUMMY ERRORFILES DUMMY_UV,DUMMY_ET
INSERT INTO DUMMY
Usually I feel ENTER is not pressed. You can vi the file and use ^ and $ or do head -n or tail the file. I remember in one case where I had a daily job and read from a file. One day the file was created with no ENTER. when I had a look at the file in vi, it looked very much okay. I simulated the job again and again. Half day was spent :). It is resolved by recreating a new file with prioper ENTER :).
Your setting SET RECORD VARTEXT DELIMITER ',' QUOTE YES '"'; is fine.
you said you're using TD14, but did you check your FastLoad version if it supports DELIMITER/QUOTE?
SHOW VERSIONS; should return 14, too.
Hi dnoeth -
When i do show versions i get below...
0006 SHOW VERSION;
FastLoad Version 13.10.00.16 for AIX running Socket TCP/IP
FastLoad : 13.10.00.28
FastCmds : 13.10.00.23
FastIO : 13.10.00.07
FastMBCS : 13.00.00.02
FastNtfy : 13.01.00.00
FastPars : 13.10.00.05
FastSQL : 13.10.00.34
FastUtil : 13.10.00.06
Fdlosdep : 13.01.00.00
Teradata Data Connector : 13.10.00.10
PMPROCS : 13.10.00.15
PMRWFMT : 13.10.00.09
PMTRCE : 13.10.00.02
PMMM : 13.00.00.01
PMHEXDMP : 13.10.00.01
PMUNXDSK : 13.10.00.16
ICUVER : TDICU, 13.10.00.03
CLIV2 : 13.10.00.31
MTDP : 13.10.00.25
MOSIos : 13.10.00.13
MOSIDEP : 13.10.00.12
OSENCRYPT : N/A
OSERR : 13.10.00.01
FastLoad linking date: Jan 9 2013
does this mean i am using version 13 fast load utility but i am sure my database version is below
**** 13:41:56 Teradata Database Release: 14.10.01.02
if this doesnt work could you please let me know the alternate solution for this...Thank you
yep, you're using a 13.10 FastLoad against a 14.10 TD, which is definitely causing that problem.
The solution is simple: upgrade FastLoad, simply ask your DBA, he should support this because FastLoad 13.10 is probably not certified to be used against TD14.10.