Question Locked

Send parameters to a AS400 stored procedure from a SQL server stored proc

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Does anyone know if I can send parameters from a Stored Procedure or a trigger from SQL 2000 to an AS400 stored procedure?

AS400 act as a linked server inside SQL server.

3 replies

by tony hopkinson

all you do is fully qualify the procedure name

server.db.owner.proc

This does also rely on remote sp access being enabled.

Never done link to AS400, so I don't know how much is or is not available.

Can you do it between two AS400 servers?

HTHs

This discussion is closed to new replies.