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.