Passing sql parameters to cognos

[oshCog12]

Hi,

I have inherited a stand alone web application that uses Cognos report net 1.1 to create reports. Cognos queries a remote SQL database via framework manager using parameters passed to it from the stand alone web app.

Now here in lies the mystery for me. I know how the web app is passing the sql parameters to Cognos via a string. I know how the app is displaying the reports from Cognos via an IFrame.

What I don't know is how Cognos recognizes the passed SQL parameters. Where it keeps the code that does the recognizing and the calling of the stored procedure on the remote SQL database. Can anyone clarify this for me. Thanks

 

[blom0344]

Does the framework contain one or more query subjects that harbor a stored procedure?
A quick way is to take the model.xml of the framework and scan for syntax that normally goes with a stored procudure..

Ties Blom