Question

Locked

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

By janania ·
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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Well to do it in between different sql servers

by Tony Hopkinson In reply to Send parameters to a AS40 ...

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

Collapse -

ultimate AS400-SQL Integration

by jams772 In reply to Send parameters to a AS40 ...

http://www.databorough.com/modernize-iseries-dds-to-sql.html

From Databorough and IBM

Back to Networks Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums