Any Java developers out there that have called a sproc on the mainframe?

Any comments welcome.

Thanks

Brett,

Here are the basics.

// Load JDBC driver
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").ne wInstance() ;
// Get database connection
Connection connDB2 = DriverManager.getConnection
("jdbc:db2:database","username", "pwd");


//
CallableStatement cs = connDB2.prepareCall("{CALL schema.spname(?,?,?,?,?)}");

// Register your out parameters
cs.registerOutParameter(1, Types.INTEGER);
cs.registerOutParameter(2, Types.CHAR,70);
cs.registerOutParameter(3, Types.CHAR,5);
cs.registerOutParameter(4, Types.CHAR,50);

// set your in parameters
cs.setLong(5, Long.parseLong(iIdx));
// execute it.
cs.execute();

Hey,

Thanks a bunch...

Another question

Anyone doing INTERNAL stored procedures on OS/390...

Looked around in my shop (through the catalogs) and NOBODY is using INTERNAL

They're all external


Also, what's the point of external?

Still gotta write a COBOL (or whatever) program anyway...

AND I noticed that only INTERAL sprocs are stored in the database in sysroutines_src..

All Non SQL Stored Procs are EXTERNAL ...

Have a look at the CREATE PROCEDURE Statement which says LANGUAGE SQL

HTH

Sathyaram

Yeas, I know...I go tthat far...I've create the INTERnAL Sproc...

The devloper is just trying to call it...

Does anyone use INTERNAL Sprocs though?

They seem quite painful....