Send parameters to a AS400 stored procedure from a SQL server stored proc
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.
Networks
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.
by janania Accepted solution
by tony hopkinson Accepted solution
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
by jams772 Accepted solution
http://www.databorough.com/modernize-iseries-dds-to-sql.html
From Databorough and IBM
This discussion is closed to new replies.
Sort by Trending