Calling External Procedure from Java Web based Application
Home > IT Answers > AS/400 > Calling External Procedure from Java Web base...
TOKNOWIT
0 pts.
0
Q:
Calling External Procedure from Java Web based Application
OS/400, iSeries, i5, SQL, COBOL, IBM, UDB for iSeries/i5, J2EE, Java, IBM WebSphere
Below given is a procedure to access a CL Program in iSeries from a Java web based program.

create procedure libxxx/proc_name
LANGUAGE CL
FENCED
EXTERNAL NAME 'libxxx/clprogram'
PARAMETER STYLE GENERAL

The external CL program has other calls to Cobol programs in the same library.The procedure is in a different library.The cobol calls does not have any IN/OUT parameters

I would like to know if the above procedure would make any calls to cobol programs inside the defined CL.I tested based on the above procedure and it seems the calls are not being made to any cobol programs inside CL.

Anyone please suggest a workaround for the above mentioned problem of why its not making any calls to cobol programs.
ASKED: May 26 2005  5:09 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
JPLamontre
0 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Your java app call sql.
sql call cl.

Now in a cl, you can do anything a cl can.

You have qualified (ie add a library name) your external name. This means that your library list is probably the stansard sql libl : ie nothing.

if this is true, you can do :

- qualify your call to cobol
- before calling proc_name, call sql with "set path = *libl" (syntax to be checked)
- in the cl, add a chglibl
Last Answered: May 27 2005  1:52 AM GMT by JPLamontre   0 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

JoAnnB   0 pts.  |   May 27 2005  8:02AM GMT

Do you have the Java Toolbox for the iSeries? If you did you could do something like - CommandCall command = new CommandCall(as400,”SBMJOB CMD(CALL PGM(library/program) PARM(’” + parm1 + “‘ ‘” + parm2 + “‘)) JOB(job-name)”)

 

TomLiotta   7355 pts.  |   Oct 26 2009  2:11AM GMT

I would like to know if the above procedure would make any calls to cobol programs inside the defined CL[/I}

There’s no way to know from what you showed. We need to see what the CL program does if we’re going to guess if it’ll call COBOL programs or not. Show the CL.

Also, tell us if any errors are returned java when the stored proc is called. What does the java call look like?

Tom

 
0