No rows qualified in Select clause

satyender · Posted: Thu Sep 25, 2008 9:53 pm

Hi all,

Here is the situation.
When I am querying a table it is giving all the data.
using:
select * from table1;

but when I am trying to get the specified value using a where clauseit is giving an error
as 'no rows qualified'

If i take runstats would it solve this problem or do i need to do more,
could anyone pls suggest me.

Thanks in advance.

CICS Guy · Posted: Thu Sep 25, 2008 10:01 pm

Your clause or value is not correct, post it....

satyender · Posted: Thu Sep 25, 2008 10:08 pm

Thanks for your response.

The value is correct.
I can see the value.

if I give VVIN = 'JTDAT123XY0012457' in file Aid for DB2 and execute it shows the message 'No Rows Qualified', But if you execute without any parameters it shows the entire table contents including the VIN 'JTDAT123XY0012457'.

CICS Guy · Posted: Thu Sep 25, 2008 10:14 pm

I would suggest that you view it in hex to see what the difference is......

guptae · Posted: Fri Sep 26, 2008 11:19 am

Hello Stayender,

Runstats used to update catalogue tables it & db2 uses it to select access paths to data during the bind process.

It's will not effect the runstat table data & answer to your question regarding why u are not getting data while giving where clause. For these pleasepost the full query as well as check hex value for output of select

sushanth bobby · Posted: Fri Sep 26, 2008 6:08 pm

Hi Satyender,

Try like this, it might click

select * from table 1 where VVIN = '%JTDAT123XY0012457%'