DSXchange

I am new to datastage. i have a task of loading data from an ODBC stage in which i have to run a Stored Procedure and then get the output in XML format..


please help me out for this task.

do i need to use a transformer stage for this task ?

Welcome. :D

Unfortunately, it sounds like someone has thrown you into the deep end of the pool with no life preserver. Understand that we're not really here to be a substitute for proper training and your questions are very broad. Are you working with anyone that can tutor you on the basics of DataStage? How familiar are you with XML in general? Do you have an xsd for your target XML file?

You'll find in a Server job that you use the Transformer for pretty much everything. Your job would look something like this:

ODBC -> Transformer -> XML Output

-or-

STP -> Transformer -> XML Output

Depending on your database, you may be able to use the Stored Procedure stage rather than ODBC directly. Of course, there is *way* more to it than that. Is your ODBC DSN configured? Has the metadata for the SP been imported? Metadata created from xsd? Can you see why it is critical that you have someone there locally to provide guidance for you?

We can help with specific questions or problems, but as noted aren't here as a substitute for training. Each of us are volunteers that post in our 'spare' time and have our own work to perform during the day.

Hope that all helps and at least gets you a foundation.

I second Craig's observation.

Your location suggests that you are working for one of the world's largest suppliers of consultants. Get them to enrol you in a training class.