If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Writing your own SQL -- Documentation?

Started by cfunkho, 26 Jul 2011 10:45:31 AM

Previous topic - Next topic

cfunkho

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.

MFGF

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.
Meep!