Re: Trigger to SQLServer DB

[Dieter Bender <dieter.bender@xxxxxxxxxxxx>]

Ivan,

it would be no problem for a java program on as400 to connect to ms sequel 
server on a windows box using a type 4 jdbc driver (you can get one from ms 
or third party vendors for a few dollars, depending on your sequel server 
version); the real problem would be the connect between the trigger program 
and the java program. I would definitely not recommend to do a synchronous 
rpg java call via JNI in a trigger program. The only approach I see, is to 
decouple the trigger and the java program, by sending an entry to a DTAQ or 
socket and having a java server programm listening to the DTAQ or socket and 
writing to the sequel server.

Diieter Bender

On Montag, 5. April 2004 17:00, Ivan Hurtado wrote:
> I need to set up a connection from the iSeries to a
> Windows box running SQL Server. I then have to set up
> a trigger on a table in my iSeries that will execute
> sql insert statements into the SQL Server database.
> Can anyone help?
>
> Thanks,
> Ivan
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Small Business $15K Web Design Giveaway
> http://promotions.yahoo.com/design_giveaway/
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
> mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.

-- 
mfG

Dieter Bender


DV-Beratung Dieter Bender
Wetzlarerstr. 25
35435 Wettenberg
Tel. +49 641 9805855
Fax +49 641 9805856
www.bender-dv.de
eMail dieter.bender@xxxxxxxxxxxx