DSXchange

there are several routines supplied with DataStage. I remember that we have to check some of them before found the appropriate. Any other solution that checks the data in your target file! Good luck, Kasia At 04:26 26/11/2002, you wrote: >To all, > >This is the first time im converting cobol files t...

Hi, How to run the 2 or 3 jobs simultaneously By using DataStage5.2.Any help will be appreciated Thanks Prasad ************************************************************************** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain ma...

To all,

This is the first time im converting cobol files to text files.
If someone could please "walk" me thru the steps to make sure that
the files are loaded and converted correctly.

thanks in advance

The short answer is yes. DataStage processes a stored procedure and a table query in the same way; the CALL or SELECT statement is sent to the database server to be prepared and executed, and the database server generates a result set. DataStage then requests a row at a time from this result set, wh...

The plot thickens, apparently the stored procedures serve a lookup type of function. They accept parameter(s), do some processing and some i/o and return a set of values. I would not need to source from the procedure per se, but use them in the processing flow. Does datastage support this? thanks in...

This is a topic for an orphaned message.

Hello If you are unwilling to use the aggregator stage to group your data together, maybe you should write your own transformation. The design here is to read your sequential file and output to a hash file. Your transformer stage has a lookup from the same hash file. Your transformer rule looks some...

Short answer is yes. The ODBC stage supports Stored Procedures but we dont use ODBC here, so I dont have much to add on that topic. We have had success with calling stored functions via custom sql in the OCI stage. So Im curious as well how people who have made extensive use of stored procedures hav...

A quick question for datastage experts; is datastage able to call an oracle
stored procedure and handle returned values from that procedure?
In other words: can i source from an oracle stored procedure?

inquiring minds want to know,
thanks in advance,
Peter Jansens.

Jennifer, You can come out of the first transformer into a sequential file stage with the named-pipe option, then from then named-pipe into the second seq file transform with the delimiter defined as tab (009), and you have your fields separated. It beats doing a field(inval,tab,nn) on each derivati...

This is a topic for an orphaned message.

How do I split the file in the second transformer into multiple fields based on a delimiter? My file is tab delimited. Thanks. Jennifer J. Weise Milton S. Hershey Medical Center (717) 531-6954 *****E-Mail Confidentiality Notice***** This message (including any attachments) contains information inten...

The environment of a datastage job is NOT the users environment. To check this, put an env statement in your script, you will see that the environment is not yours. To fix this, you must put ALL environment settings you need into the dsenv file (DataStage environment file). This file is sourced when...

This is a topic for an orphaned message.

Hi, Thanks for everyone for your suggestions for my previous issues. I am trying to run a shell as Before job routine (ExecSH). This shell script runs syncsort on unix server. This program runs successfully from the command prompt. But when I execute same script from datastage, I am getting followin...