Because the server-side JDBC driver does not support create procedure or drop procedure, create the table xmp and the example stored procedure inoutproc with client-side calls of the main( ) method before executing these examples. Refer to “Overview of the JDBCExamples class”.
After creating xmp and inoutproc, you can invoke the serverMain( ) method as follows:
select JDBCExamples.serverMain('insert')
go
select JDBCExamples.serverMain('select')
go
select JDBCExamples.serverMain('update')
go
select JDBCExamples.serverMain('call')
go
Server-side calls of serverMain( ) do not require a server-name:port-number parameter; Adaptive Server simply connects to itself.