• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

CloudScape Stored Procedures

 
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'm am searching for a few examples of stored procedures.
#1 a stored procedure that return's a simple result set
(or)
#2 a stored procedure that performs and update
(or)
#3 any other examples would be appreaciated
TIA, Monty6
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
Try out the Java Tutorial: http://web2.java.sun.com/docs/books/tutorial/jdbc/index.html
or more specifically: http://web2.java.sun.com/docs/books/tutorial/jdbc/basics/sql.html
You can also download the SQLServer Documentation file from Microsoft at: http://www.microsoft.com/sql/downloads/P51745.htm
Hope this helps.
cheers,
Yoo-Jin.
[This message has been edited by Yoo-Jin, Lee (edited September 18, 2000).]
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thank-you.
I'm looking for vendor specific code....
Do you know where I can find any vendor specific code examples.
TIA, Monty6
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

I'm not too sure what vendor server you're interested in, but you could start with SQLServer: http://www.microsoft.com/sql/downloads/P51745.htm
The online help documentation is free for downloading. The online help includes examples for all the sql commands too. I don't know if oracle or db2 doc's are free since I've never used them.
cheers,
Yoo-Jin.
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks for the info...
I'm interested in Informix's CloudScape or Oracle 8i
stored procedures code examples.

------------------
We learn more from our mistake than from our successes.
Monty6
 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
There are some pointers available now in the Cloudscape
FAQ at http://www.cloudscape.com/support/faq.jsp.
Look under the SQL topic.
Cloudscape uses Java as its stored procedure language,
and provides Class and Method aliases as a way to
make invoking them in SQL use the same SQL as other
vendors. You simply define a static public method
in a class, and then you can use it in SQL statements;
void methods would use the CALL statements, non-void
methods can also be used as expressions within
statements.
To call back to the database, you connect using the
standard jdbc:default:connection JDBC URL, and
then use JDBC to access the database, on the same
connection as the caller. You can also open new
connections (the Cloudscape tutorial shows examples
of doing this).
Hope this helps, and apologies for not finding
this forum until now...
Ames Carlson
ames.carlson-at-informix.com
 
reply
    Bookmark Topic Watch Topic
  • New Topic