Page 1 of 1
What is the difference between Stored Procedure and View?
Posted: Mon May 19, 2008 10:42 pm
by Prakash3366
Hi..
can anybody tell me , What is the difference between Stored Procedure and View?
Thanks
Prakash
Posted: Mon May 19, 2008 10:47 pm
by ray.wurlod
From a DataStage perspective, a view must be accessed via some kind of SQL-using stage, which a stored procedure must be accessed only via ODBC or Stored Procedure stages.
A view is a combination of rows and columns from one or more tables.
A stored procedure is an object in the database that can perform any action at all (not necessarily involving rows and columns), for example creating a table then creating indexes and granting permissions on it.
Posted: Mon May 19, 2008 11:19 pm
by chulett
Short answer? A view is a stored query. A stored procedure is stored code, a.k.a procedural language. Both are discrete database objects.
Posted: Thu May 22, 2008 11:10 pm
by ag_ram
Googling "Difference between Stored Procedure and View" could result a lot.