Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 19 Sep 2008 @ 14:42:46 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020