Posted: 14 Mar 2015 14:21 EDT Last activity: 15 Oct 2015 13:46 EDT
DB2 SQL Error in sample application report
In the Solution provided for the Sky Airlines sample application - part of LSA course , I am getting SQLState error when I run the AllComplaints report and then select the category type.The error is as follows:
There was a problem getting a list: code: -440 SQLState: 42884 Message: DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=PR_READ_FROM_STREAM;FUNCTION, DRIVER=3.59.81
I have setup the appliation on 6.2SP2 personal edition.
Please let me know if anybody faced this issue or has a solution for this.
You should not see this error using the PVS but can see it if after deploying to a DB2 Cloud instance. The error results from attempting to read a column that is not exposed, i.e., is stored in the BLOB. Check your Report Definition warnings - PreFlight will show you these. "Kill two birds with one stone". Otherwise you need to find the missiing UDF jar that permits BLOB reads for DB2. Your time is better spent so doing the former - exposing the columns.