simple example of DB2 (6.1) store procedures in JAVA? 
Author Message
 simple example of DB2 (6.1) store procedures in JAVA?
Hi:

Does any one know where I can find some simple example of how to write
store procedures in JAVA for DB2 UDB 6.1 on NT? I looked at IBM site,
it talked a lot about what store procedures do but has very few
examples.

I know SQL pretty well and have written many oracle store procedures
(using PL/SQL), but I am new to DB2 and JAVA, and would like to see
some simple example to get over syntax problem.

Thanks.

Guang

Sent via Deja.com http://www.***.com/
Before you buy.



Fri, 23 Aug 2002 03:00:00 GMT
 simple example of DB2 (6.1) store procedures in JAVA?

    Guang> Hi: Does any one know where I can find some simple example
    Guang> of how to write store procedures in JAVA for DB2 UDB 6.1 on
    Guang> NT? I looked at IBM site, it talked a lot about what store
    Guang> procedures do but has very few examples.

There are some samples in the sqllib/samples/java directory.  

    Guang> I know SQL pretty well and have written many oracle store
    Guang> procedures (using PL/SQL), but I am new to DB2 and JAVA,
    Guang> and would like to see some simple example to get over
    Guang> syntax problem.

Have you considered using the Stored Procedure Builder ? It really
eases the burden of writing Java stored procedures.

--
Toodle-pip
Sailesh Krishnamurthy  
IBM Database Technology Institute
Intranet: http://seashore.stl.ibm.com
Ph: (408) 463-3176



Fri, 23 Aug 2002 03:00:00 GMT
 simple example of DB2 (6.1) store procedures in JAVA?
See the Application Building Guide.  You get examples when you install the
SDK.  e.g.:

 Directory of C:\SQLLIB\samples\java

08/25/99  12:17a                 9,271 DB2SpCli.java
08/25/99  12:17a                 8,603 MRSPcli.java
08/25/99  12:17a                 3,177 MRSPsrv.java

Quote:

> Hi:

> Does any one know where I can find some simple example of how to write
> store procedures in JAVA for DB2 UDB 6.1 on NT? I looked at IBM site,
> it talked a lot about what store procedures do but has very few
> examples.

> I know SQL pretty well and have written many oracle store procedures
> (using PL/SQL), but I am new to DB2 and JAVA, and would like to see
> some simple example to get over syntax problem.

> Thanks.

> Guang

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Sat, 24 Aug 2002 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. How to export (DDL+data+stored procedures) Db2 6.1 on os/390 to nt

2. Problems running Java stored procedures in UDB 6.1 on NT

3. Calling a Java Stored Procedure from another Java Stored Stored Procedure

4. Problems with IBM-DB2 Version 6.1 - Right of Komma Nummbers when I write with Java

5. HELP - Backing up and restoring a DB2 6.1 database from Java

6. Backing up and restoring a DB2 6.1 database from Java

7. Supported Compiler /Java with DB2 6.1

8. DB2 6.1 that ships with Redhat 6.1

9. DB2 6.1 that ships with Redhat 6.1

10. Gettting SQL0751N trying to call java stored procedure from a java stored procedure

11. Procedure for Using Perl DBI from RHAT Linux 6.1 Web servers to Access Remote DB2 Server

12. Simple Example of Calling Stored Procedure from ASP


 
Powered by phpBB® Forum Software