Deployment Solution

Hi

I found this article http://www.symantec.com/business/support/index?page=content&id=HOWTO5106

But I can't get the answer to work.

I tried this

set free="%#*"{call sel_free_disk_space(%ID%,'C')}"%"

echo %free%

I also tried to run the stored procedure from the sql server to see the result, this is correct. 

Kind Regards

Carsten

I do not have any DS 6.9 left here but we were using this.  In the deployment server console somewhere in the settings you have to mark the storedproc as readable...

also I see you are using #* so you are sure the default database for your user is the right one and not master or something like this ?

Found an article that tells you exactly what I meant

http://www.symantec.com/docs/TECH174001

Hi

This storedproc I used is a DS buildin (default database) and I have added it in as described in article TECH174001.

I have a nother storedproc also buildin DS %#*"{call ins_location(%ID%,'Test' ) }"% this is working. (Just to see if all settings is right)

But in the ins_location is only to insert variable and from sel_free_disk_space I want to grep the output.

Conclusion is that I can insert data but not receive data from a storedproc.

Sounds crazy but I think your problem is not the storedproc but the variable.

Can you try FREE instead of free

and if this does not work try to echo without using a variable

echo "%#*"{call sel_free_disk_space(%ID%,'C')}"%"

The result is "" and there is no difference between FREE or free

I thought that these commands would be more powerfull

But I realize that the compiler is very simple for SQL

can't you just use OSQL?