Jdbc Adapter with AS400

Hi All,
I am trying to use Jdbc adapter (latest) to connect to my DB2 version 5.0. I am able to connect successfully. When I try to select the data say-- the expression is RESOURCE_CODE and Column Name is RESNBR, since RESOURCE_CODE is a very lengthy name, on AS400 they called it as RESNBR. When I select RESNBR using execSQL in wmDB, it works. But when I select RESNBR using JDBC adapter it says column name does not exist. If I select RESOURCE_CODE using Jdbc adapter it is working. How can I select RESNBR from the table using JDBC adapter? Hope I am able to express my problem clearly.