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

Equivalent "For Each" command in Cognos

Started by FLPylot, 08 Jun 2016 01:39:46 PM

Previous topic - Next topic

FLPylot

What is the Cognos equivalent to the SQL Server FOR EACH Loop command?

bdbits

As far as I am aware, Microsoft SQL Server does not have a FOR EACH control flow statement. What are you trying to do?

If you have procedural code, you should put it in the database as a stored procedure. You can call that from Cognos.

But databases are built for set-oriented operations. Most of the time, you should be able to get what you want without resorting to stored procedures.