gregarobinson
Programmer
Anyone know how to write a sql server sproc that uses a linked server to an AS400? We are able to create the linked server for the AS400 and then use query analyzer to write sql selects and pull data off the AS400. We now want to move our sql selects into sprocs. We have sprocs on the AS400 side already written, but we want to move the business logic off the as400 and onto sql server. So, 2 questions:
1- How do I write a SQL Sproc that uses an AS400 linked server?
2- Is is possible to call existing AS400 sprocs from a linked server?
1- How do I write a SQL Sproc that uses an AS400 linked server?
2- Is is possible to call existing AS400 sprocs from a linked server?