I have encountered the same problem while trying to insert values in the table TB_AGR_PAT_MOB_GRP:
STEP LOAD_EXP_TABLE (
'INSERT INTO ' || @DB_SCI_STG ||'.TB_AGR_PAT_MOB_GRP
' || @ANNEE ||
',' || @MOIS ||
',' || '''' || @DAT_ARR_FIC || '''' ||
The TPT output was:
Teradata Parallel Transporter Version 14.00.00.03
Job log: /opt/teradata/client/14.00/tbuild/logs/x121408-765
Job id is x121408-765, running on dmut3
Found CheckPoint file: /opt/teradata/client/14.00/tbuild/checkpoint/x1214
This is a restart job; it restarts at step LOAD_EXP_TABLE.
Teradata Parallel Transporter DataConnector Version 14.00.00.03
Teradata Parallel Transporter Load Operator Version 14.00.00.03
LOAD_TB_AGR_PAT_MOB_GRP: private log not specified
FILE_READER_TB_AGR_PAT_MOB_GRP: TPT19008 DataConnector Producer operator Instances: 1
FILE_READER_TB_AGR_PAT_MOB_GRP: TPT19003 ECI operator ID: FILE_READER_TB_AGR_PAT_MOB_GRP-1429654
FILE_READER_TB_AGR_PAT_MOB_GRP: TPT19222 Operator instance 1 processing file 'AGR_PAT_MOB_GRP.dat'.
LOAD_TB_AGR_PAT_MOB_GRP: connecting sessions
LOAD_TB_AGR_PAT_MOB_GRP: preparing target table
LOAD_TB_AGR_PAT_MOB_GRP: entering Acquisition Phase
LOAD_TB_AGR_PAT_MOB_GRP: TPT10508: RDBMS error 3618: Expression not allowed in Fast Load Insert, column MTDSGE.
FILE_READER_TB_AGR_PAT_MOB_GRP: TPT19221 Total files processed: 0.
LOAD_TB_AGR_PAT_MOB_GRP: disconnecting sessions
LOAD_TB_AGR_PAT_MOB_GRP: Total processor time used = '2.89334 Second(s)'
LOAD_TB_AGR_PAT_MOB_GRP: Start : Tue Sep 3 17:06:22 2013
LOAD_TB_AGR_PAT_MOB_GRP: End : Tue Sep 3 17:06:32 2013
Job step LOAD_EXP_TABLE terminated (status 12)
Job x121408 terminated (status 12)
It seems that TPT does not allow operations like :MTDSGE/100 in the value list. Do you have a solution on this matter, please?
The message is "RDBMS", meaning it came from Teradata.
It is not a TPT error.
You have introduced syntax that is not allowed by Teradata for the FastLoad protocol.
You will have to switch to a different operator.
Try the Update operator.