DSXchange

Hi Sri,

it depends how you fill it.

IF FIELD="Y" THEN "Y" ELSE IF FIELD="N" THEN "N" ELSE FIELD

so you have y or n or a previous.

Querido Manuel! It is not you English what is not understandable. If you work in a BI and DWH environment you should at least work with a 3 or more Tier architecture. The first TIER for the saving of Data without any formula, only flat, flat data. The second TIER for selection and calculation (!!! h...

I don't understand what you want to do finally. But it seems to me, that you have not yet thought about the advantages and sense of each tool. Maybe, that when you tell why you want to do something we might show you the best way to do it.

choose "user defined" and past your query in!

If you use a dynamic hash file (default) the rows per second decrease and later increase, that is normal due to administration tasks. Look at the total performance. If you are happy leave it so. If not check the manual and use static hash file.

You have to read the help-file on how to use iconv and oconv. The first "D" means date, the second day and so on. If you use first the right string-operations before converting it will run. Check it you have correct dates, 30th February does not exist for example. Check for null-values. An...

The original difference (up to Version 3.0) was very important. Those Times a routine could not be used directly but hat to be wrapped into a Transform. Nowadays this use makes no difference. A Routine is more easy to handle. A Transform is a bit quicker. If you change a Routine and compile it it wi...

(1) Use Auto-Purge to delete the log-files after up to 2 or 3 runs

(2) Are you on windows or are you on unix?

Once upon the times when DataStage was without versioning we have written a tool that does it as export, import, compile and delete it is called "dsmove" and was not yet checked for version 8.x but it works for us in many projects since Version 3.1 until 7.5.2 Parallel and Server.

does a job without any parameters work correctly in UNIX. If not the reason might be else.

That is a question of how UNIX give the data to DataStage.

Best might be you pass "'a*b*c' and substitute within DataStage the star with a blank.

question back:

why do you want to install one and the same version of DataStage twice?

check the right on this directory and file. Maybe that DataStage has no right to write into that file.

The User you open datastage with and the user which is used in DataStage might not be the same.

Ask your operating System collegues (UNIX/WINDOW...) for help.

there a different types of META-Data in Datastage. What you seem to be interested in are the processing informations as you find them for example in the logfile. These data are erased by the time. The best is to harvest them after each job run an write those you are interested in directly into you o...

When the Job starts it has to have all parameters already set and you cannot use the Jobs own Job Controller as Job Parameter. You can read it in any routine but a parameter can never be changed itself. What you can do is: Use a 2nd Job and read the 1st Job's Job Controller and start in the 2nd Job ...