Hi ,
I have to create a db2 connection for the while loop in shell scripting.

Below is the while loop.
while read TABLE; do
db2 LOAD CLIENT FROM
$DIRECTORY/$TABLE.ixf OF ixf INSERT INTO TABLENAME NONRECOVERABLE INDEXING MODE REBUILD ALLOW NO ACCESS;
done < $input_file


how to create connection for the above while loop..please help me