Stored Procedures

[Former Member]

What is the purpose of Stored procedures in XI.

How to configure stored procedures in XI.

[Former Member · Accepted solution]

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

[former_member189387]

Hi ,

<b><i>

What is the purpose of Stored procedures in XI.</i></b>

It is used in JDBC Channels. Please refer the introduction about stored procedure

<b>

<i>How to configure stored procedures in XI.</i></b>

Please refer the following link

JDBC Stored Procedures

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Regards.,

V.Rangarajan

[prateek]

Stored procedures has actually no use in XI.

Stored procedures are used at the sender or receiver side. XI just manages to receive a call or invoke a call to stored procedures which actually resides at the sender or receiver end.

Regards,

Prateek

[former_member335553]

Stored proceedures are precompiled piece of SQL code writetn on your DB..

http://www.functionx.com/sqlserver/Lesson16.htm