Hi all
here i am using Free Hand SQL to call stored procedure from Teradata , i am passing some parameters to SP and retriving some rows from different tables using SELECT state ments in stored procudure and inserting the same values into temp table.
Problem is when i try to run the SP using FreeHand SQL its running fine without errors but its not storing the results into temp table i mean temp table is empty,
but i tried to execute the same SP in Teradata Consol in My system with same paramaters its inserting somevalues into Temp table,,
Can any one help me why is not inserting values into Temp Table with Business objects 6.1
Note: Iam Using same DSN to businessobjects 6.1 to execute and Login to Teradata Consol
Thanx a lot
Kumar
here i am using Free Hand SQL to call stored procedure from Teradata , i am passing some parameters to SP and retriving some rows from different tables using SELECT state ments in stored procudure and inserting the same values into temp table.
Problem is when i try to run the SP using FreeHand SQL its running fine without errors but its not storing the results into temp table i mean temp table is empty,
but i tried to execute the same SP in Teradata Consol in My system with same paramaters its inserting somevalues into Temp table,,
Can any one help me why is not inserting values into Temp Table with Business objects 6.1
Note: Iam Using same DSN to businessobjects 6.1 to execute and Login to Teradata Consol
Thanx a lot
Kumar