DSXchange

I and one other person have admin privs on the server (end a process via Task Manager) but we do have an local admin account that our Development team have access to to use Administrator to unlock processes. All of these can cause this. Why are you doing these things on a regular basis? These shoul...

You cannot grant permission to a user. These users all need their default group to be the same group like dsdev. This group usually is the same as dsadm.

If you try to keep multiple groups then it will always be a manual process.

You would need to do something like run out of disk space or kill a process with a kill -9 pid or some other situation which DataStage cannot recover from.

Pal

Sorry but I think Ken has the best solution. Ascential has to sell against these products. They have comparison sheets.

You will either have to remove the carriage returns or run uv and run it it at the prompt. If you run it at the uv prompt then run:



Then just paste it in.

You need to change :1 into your category but here is the query. select EVAL DS_JOBOBJECTS."@RECORD<6>" AS FILE_NAME FMT '35L', DS_JOBS.NAME AS JOB_NAME FMT '35L', DS_JOBOBJECTS.NAME AS LINK_NAME FMT '35L' from DS_JOBOBJECTS, DS_JOBS where DS_JOBOBJECTS.OLETYPE in ('CHashedOutput','CHas...

You can easily run these outside of DataStage by writing shell scripts. DataStage can generate the control files needed for any of these. If you think they are slower then update a flat file and then run a shell script to bulk load. Let us know the results. I would like to know which is slower and b...

It is easier to upgrade in place. DataStage can upgrade the project and the jobs. It will also leave your VOC alone so all your hash files will be there. It seems to be very safe way to upgrade. Otherwise you will need to upgrade to a clean account and then try to create the hash files and/or copy t...

This forum is designed to help you use DataStage. Your questions are more towards comparing DataStage to other products. Ascential sales people do these types of comparisions. Some of the developers have used other products and can help you transition to DataStage if that is what you want. I think m...

The second is in the System32 directory. I could not find the first.

When you are in job control in the job properties then there is a drop down list of all the jobs. Select the job you want to run and press the add job button. It will add all the code needed. Instead of the default values then it will be the batch job's parameter name or any variable name. Here is a...

In a batch job a parameter has a varaible of the same name. So if I have a parameter named FilePath then you can read the value by using FilePath like any other variable.

If that is true then you need to be in the project directory before running the uv command.

I consider methodologies and best practices as reusable. If you develop sequences the same way every time and with the same parameter names this helps speed up development and keep jobs consistent. Job templates can also standardize methods. Using standard jobs to gather ETL stats and process errors...

I wrote some SQL to do it in doc_tool.mdb the Access database updated with Reporting Assistant. If you want that code then I could look it up. I think it has been posted in the past but if you cannot find it then I will post it again. It would take several queries to get all the differences. Most of...