Perl CGI Scripts - DB2 SQL0206N
SQLSTATE=42703 Error Troubleshooting
[Fri Feb 13 14:21:01 2004] [error] [client 10.1.0.17]
DBD::DB2::st execute failed: [IBM][CLI Driver][DB2/LINUX]
SQL0206N "USED_STATUS" is not valid in the context where it
is used. SQLSTATE=42703, referer: http://10.1.0.20/picture_form1_submit1.html
This error message is from a Linux installation of DB2 and Apache.
This error message is the result of referring to a database table column
which does not exist.
Solution1: One option is to add the database column to the database
table, if it is needed.
Solution2: Another solution is to remove the database
field from the configuration specified within CGIScripter, then regenerate
the HTML and Perl CGI scripts to reflect this change.