Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

as400 and sql server linked server

Status
Not open for further replies.
gregarobinson

gregarobinson

Programmer
Jul 11, 2002
2
US
Anyone know how to write a sql server sproc that use 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?
 
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
516
Volvere
V
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
529
pjw001
pjw001
Colin Burton
  • Locked
  • Question
Determine if a file exists on s different server to the SQL Server 1
Replies
2
Views
637
gmmastros
gmmastros
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
321
Mike Lewis
Mike Lewis
grnzbra
  • Locked
  • Question
T-SQL Dialog Box
Replies
8
Views
288
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top