File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Any sample working code or tutorial for dynamic sql in db2 procedures Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Any sample working code or tutorial for dynamic sql in db2 procedures " Watch "Any sample working code or tutorial for dynamic sql in db2 procedures " New topic
Author

Any sample working code or tutorial for dynamic sql in db2 procedures

Biju moozhikkara
Greenhorn

Joined: Oct 21, 2005
Posts: 20
Hello,
Can any body provide me with Any sample working code or tutorial for dynamic sql in db2 procedures.

i need to change certain part of sql statment, like order by field dynamcally.

Regards
Biju M
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29237
    
139

Biju,
A quick google search found this example. Are you looking for something more specific?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Biju moozhikkara
Greenhorn

Joined: Oct 21, 2005
Posts: 20
Hello Jeanne ,
Thanks for the link.But i was looking for dynamic sql embedded in db2 stored procedure. hope that is very much possible.

Regards
Biju M
Sagar Dafle
Greenhorn

Joined: Nov 06, 2012
Posts: 18
This is the SIMPLEST SP that i executed ..

CREATE PROCEDURE SP_SAMPLE()
DYNAMIC RESULT SETS 1
BEGIN
DECLARE c CURSOR WITH RETURN FOR
SELECT * FROM sagar123.emp;
OPEN c;
END
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Any sample working code or tutorial for dynamic sql in db2 procedures
 
Similar Threads
Google group for SQL
Stroed Procedure&PL/SQL
Table pagination for about 40 rows per page
Help for Dynamically changing sort by field and order by clause, in db2 procedure
Java Stored procedure