Can I insert data from a report with RS2005?

Hi All,
Here's my problem:
I need to pull some items into a table report. I have the items grouped
by a key field (AlertID) and a detail the the user can drilldown to for
each item. I'm having trouble with the linking, I try to link this
report to another report that takes the parameters and runs a stored
proc to insert the data for the item (Alert History). Each report works
fine on by itself, but I can't get them to link in anyway, I've tried
Jump to Report and Jump to URL.
Any suggestions would be greatly appreciated.
Thanks,
Damien Johnston
P.S. I also need know if there is a writable textbox and a checkbox
control available in RS?In general this is a bad idea (trying to write data). Some issues you would
have to deal with are: multi-user, cleaning up data when done, etc.
Given what you say I don't see why you need to do this. If your stored
procedure can figure out the data to insert then why can't you just have a
stored procedure returning the appropriate data to the report. Instead of
drill down you should be using drill through. Drill through is much more
efficient. Have a field that you highlight and color blue. Users understand
that means to click on it. Then use jump to report to call up the report
with the detail information.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"dij0674" <dij0674@.hotmail.com> wrote in message
news:1161026120.846569.113660@.e3g2000cwe.googlegroups.com...
> Hi All,
> Here's my problem:
> I need to pull some items into a table report. I have the items grouped
> by a key field (AlertID) and a detail the the user can drilldown to for
> each item. I'm having trouble with the linking, I try to link this
> report to another report that takes the parameters and runs a stored
> proc to insert the data for the item (Alert History). Each report works
> fine on by itself, but I can't get them to link in anyway, I've tried
> Jump to Report and Jump to URL.
> Any suggestions would be greatly appreciated.
> Thanks,
> Damien Johnston
> P.S. I also need know if there is a writable textbox and a checkbox
> control available in RS?
>|||Bruce--Thanks for the reply, I'll look at alternative methods to solve
the problem.
Here are the details of what's required and what I have in place:
I have a database monitoring app the alerts when an event occurs (like
profiler)
I have specific events that need to be trapped and a historical record
needs to be kept of the original event along with any updates to an
event history field. These events are stored in a SQL DB
I need to be able to allow certain users to access this via some sort
of form/webpage, and update the events they are responsible for with
documentation, such as an email or an uploaded file.
I need to be able have a single parent to many children relationship
for the events. For example, event 1 can be chosen as the parent for
events 2,3,4,5,6 and event 1's event history will become the history
of the child events.
I sure I can get the SQL side of things, stored procs and table design.
But I'm struggling with a front end for my users; I was hoping that
RS had the ability to function in this way.
Any suggestions would be greatly appreciated.
Thanks Again,
Damien Johnston
Bruce L-C [MVP] wrote:
> In general this is a bad idea (trying to write data). Some issues you would
> have to deal with are: multi-user, cleaning up data when done, etc.
> Given what you say I don't see why you need to do this. If your stored
> procedure can figure out the data to insert then why can't you just have a
> stored procedure returning the appropriate data to the report. Instead of
> drill down you should be using drill through. Drill through is much more
> efficient. Have a field that you highlight and color blue. Users understand
> that means to click on it. Then use jump to report to call up the report
> with the detail information.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "dij0674" <dij0674@.hotmail.com> wrote in message
> news:1161026120.846569.113660@.e3g2000cwe.googlegroups.com...
> > Hi All,
> >
> > Here's my problem:
> > I need to pull some items into a table report. I have the items grouped
> > by a key field (AlertID) and a detail the the user can drilldown to for
> > each item. I'm having trouble with the linking, I try to link this
> > report to another report that takes the parameters and runs a stored
> > proc to insert the data for the item (Alert History). Each report works
> > fine on by itself, but I can't get them to link in anyway, I've tried
> > Jump to Report and Jump to URL.
> >
> > Any suggestions would be greatly appreciated.
> >
> > Thanks,
> >
> > Damien Johnston
> >
> > P.S. I also need know if there is a writable textbox and a checkbox
> > control available in RS?
> >

Can I connect without server?

Hi,
I have a customers program on my system - Omin 7 as at
http://www.omnis.net/products/omnis7/ - so I can pull the data into an
Access Database. I'd like to do this work at my place not theirs!
Is there anyway I can set up an ODBC connection so that I can read the
files. The .dsn file reads:
[ODBC]
DRIVER=SQL Server
UID=sa
DATABASE=salesteam
WSID=JERRY
APP=Microsoft(R) Windows(R) Operating System
SERVER=NTSERVER
if that helps at all.
I'm running Windows XP Pro. I guess the problem is that I don't have a
server '
Any help would be greatly appreciated, thank you.
JonAre you saying you are running SQL Server on XP? Then it should work
provided you've got file and printer sharing enabled.
If this is not the case, please elaborate on what you are attempting?
Steve
"Jon" <jon@.SPAM_OFFtheexperts.co.uk> wrote in message
news:btk6qv$t3f$1@.hercules.btinternet.com...

quote:

---

> Hi,
> I have a customers program on my system - Omin 7 as at
> http://www.omnis.net/products/omnis7/ - so I can pull the data into an
> Access Database. I'd like to do this work at my place not theirs!
> Is there anyway I can set up an ODBC connection so that I can read the
> files. The .dsn file reads:
> [ODBC]
> DRIVER=SQL Server
> UID=sa
> DATABASE=salesteam
> WSID=JERRY
> APP=Microsoft(R) Windows(R) Operating System
> SERVER=NTSERVER
> if that helps at all.
> I'm running Windows XP Pro. I guess the problem is that I don't have a
> server '
> Any help would be greatly appreciated, thank you.
> Jon
>

---

|||Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.odbc:41677
Steve,
I have NOT got sql server running, just XP PRo with IIS.
Is there any way around this - without installing sql server?
Thanks
Jon
"Steve Thompson" <SteveThompson@.nomail.please> wrote in message
news:uNlSD3u1DHA.2184@.TK2MSFTNGP12.phx.gbl...

quote:

---

> Are you saying you are running SQL Server on XP? Then it should work
> provided you've got file and printer sharing enabled.
> If this is not the case, please elaborate on what you are attempting?
> Steve
> "Jon" <jon@.SPAM_OFFtheexperts.co.uk> wrote in message
> news:btk6qv$t3f$1@.hercules.btinternet.com...
>

---

|||"Jon" <jon@.SPAM_OFFtheexperts.co.uk> wrote in message
news:btpipc$mtu$1@.hercules.btinternet.com...

quote:

---

> I have NOT got sql server running, just XP PRo with IIS.

---

It's still not clear to me what you are attempting, I asked you to elaborate
and I'm only getting little tidbits.

quote:

---

> Is there any way around this - without installing sql server?

---

Is the source data you need in SQL Server? You can get the SQL Server 2000
developers edition for $49 USD.
I wish I could provide a better answer, however lack of detail is not
helping...
Steve

quote:

---

> "Steve Thompson" <SteveThompson@.nomail.please> wrote in message
> news:uNlSD3u1DHA.2184@.TK2MSFTNGP12.phx.gbl...
a[QUOTE]
>

---

can a Subscriber be a Publisher?

sql2k sp3a
The configuration is currently.
Box1-- Publisher/ Distributor.
Several Subscribers all with Pull Subscriptions.
One of these Pull Subscriptions that my boss wants me to start Replicating
from. Can this type of deal cause problems?
TIA, ChrisR
Have a look at "republisher replication model" in SQL Server books online
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"ChrisR" <noemail@.bla.com> wrote in message
news:eDAEYipSFHA.3332@.TK2MSFTNGP15.phx.gbl...
> sql2k sp3a
> The configuration is currently.
> Box1-- Publisher/ Distributor.
> Several Subscribers all with Pull Subscriptions.
>
> One of these Pull Subscriptions that my boss wants me to start Replicating
> from. Can this type of deal cause problems?
> TIA, ChrisR
>
|||Makes sense. But what will happen if I sp_replAddColumn on the Publisher. I
know that column will make it on the RePublisher, but will it arrive on the
RePublisher's Subscribers?
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:OJI0ZiqSFHA.616@.TK2MSFTNGP12.phx.gbl...
> Have a look at "republisher replication model" in SQL Server books online
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> "ChrisR" <noemail@.bla.com> wrote in message
> news:eDAEYipSFHA.3332@.TK2MSFTNGP15.phx.gbl...
>
|||No idea...I'd have to test it against Pubs, Pubs1 and Pubs2 on my box (or
you can test it on yours...)
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"ChrisR" <noemail@.bla.com> wrote in message
news:uu7xAwqSFHA.2648@.TK2MSFTNGP10.phx.gbl...
> Makes sense. But what will happen if I sp_replAddColumn on the Publisher.
> I know that column will make it on the RePublisher, but will it arrive on
> the RePublisher's Subscribers?
>
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:OJI0ZiqSFHA.616@.TK2MSFTNGP12.phx.gbl...
>

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 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,
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: "=?Utf-8?B?SmFtZXM=?=" <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!TK2MSFT NGXA03.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 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: "=?Utf-8?B?SmFtZXM=?=" <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!TK2MSFT NGXA03.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: "=?Utf-8?B?SmFtZXM=?=" <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!TK2MSFT NGXA03.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: "=?Utf-8?B?SmFtZXM=?=" <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!TK2MSFT NGXA03.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?
| > |
| > |
| > |
| > |
| > |
| >
| >
|

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?
| > |
| > |
| > |
| > |
| > |
| >
| >
|