store procedures in DIW

[amyygt]

I need exactly the same as in thread959-1003455. We need to execute a huge stored procedure and I don't have a clue to do it. I will appreciate any help (running CCMS 6.0)

Thanks in advanced,

 

[amyygt]

Can I just call the procedure? Do I have to add all the procedure to the DIW? In this case, how can we handle all the temporary variables?

 

[mte0910]

Outside of creating a custom HDX application, you will have to create the querry in the wizard and execute it via a send call get response, etc.

 

[amyygt]

Yes, but when I write execute PROC_NAME(input1,output1,output2) I get SQL Failure 51514 and I know the user has the rigts and the command is correct, because I alrady tested in the DB client

 

[mte0910]

One thing I have found about DIW is that just because it works in a SQL Query builder, does not mean it will work in the DIW.

Often I have to "tweek" the statement to get it to do what I want. The good news is the there is a Test button in the wizard that will allow you to "play" with your statement until you get the expected result(s).

All I can really tell you is, be patient.

 

[amyygt]

Ok, thanks....

This is my first time with the DIW, so I'm trying with a simple sql statement, just a select statement and it works perfectly in the Test, but when I'm using the scripting it returns FAILED in the sql_status variable. I have this script:

ASSIGN "NODATA" TO sql_status
SEND REQUEST id_hdx id_sql, Input1
GET RESPONSE id_hdx sql_status, Output1

And the sql statement is:
select OUTPUT1 from TABLE_NAME where INPUT1 = '?'

Any suggestions??

 

[mlpress]

Hello
We are having this exact problem. I am currently working with our Provider, Nortel Professional Services , A Sr. Nortel Technical Support Engineer, the developper that designed the TFA servics and finally we plan to get someone in Nortel who knows about Databases. As mte0910 mentioned you need to be extremely patient!! We thought this was going to be a very easy process, just entering a few commands in the DIW and we would be done with it. We have been trying to get this done since June of 2006 and still no luck. I'm now looking at third party tools and other possibilites. We are also able to do exactly what we want via SQL + but not with the DIW. It is extremely frustrating. I will let you know if we have any luck with the Nortel DB Specialist...until then