COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: mrcool on 10 Jan 2010 10:57:19 PM

Title: Insert Statement in Macro
Post by: mrcool on 10 Jan 2010 10:57:19 PM
Hello All,

I am trying to execute a teradata macro which has insert statement.
Exec xyz('param');-- in tab Sql
I can understand that insert and update statement will not work directly in tab sql, but want to know whether it is possible to execute through a macro.
The macro is throwing error in cognos, which is working fine while executing from teradata.
Please let me know if anyone of you tried this.
Thanx in advance.

Mrcool
Title: Re: Insert Statement in Macro
Post by: mrcool on 11 Jan 2010 05:34:22 PM
Waiting for your response Guru's... :)