Shell Programming and Scripting

===========================
#!/usr/bash
DATABASE=XXXXX
inputFILE=$1

db2 connect to $DATABASE

TABLENAME=`echo $inputFILE|awk '{print $1}'`
COLUMNNAME=`echo $inputFILE|awk '{print $2}'`

db2 "select substr(tabname,1,20) AS TABLENAME ,substr(COLNAME,1,20) AS COLUMNSNAME ,COLNO as COLUMNPOS 
from syscat.columns where TABNAME='$TABLENAME' and COLNAME='$COLUMNNAME'";

db2 connect reset;
=============================================

TABLENAME=`cat $inputFILE | awk '{print $1}'`

Table1 Column1
Table2 Column2
Table3 Column3

TABLENAME=`cat $inputFILE | awk '{print $1}'`
COLUMNAME=`cat $inputFILE | awk '{print $2}'`

echo $TABLENAME
echo $COLUMNAME

Output:
Table1 Table2 Table3
Column1 Column2 Column3

read TABLENAME COLUMNAME x < "$inputFILE"