Shell Programming and Scripting

while read TABLE; do

  db2 EXPORT TO ~/data_export/$TABLE.ixf OF IXF MESSAGES messages.txt SELECT * FROM schema.$TABLE 
done <file_which _has_tableNAmes

SQL0104N  An unexpected token ""TABLENAME"" was found following 
"<identifier>".  Expected tokens may include:  "OF".  SQLSTATE=42601

while read TABLE; do

  db2 EXPORT TO ~/data_export/$TABLE.ixf OF IXF MESSAGES messages.txt SELECT \* FROM schema.$TABLE 
done <file_which _has_tablenames

"tablename1"
"tablename2"
"tablename3"

etc...

while read TABLE; do
  echo "$TABLE"
cat> $loadsql << EOF

connect to $DB_CAT_PPSTAGE user $PSTGUSERID using $PSTGPASSWORD 
@
 LOAD CLIENT FROM $data_dir/$TABLE.ixf OF ixf REPLACE INTO $TABLE NONRECOVERABLE INDEXING MODE REBUILD ALLOW NO ACCESS
@
EOF
sh " db2 -td@ -f $loadsql"

 done < $input_file
 exit

> ${loadsql}   # Create empty db2 script file

# Append: Connect to database
cat >>${loadsql} << EOF
connect to $DB_CAT_PPSTAGE user $PSTGUSERID using $PSTGPASSWORD 
@
EOF

# Append: Create as many database load lines as needed
while read TABLE; do
echo "$TABLE"
cat >>${loadsql} << EOF
LOAD CLIENT FROM $data_dir/$TABLE.ixf OF ixf REPLACE INTO $TABLE NONRECOVERABLE INDEXING MODE REBUILD ALLOW NO ACCESS
@
EOF
done < $input_file

# Execute the connect and all the load lines
sh " db2 -td@ -f ${loadsql}"

exit