Cannot find row on Table

[db2dude]

When I do a select using the primary key on a DB2 table it says it cannot find the row. However, when I use an online application like QMF or Info-reports the row is out there. This happens randomly and not for a particular row/key. My program (COBOL) doesn't do any updates, deletes or inserts. Just a select. Please Help!!!

 

[mmehta]

Are you running the same exact query in both QMF and in your program ?
Sometimes, when you are selecting only some of the column values in your query
then the result will be different from when you select *. [sig][/sig]

 

[shanesmom]

Make sure that your program has been given access authority by the DBA. Cut and paste your QMF query that works into your COBOL program. Make sure that you have working storage fields defined (DCLGEN) for the table.

 

[PatrickP61]

db2dude,

I had the same problem and found out that the value of certain rows were in different case (upper or lower) than my query. In QMF, the default setting is to change all lower case to uppercase before submitting the query. So while your query in QMF may seem to be identical to COBOL, they may not be due to the automatic conversion of uppercase.

 

[harisnair]

Hi Db2dude --
u r getting SQL code +100 only..right??? or anything else?