Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Call Java from AS/400 DB2 Trigger

843854Jun 18 2003 — edited Jun 20 2003

I need to call a Java Program from an SQL Triger (is there anyway to do this?).

I can call PGM files but my java program is a class file which I can call from:

1- Command Line with JAVA or RUNJVA
2- QSHELL with java
3- SQLScript with CALL QSYS.QCMDEXC('java class(holamundo.PrintParametros) PARM(1 3)',0000000047.00000)

I thought I could use the sentence CALL QSYS.QCMDEXC in an sql trigger but I couldn't.

My trigger must be able to send parameters to my JAVA Program.

I've set my environment variable CLASSPATH I need at *sys level in my AS/400 iSeries 270 with ADDENVVAR.

Thank you for your time. I appreciate any information.

Best regards.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 18 2003

Added on Jun 18 2003

#java-database-connectivity-jdbc

3 comments

413 views