Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
 Posted - 2011-06-24 : 16:19:19
|
| Just became aware of a new system about to enter production when the development team called to say stored proc response time varies from 1 to 30 seconds and asking what I could do to help.Basic design:IVR (interactive voice response system) calls a TSQL stored proc which calls a CLR stored proc which makes a web service call to a middle tier that makes a query via a screen scraper program to an externally hosted CICS application to lookup customer info and return data to the IVR via stored proc output.Apparently they chose this way of doing things because the only capability the IVR had was to make a stored procedure call.Opinions?CODO ERGO SUM |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-24 : 16:44:28
|
Bah, just use xp_cmdshell and wget or curl.  Damn kids today always overcomplicating things. |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2011-06-24 : 17:41:08
|
quote:
Originally posted by robvolk
Bah, just use xp_cmdshell and wget or curl. Damn kids today always overcomplicating things.
I just find it shocking that Microsoft didn't supply an extended stored procedure to allow you to do 3270 emulation screen scrapes direcly from SQL.CODO ERGO SUM |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-24 : 17:56:24
|
| I used to do that kind of stuff in VBA, but not from SQL Server. We had Telnet software that could be scripted, it was a lot of fun. It also did 3270 and 5250. They didn't have a COM library that you could instantiate, but other products did, so it's possible to run it using sp_OA procs. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-24 : 19:47:14
|
| Good application for Service Broker? |
|
|
|
|
|
|
Brilliant Hack or WTF? You make the call