Sometimes I just arrive hat in hand, As I belong to the OpenEdition and IBM_Main groups I am starting here. I will guess that I probably will be referred to the DB2 group list for all, or at least part of this? My clear hope is to find someone who has successfully negotiated a similar request as my own.
We want to implement a JAVA program call, a method in a class(?), from/as a stored procedure in DB2. The original request is to call DoubleMetaphone from DB2. We found DoubleMetaphone as a java procedure (CLASS/method(?), compiled it on an Intel box and ftp'd to z/OS. We don't have the IBM C compiler available, so Java seemed our choice. After requesting help from Java people here, I got DoubleMetaphone to respond from IBM UnixSS with a batch job calling a Test-Method/Class. I also did this from the UnixSS command line. There was our success so far. DoubleMetaphone compiled and working with Java in z/OS 1.7 UnixSS from Batch or command line. So far so good. I took the results to our DB2 person, who now has Redbooks and manuals spread across the room as far as the eye can see. At least three of us have looked at them so far. We have a stored procedure. We call the stored procedure, or our DB2 person does. Our test cannot find the Class/Method. We never get stdout, stderr. We don't get that far. We have input the Class name in the DB2 stored procedure, as well as other variables and parameters,(CLASSPATH and others) and in our simplest test are calling "Main" as the method. The error indicates in output cannot find (blank.blank) " . " class.method, we think indicating it has no idea what for what class or method it is looking. This is our current state. We are not trying to access the DoubleMetaphone yet from DB2, only run the simplest Java test program we could find, to print a small 3 number array. Any and all help would be greatly appreciated. I am on digest mode, so if you reply to Kevin(dot)omara(at)acgov.org, I will see it quicker, and I will try to watch the website for responses. I have our DB2 person ready to help field any questions. I am also posting this at IBM-Main, and will maybe end up at Db2 listserv? I appreciate all of your comments and insights daily. Thanks greatly, Kevin O'Mara Technical Services Alameda County ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
