I was trying to Collect statistics on teradata tables using a variable. All my tables are recorded in a text file from where the script reads and updates the variable reading each line. But its throwing the following error
****Failure 3707 Syntax error expected something like a name between keyword 'ON' and :
Here is the Script:
Bteq << EOF
import vartext file='$scriptdir/tablelist'
using Strtable (varchar(40))
COLLECT STATISTICS ON :Strtable;
Can somebody help me if variable cant be used in Collect statistics, and any other workaround possible to do the same?