DSXchange

Why not extract file 2 into file 1, adding the extra column. Then you can process the full file. OR Process the data in 2 ETL jobs run in sequence. OR Create a job for file 1 with the required transformations and outputs. Convert everything after the input stage into a share container. Create a seco...

Try http://www.datastagexchange.com/compileall.php

Should be version 6.0 compatible.


Vincent McBurney
Data Integration Services
www.intramatix.com

devaraj4u, strongly recommend you get some training from Ray. If you are not in Mumbai then get in your car and start driving! Your process of loading a star schema will benefit greatly from DataStage Best Practices which Ray knows a thing or two about. Vincent McBurney Data Integration Services www...

Write a script on the DataStage server that does an rsh into the Europe server and deletes the file. Call this script in an after job routine. You could also write a before job script that does an rsh to the Europe server, compresses the source file, ftps it and uncompresses it on the DataStage serv...

You need to import your table definitions for source and destination tables into the DataStage repositry using the Manager. This will speed up the process of creating the DataStage jobs. It is best to do one job per table as it makes the management and debugging easier. You mention 16 sources and 19...

Write a simple server job that retrieves the date from the Database and writes it to a text file. Write a routine that opens the text file and reads the date and returns this date to the calling job. In your first Sequential job run the server job that saves the date to a text file, run the routine ...

Whoops, Ray beat me to it. Answered the question while I was still typing.

Vincent McBurney
Data Integration Services
www.intramatix.com

Ardent owned DataStage, they were bought by Informix, IBM then bought the Informix database products, the remaining half of the company became a new company called Ascential. Ascential now focus on data integration. Ray could probably even tell you who owned DataStage before Ardent! Why are you tryi...

Had a quick look for some sample code for you, have a look in DataStage Manager under Routines/SDK/Utility. The UtilityHashLookup shows you how to open a hash file and retrieve a value in a routine. UtilityRunJob shows you how to retrieve parameter values and run a job. You can use this sample code ...

It is a common practice to write a routine from which you call up all your DataStage server jobs. This routine retrieves the parameters for that job from a hash file, database table or text file using the various open file or open table commands available in Universe basic. This lets you set your pa...

You can download it at any time if you join up at http://www.datastagexchange.com/ which is another DCS site. Go to the downloads page.

regards
Vincent

I believe DataStage 5 and 6 will not run on Sun Solaris 2.6. You will need to upgrade that server to 2.7 or 2.8 if you want it to remain a DataStage server. There is an unsupported workaround where you install a 2.7 component onto your 2.6 server to get DataStage working but it's safer to upgrade. Y...

Hey easwaran, I'm still a bit confused but I'll give it a go. Firstly, you can have as many hash file lookups as you want in a single transform. They can all use different keys. In your transform you'll see each hash file on the left hand side of the diagram, just drag your fields from your input fi...

There have been lengthy discussions in forums about changing job parameters with the conclusion that it cannot be done. A job parameter is set prior to the job being executed and once that job is running the parameter cannot be changed. If you need to programmatically set a job parameter in a Sequen...

Or you could buy your own Sun Solaris server!