I have a UNIX .sh script that invokes a DB2 SQL .sql script that contains the following:

db2 -t -f parmtest.sql -z parm_output.log

My question is how can I pass a parameter to the parmtest.sql script from the db2 clp (if it is possible) and how does one reference the parameter in the .sql script. The .sql script is not a procedure.

instead of using an input file, you could handle all in the script and use
db2 ..... <<done
statement with variables
..
done
in that case, the variables from the script will be translated in the db2 statements

ok, I follow you, thanks.