Calling stored procs on AS/400

I'm already able to pull data out of the AS/400 tables using a linked server
from SQL 2000 SP3.
What I'd like to do is to be able to run stored procs on the AS/400 from SQL
Server. Not sure what SPs are called in AS/400 parlance, but you get the id
ea.
Anyone done this before?
If not, any idea how to kick-off any kind of SQL task on the AS400 from SQL
Server?Hi,
Generally we do not support executing remote stored procedures if linked
server is non-SQL Server. I assume that you are using DB2. You may check if
the following can work on DB2.
1. Create a trigger on a table in DB2 database, which calls stored
procedures. The triggering action may be insertion, update, deletion.
2. Execute openquery to the DB2 linked server from SQL Server (e.g. insert
into table, etc.)
Thus the trigger can fire the stored procedure. I understand that it may be
inconvenient for you. However, we do not have better method.
If you use ADO or ADO.NET in code, you can execute the stored procedure on
DB2.
Calling Stored Procedure From ADO.NET Results in SQLCODE: -188 (330096)
http://support.microsoft.com/?id=330096
Thank you,
Bill Cheng
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided as is with no warranties and confers no rights.
--
| Thread-Topic: Calling stored procs on AS/400
| thread-index: AcRendMRxBNgJ+1tQUeVNCcN746SiQ==
| X-WBNR-Posting-Host: 80.132.66.129
| From: "examnotes" <news@.att.com>
| Subject: Calling stored procs on AS/400
| Date: Wed, 30 Jun 2004 05:29:01 -0700
| Lines: 10
| Message-ID: <05E76F43-0C6D-4CB0-9118-BE46C1314E00@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:349340
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I'm already able to pull data out of the AS/400 tables using a linked
server from SQL 2000 SP3.
| What I'd like to do is to be able to run stored procs on the AS/400 from
SQL Server. Not sure what SPs are called in AS/400 parlance, but you get
the idea.
|
| Anyone done this before?
|
| If not, any idea how to kick-off any kind of SQL task on the AS400 from
SQL Server?
|
|
|
|
||||OK, trigger sounds good.
""Bill Cheng"" wrote:

> Hi,
> Generally we do not support executing remote stored procedures if linked
> server is non-SQL Server. I assume that you are using DB2. You may check i
f
> the following can work on DB2.
> 1. Create a trigger on a table in DB2 database, which calls stored
> procedures. The triggering action may be insertion, update, deletion.
> 2. Execute openquery to the DB2 linked server from SQL Server (e.g. insert
> into table, etc.)
> Thus the trigger can fire the stored procedure. I understand that it may b
e
> inconvenient for you. However, we do not have better method.
> If you use ADO or ADO.NET in code, you can execute the stored procedure on
> DB2.
> Calling Stored Procedure From ADO.NET Results in SQLCODE: -188 (330096)
> http://support.microsoft.com/?id=330096
>
> Thank you,
> Bill Cheng
> Microsoft Online Partner Support
> Get Secure! – www.microsoft.com/security
> This posting is provided “as is” with no warranties and confers no rig
hts.
> --
> | Thread-Topic: Calling stored procs on AS/400
> | thread-index: AcRendMRxBNgJ+1tQUeVNCcN746SiQ==
> | X-WBNR-Posting-Host: 80.132.66.129
> | From: "examnotes" <news@.att.com>
> | Subject: Calling stored procs on AS/400
> | Date: Wed, 30 Jun 2004 05:29:01 -0700
> | Lines: 10
> | Message-ID: <05E76F43-0C6D-4CB0-9118-BE46C1314E00@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
> | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:349340
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | I'm already able to pull data out of the AS/400 tables using a linked
> server from SQL 2000 SP3.
> | What I'd like to do is to be able to run stored procs on the AS/400 from
> SQL Server. Not sure what SPs are called in AS/400 parlance, but you get
> the idea.
> |
> | Anyone done this before?
> |
> | If not, any idea how to kick-off any kind of SQL task on the AS400 from
> SQL Server?
> |
> |
> |
> |
> |
>|||Hi,
I am glad to know that it can work for you. I am happy to work with you.
Thanks again for choosing Microsoft newsgroups.
Thank you,
Bill Cheng
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided as is with no warranties and confers no rights.
--
| Thread-Topic: Calling stored procs on AS/400
| thread-index: AcRfcnJUe/OsxZDeS3+6uUwDO+xsUw==
| X-WBNR-Posting-Host: 80.132.81.90
| From: "examnotes" <news@.att.com>
| References: <05E76F43-0C6D-4CB0-9118-BE46C1314E00@.microsoft.com>
<4O8IPgxXEHA.2244@.cpmsftngxa06.phx.gbl>
| Subject: RE: Calling stored procs on AS/400
| Date: Thu, 1 Jul 2004 06:51:02 -0700
| Lines: 70
| Message-ID: <EF8371DE-2652-4173-858E-7DF9749DE1F3@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 8bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:349558
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| OK, trigger sounds good.
|
| ""Bill Cheng"" wrote:
|
| > Hi,
| >
| > Generally we do not support executing remote stored procedures if
linked
| > server is non-SQL Server. I assume that you are using DB2. You may
check if
| > the following can work on DB2.
| > 1. Create a trigger on a table in DB2 database, which calls stored
| > procedures. The triggering action may be insertion, update, deletion.
| > 2. Execute openquery to the DB2 linked server from SQL Server (e.g.
insert
| > into table, etc.)
| >
| > Thus the trigger can fire the stored procedure. I understand that it
may be
| > inconvenient for you. However, we do not have better method.
| >
| > If you use ADO or ADO.NET in code, you can execute the stored procedure
on
| > DB2.
| > Calling Stored Procedure From ADO.NET Results in SQLCODE: -188 (330096)
| > http://support.microsoft.com/?id=330096
| >
| >
| > Thank you,
| >
| > Bill Cheng
| > Microsoft Online Partner Support
| > Get Secure! – www.microsoft.com/security
| > This posting is provided “as is” with no warranties and confers no
rights.
| > --
| > | Thread-Topic: Calling stored procs on AS/400
| > | thread-index: AcRendMRxBNgJ+1tQUeVNCcN746SiQ==
| > | X-WBNR-Posting-Host: 80.132.66.129
| > | From: "examnotes" <news@.att.com>
| > | Subject: Calling stored procs on AS/400
| > | Date: Wed, 30 Jun 2004 05:29:01 -0700
| > | Lines: 10
| > | Message-ID: <05E76F43-0C6D-4CB0-9118-BE46C1314E00@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.server
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
| > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:349340
| > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > |
| > | I'm already able to pull data out of the AS/400 tables using a linked
| > server from SQL 2000 SP3.
| > | What I'd like to do is to be able to run stored procs on the AS/400
from
| > SQL Server. Not sure what SPs are called in AS/400 parlance, but you
get
| > the idea.
| > |
| > | Anyone done this before?
| > |
| > | If not, any idea how to kick-off any kind of SQL task on the AS400
from
| > SQL Server?
| > |
| > |
| > |
| > |
| > |
| >
| >
|