DSXchange

Sometimes you can import part of a job. When you pull it up in Designer it says no design time information. There is nothing that says you can save any of these jobs. You can just try to save them.

Most of the time a corrupt project can be fixed with DS.TOOLS. If you can export jobs then the project is not that bad. I would try to fix it by reindexing. UVFIXFILE can fix DS_JOBS or DS_JOBOBJECTS. The jobs you export may be worthless. You can export a job that is broken and will not import. You ...

Sure. You can point a hash file to another account. An account is the same as another project as far as you are concerned. So store the hashed file in one project and point to it from the other project.

There are several other ways using SETFILE and q-pointers if you want to search for those.

If you do an exact search on chmod you will find several posts on how to fix this. The most complete is http://www.dsxchange.com/viewtopic.php? ... hgrp+chmod

There are only a small percentage of users who have singed up. It still does not pay for the full time webmaster. So in no way are they getting rich off this site. If they lowered the cost I doubt if any more people will sign up. There are people willing to pay to advance their careers and others do...

The hierarchy is not described in DataStage. It is described in your sources and your targets. In other words show us your source to target mappings then you can probably build the ELT. If not then we might be able to help.

I am not sure you can directly because ssh needs to return it to DataStage. Just try it and let us know. ExecSH has a return value. You can also use execute ... capturing ... returning ...

I would search for these.

You have to download it from one of the 2 links below my signature.

Not sure it works with PX jobs. Never tried it.

If you have not cleared the log then there is a job within EtlStats which will retrieve this from the log file.

I think your second run was with a different user. If you are on UNIX then the permissions need to be set so all users running jobs are in the same default UNIX group. Next each user needs to have write permission to the whole project directory. Also each user needs to overwrite another user's files...

If you still need help then let us know.

You can write your own with Index(). Index() will find any string within another string. It returns the position of where it found it. It is fairly fast because of how it works under the covers. Index() will look for the 3rd or 4th occurance of the string. So you will need to find the position of th...

You are in a catch 22 problem. It appears your process does not have write permission to the RT_LOGnnn. So it cannot log the error.

They sort of switched it. You need to use routine arguments to return values in a sequence. Newer versions allow you to use argment values as parameter values in 7.5 and above.