Print Page - No records received at test of query subjects

Title: No records received at test of query subjects
Post by: jaroslaws on 11 Sep 2008 07:24:43 AM

Hi!

I have a lot of records in table in database stored at IBM DB2 but when I do a test of query subjects in Framework Manager I receive no records.

When I explore this table in DB2 "Center of control" I can see a "full table".

Best regards
jarek

Title: Re: No records received at test of query subjects
Post by: mr_511 on 19 Sep 2008 02:11:09 PM

When you test the query subject from query information tab take the native sql and execute this on your table see if you are getting any records. This is the actual sql passed to the database.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: jaroslaws on 11 Sep 2008 07:24:43 AM