GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  DataStage
Go To First  |  Previous Question  |  Next Question 
 DataStage  |  Question 53 of 140    Print  
How can i call a stored procedure only once instead of calling for each and every row?

  
Total Answers and Comments: 1 Last Update: September 23, 2008     Asked by: suganya 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
September 23, 2008 08:35:52   #1  
Abhijain Member Since: December 2007   Contribution: 20    

RE: How can i call a stored procedure only once instead of calling for each and every row?
There is a stage named Stored Procedure available in Datastage palette under Database category. You can use that stage to call your procedure in Datastage jobs.
 
Is this answer useful? Yes | No

 Related Questions

Can a sequential file stage can read the path from other sequential file. in which the data is stored

How to call a Stored procedure which is in SQL Server database in Datastage job? I want to pass job parameters as one of the SP parameters and for remaining SP parameters , I want to use default values. Also I want to perform transformation on the result set of SP.
Read Answers (1) | Asked by : udaykiran

What is call hash size more 2GB?This example is exceed 2 Gb yes or no?-rw-rw-r-- 1 s000656 dstage 2154491904 Jul 26 08:27 DATA.30-rw-rw-r-- 1 s000656 dstage 514490368 Jul 25 20:25 OVER.30
Read Answers (1) | Asked by : Ra

Latest Answer : There is a stage named Stored Procedure available in Datastage palette under Database category. You can use that stage to call your procedure in Datastage jobs. ...
Read Answers (1) | Asked by : suganya

View Question | Asked by : sachin tilloo

Latest Answer : In what database is the stored procedure located. If it is Oracle stored procedure, you can use "stored procedure stage" in DataStage 7.5.Hope this helps. Srinivas ...

How to call a Stored procedure which is in SQL Server database in Datastage job?  
Latest Answer : You can use strored procedure stage in DS to call the any stored procedures from any Database type.Regards,Veeru. ...


 Sponsored Links

 
Related Articles

What are the differences between stored procedures and triggers?

Stored procedures are compiled collection of programs or SQL statements that live in the database. A stored procedure can access and modify data present in many tables. Also a stored procedure is not associated with any particular database object. But triggers are event-driven special procedures whi
 

How does the function call within function get evaluated?

Whenever we have more than one function which is called for a finite number of times then such a function gets evaluated from inside out. Let us understand this concept with an example. For instance consider a function sample called within it 4 times as given in program below: main() { int a=50;
 

How to call C header that is not provided generally by system in C++?

Headers can be called by using extern C Syntax of extern C is: extern "C" <function declaration> for example to call C functions from C++ we can write extern "C" { <function declaration> <function declaration> ...
 

What is difference between call by value and call by reference in function?

The arguments passed to function can be of two types 1. Values passed 2. Address passed The first type refers to call by value and the second type refers to call by reference. For instance consider program1 main() { int x=50, y=70; interchange(x,y); printf(“x=%d y=%d”,x,
 

XML Remote Calling Procedure

XML Remote Calling Procedure XML RPC or the XML Remote Calling Procedure is a set of compilations and implementations which allow certain programs to run on complex platforms or operating systems and allows them to make Remote Procedure calls on the Internet The Remote Procedure Calling Protocol use
 

Procedure for getting Scholarships

Procedure for getting Scholarships If you have done a bit of research you are probably well aware of the fact that there is a great deal of money available for scholarships Having said that it is sad to see that so many students graduate from college with lots of students loans when they could have
 

How Data Is Stored Within a Data Warehouse

How Data Is Stored Within a Data Warehouse The data that is stored in the data warehouse is just as important as the data warehouse itself Having a fundamental understanding of how this data is stored can be useful in the successful implementation and utilization of a data warehouse One term that yo
 

Call by Value and Call by Reference

Call by Value and Call by Reference In this tutorial you will learn about C Programming What is difference between call by value and call by reference in function mosgoogle The arguments passed to function can be of two types namely 1 Values passed 2 Address passed The first type refers to call by
 

SQL Server Stored Procedures

In this tutorial you will learn further more about Access and Manipulate SQL Server data Using Stored Procedures Creating a Stored Procedure Running Stored Procedures from NET Using Parameters in Stored Procedures The IDENTITY Variable Access and Manipulate SQL Server data Using Stored Procedures mo
 

Live DataStage Interview Questions

Thanks to our site visitor Manoj for sending these DataStage Interview Questions You can find the updated questions here Live DataStage Interview Questions Published by Manoj G on 05 24 2005 Thanks to our site visitor Manoj for sending these DataStage Interview Questions You can find the updated que
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape