TechTip: Remote SQL

[jmarti53@ford.com]

** This thread discusses the article: TechTip: Remote SQL (http://www.mcpressonline.com/index.php?option=com_content&view=article&id=3176) **
I'm missing from this tip the TCPIP services required to be active to be able to activate the remote SQL. In a controlled environment, not all services are active, needing to know which ones are really required and the implications of having them. I cannot remember just now which ones are. I'm sure someone else may put some light onto this.

[denis_roche]

** This thread discusses the article: TechTip: Remote SQL (http://www.mcpressonline.com/index.php?option=com_content&view=article&id=3176) **
I use to run SQL on remote system from "AS400 operation navigator". Is there advantages to do it your way (I am most thinking about performances) ?

[tim.tankard@gentiva.com]

** This thread discusses the article: TechTip: Remote SQL (http://www.mcpressonline.com/index.php?option=com_content&view=article&id=3176) **
Can the connect statement be used in a stored procedure? I can get this all to work interactively, but what I want to do is create an SQL stored procedure that connects to a remote AS/400 database and then returns data. But I can't get the procedure to compile. Any ideas? The idea is to use this as a replacement for DDM connections.

[MCWebsite.Staff]

** This thread discusses the article: TechTip: Remote SQL (http://www.mcpressonline.com/index.php?option=com_content&view=article&id=3176) **
** This thread discusses the Content article: TechTip: Remote SQL (http://www.mcpressonline.com/index.php?option=com_content&view=article&id=3176)0