 |
 |
Archives of the TeradataForum
Message Posted: Fri, 19 Sep 2008 @ 14:42:46 GMT
| Subj: | | Re: Web services |
| |
| From: | | Victor Sokovin |
| | I would like to find out if it�s possible to invoke/call web services (built using .Net and deployed on IIS platform) from within TD stored
procs, or UDF�s, or BTEQ scripts. | |
Should not be a problem even from a simple BTEQ script. It is possible to include a call to any external OS command. If you can call the web
service from the client on which you execute your BTEQ script then you are in business. Check out the command .OS in the BTEQ manual for more
details.
Of course, this is only a simple call. You cannot expect any database-style transactional integrity or automated rollback functionality etc.
for external calls. If something goes wrong there it is the responsibility of the script to handle it. Getting the return codes and other
execution details back to the BTEQ script is also done on a case-by-case basis. You can use files or tables for getting the information back to
BTEQ.
Victor
| |
