How we create a report to update database in cognos

Cognos doest allow direct update to database but it will allow us to create a report to call a store procedure, using this stored procedure we can update database. For this, stored procedure need to be imported in Framework manager.

Comments

Post a Comment

Popular posts from this blog

Integration Control

Integration control used in making conditions for processing  provides a way to match xml field or object field with particular value. We have 4 types of integration control 1. Value 2.List 3. XRef 4.Boolean Value control is used to compare with single value. List control is used to compare with list of values which may come from domains. Boolean control is true or false value used to compare yorn field I personally never used it. XRef control i.e cross reference control is used to to swap values foe example we have different orgid in other system than we can define cross reference control inorder to translate. We create cross reference control and associate it with enterprise service or publish channel. We can also override these values at external system level.
Read more

Zensar Java interview questions

1. Difference between abstract and interface. 2. Difference between result in case of put a s post if everything is same. 3. Java 8 features ? 4. What's is need for default method in Java 8 in interface? 5. Jdbc template and callable statement use? 6. How u loop in stored procedure write a programme. 7. Comparator programme? 8. Why string is immutable? 9. What is difference between a+b and a+=b?
Read more