I haven't found any documentation about what's allowed and what isn't when you write your own SQL in Report Studio (8.4). So I'm wondering if people know of any.
For example, I can write a SQL statement with a join that has two "select *" statements (e.g., select a.*, b.* from a join b on a.id = b.id) that will work in Oracle SQL Developer but that won't validate in Cognos 8. But a simliar statement such as select a.field, b.* from a join b on a.id = b.id) validates just fine in Cognos 8.
Mostly I'm just curious -- I can do most things through the packages developed in Framework Manager. But I'm wondering why SQL statements that work in other contexts wouldn't work in Cognos 8, and if there was any documentation about it.
Thanks,
Chris F.
I think it will depend on whether you are coding Cognos SQL, Native SQL or Passthru SQL as to what results you get. I don't think Cognos SQL supports the wildcard on both queries, but passthru should work fine in theory.
Regards,
MF.