I want to delete certain rows from a table based on my input values to a unix shell script. I am making connections and terminating it inside my shell script.
If you notice right now the field is hardcoded in the where clause.
How can I pass that value as a parameter to the script?
#!/bin/ksh set -x export DB2INSTANCE=db2clnt1 db2 ""CONNECT TO DBNAME user USER using passwd"" db2 ""delete from table where field =\'abcdefghijklmn\'"" db2 ""CONNECT RESET""