Search Results

You mean Table_name contains a "1"? Not too surprising (man awk):
You might try "db2 -x \"SELECT TRIM... " | getline Table_name, given your db2 command yields some correct result.

You could use awk to produce the SQL statements to query the database and pipe the output to the DB2 CLP, for example

awk -f script.awk inputfile | db2 +p -x

You will have to print the CONNECT...