Delete SQL statement using JMAC

Delete SQL statement using JMAC

[ Follow Ups ] [ Post Followup ] [ Message Board ]

Posted by [IP Address: 216.15.40.195] 'Amit' on September 14, 2001 at 21:27:18 EST:

In Reply to: Process Scheduler API posted by [IP Address: 216.15.40.195] 'David Wright' on September 10, 2001 at 22:53:02 EST:

Hi,
Am sorry about posting message here, as I was not able to post a new one.
Am using psjmac.jar to invoke message definitions in peoplesoft from a java program. psjmac.jar has a class name Command which has a method called Execute using which one can execute an SQL query on peoplesoft database, only limitation being, one can only perform a 'SELECT' on the database and not INSERT, UPDATE or DELETE. Is it possible to Delete/Update a record in peoplesoft database with 'DELETE/UPDATE' SQL statement using JAMC ?

Also please let me know if theres any other way to do it.

Thanks
Amit

Follow Ups:

Post a Followup

Name:
E-Mail:
Subject:
Message: : Hi, : Am sorry about posting message here, as I was not able to post a new one. : Am using psjmac.jar to invoke message definitions in peoplesoft from a java program. psjmac.jar has a class name Command which has a method called Execute using which one can execute an SQL query on peoplesoft database, only limitation being, one can only perform a 'SELECT' on the database and not INSERT, UPDATE or DELETE. Is it possible to Delete/Update a record in peoplesoft database with 'DELETE/UPDATE' SQL statement using JAMC ? : Also please let me know if theres any other way to do it. : Thanks : Amit