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

CQM to DQM embedded SQL Issue in COG 11

Started by highwingers, 11 Oct 2018 09:03:41 PM

Previous topic - Next topic

highwingers

Hey all, I have a report that has one prompt and when I select a value from the prompt I am getting different value in COG 10 and COG 11.
Some details
1)Report has one query which is SQL
2)Has one parameter that is in the SQL as a macro
3)We have migrated from CQM to DQM

Any advice how to fix this ?

Blue

My understanding is that DQM parses and interprets both SQL statement and macros differently from CQM. When I say differently, that is DQM is much more syntax sensitive than CQM.
In CQM you can get away with sloppy SQL syntax and be forgiven; DQM is a much harsher mistress/master.

Review you SQL syntax and macro usage. The problem may be as simple as a misused semi-colon or as complex as sub-query usage.
Robert Edis
Principal
Robert Edis Consulting
Rotorua, New Zealand