Hello all! I am having a problem with a SELECT... WHERE statement. If I just do a simple SELECT statement I can pull data from the table, however if I try to add a WHERE clause to this SELECT, I receive an Error: DB2 SQL Error: SQLCODE = -206, SQLSTATE=42703. After looking around I think I know that this error means that the column I'm trying to use in the WHERE clause could not be located. However data is pulled from that column when just the SELECT is run. Any suggestions?
but if the query is changed to (SELECT * FROM USERS WHERE username = 'whatever username I want to look up'), I get Error: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=USERNAME, DRIVER=3.68.61.