how to write stored procedures

[Former Member]

hi

how you will write stored procedures in jdbc .could u pls tell me the procedure?what is key in jdbc where you will use that in which situation?could ugive me the answer briefly

thanks

nag

[Former Member · Accepted solution]

In case you are looking for <key> tag of JDBC format...

The <access> block contains the new column values and a <key> element contains the columns whose values must be identical with the specified value to get the new column values. The name of the <key> element is arbitrary. Column values within a <key> element are combined with a logical AND; different <key> elements are combined with a logical OR.

Thanks

[Former Member · Accepted solution]

can you give me one example how to define KEYS IN A STRUCTURE

[Former Member]

can you give me one example how to define KEYS

[Former Member]

Hi

A stored procedure is a subroutine available to applications accessing a relational database system. Stored procedures (sometimes called a sproc or SP) are actually stored in the database.

Stored procedures are similar to user-defined functions (UDFs).

A stored procedure is a group of SQL statements that form a logical unit and perform a particular task, and they are used to encapsulate a set of operations or queries to execute on a database server

Use this

http://www.ics.com/support/docs/dx/1.5/tut6.html

http://java.sun.com/docs/books/tutorial/jdbc/basics/sql.html

http://www.sqlteam.com/article/stored-procedures-an-overview

Thanks

[Shabarish_Nair]

To write stored procedure - http://www.ics.com/support/docs/dx/1.5/tut6.html

to use the same in JDBC adapter - /people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

[Former Member]

HI,

Refer this weblog as well:

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

Thnx

Chirag