GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  DataStage
Go To First  |  Previous Question  |  Next Question 
 DataStage  |  Question 67 of 140    Print  
how to call the stored procedure in datastage??

  
Total Answers and Comments: 1 Last Update: January 31, 2008     Asked by: sandy123123 
  
 Sponsored Links

 
 Best Rated Answer
—

No best answer available. Please pick the good answer available or submit your answer.
January 31, 2008 16:03:40   #1  
csri2006 Member Since: January 2008   Contribution: 2    
RE: how to call the stored procedure in datastage??

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


 
Is this answer useful? Yes | No

 Related Questions

Hi ,in my pc i am unable to login to the Ascential datastage 7.1. whatever the hostname i am specifying... i m getting the error statement as/...Failed to connect to host: project:UV (The specified hostname is not valid, or the host is not responding(81011)n when i explored the online documentation file....the reason is given as.......follows....When defining a connection to a remote Uni Verse database, a new uvodbc.config entry is added...It\'s important that the lastline (host=name) is terminated
Read Answers (6) | Asked by : Madhavi
Hi ,in my pc i am unable to login to the Ascential datastage 7.1. whatever the hostname i am specifying... i m getting the error statement as/...Failed to connect to host: project:UV (The specified hostname is not valid, or the host is not responding(81011)n when i explored the online documentation file....the reason is given as.......follows....When defining a connection to a remote Uni Verse database, a new uvodbc.config entry is added...It\'s important that the lastline (host=name) is terminated
We have the Datastage server7.5 installed on Unix machine. We need to have a DSN to connect to the database which is on some other unix machine.please let me know it is enough if we create a DSN at the client machine or do we have to change the config file in UNIX?It is very urgent for us and we are not able to solve?pls help me in this regard.Madhavi
Read Answers (1) | Asked by : Madhavi
Latest Answer : To handle the error handling you can use the reject link option available in the transformer stage. ...
Read Answers (1) | Asked by : Amar
Latest Answer : Parallel extender is that the parallel processing of data extraction and transformation application . there are two types of parallel processing 1) pipeline parallelism 2) partition parallelism. ...
Read Answers (2) | Asked by : Deepak Prasad
View Question | Asked by : saritha.ppr
If a DataStage job has aborted after say 1000 records, how to continue the load from 1000th record after fixing the error?
Read Answers (6) | Asked by : etl
Latest Answer : two links avilable in datastage 1.primary link 2. reference linkprimary link means:strightly forwarded standard line ________________reference link means:horizentling table------------------------------> ...
Can a sequential file stage can read the path from other sequential file. in which the data is stored
I am new to DataStage can we need to load a excel file which has both ARABIC and ENGLISH text. Here my source id IBM DB2. If I want to display the Arabic content in my browser I need to store it in the UNICODE format in the Database. Can any one tell how to store the content in a excel file as UNICODE NLS . In DataStage the option has been provided only for Sequential files.Thanks in advance.Regards,Kris.

 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