× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



That's an interesting method...

How is the trigger performance when writing to a
data queue? Is this technique used on high volume
files?

Terry

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Tuesday, June 14, 2011 12:51 PM
To: Midrange Systems Technical Discussion
Subject: Re: SQL Triggers - Never Worked With Them

Why not just do the maintenance from the AS/400? Trigger
fires and writes a
record to a data queue. Never ending server picks up record
and uses Scott's
JDBC API to update SQL Server. We do exactly that with
several projects. Let
me know if you have questions.

On Tue, Jun 14, 2011 at 10:39 AM, Mike Wills
<mike@xxxxxxxxxxxx> wrote:

We have a project now that requires us to sync data between
the i and
a MS SQL Server. I envision a table that collects the table, key(s),
and what action was performed (insert, update, delete). This table
will then be read by a C# program that will then process this table
and copy the appropriate data to the MS SQL Server.

I figured the best way to do this to avoid table changes or program
changes is to use a trigger. I have never personally used or created
triggers and now I am trying to figure out how to insert data into
another table when a trigger is triggered. Is there any
documents/articles/how-tos out there that you recommend to get me on
the right path. Some of the things I have found so far
doesn't really
explain the process well enough that I can figure out how
to create it
myself.

--
Mike Wills
http://mikewills.me
--
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



Confidentiality Notice:

The preceding e-mail message (including any attachments) contains information that may be confidential, protected by applicable legal privileges, or constitute non-public information. It is intended to be conveyed only to the designated recipient(s). If you are not an intended recipient of this message, please notify the sender by replying to this message and then delete it from your system. Use, dissemination, distribution or reproduction of this message by unintended recipients is
not authorized and may be unlawful.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.