Hi,
I'm new in Java and read some articles mentioned that by using the JDBC driver in AS400 can connect to the MS SQL Server 2005 (which is sitting on WS2003 box).
We add a trigger in one of the physical file, what we want is when the update trigger was fired, then would like to update the SQL Table on the MS SQL server based on the value that changed on the AS400 table.
How hard will that be regarding the JDBC part or JAVA prorgram to do this. Also, how can I check if our iSeries is JAVA installed? any command that I can test it out?
Thanks for the help!
I'm new in Java and read some articles mentioned that by using the JDBC driver in AS400 can connect to the MS SQL Server 2005 (which is sitting on WS2003 box).
We add a trigger in one of the physical file, what we want is when the update trigger was fired, then would like to update the SQL Table on the MS SQL server based on the value that changed on the AS400 table.
How hard will that be regarding the JDBC part or JAVA prorgram to do this. Also, how can I check if our iSeries is JAVA installed? any command that I can test it out?
Thanks for the help!
Comment