DSXchange

The Parent list will be your reference lookup, the Child list will be your source data. Inside the transform drag the PIDCID field onto the parent PID field. Modify this field to read "Left(PIDCID, 3)" to ensure you only match the first three characters. Now drag across the required output...

The merge stage will probably not work because you do not have a key that joins rows from the two files. Your join criteria appears to be the row number, ie join row 1 to 1, row 2 to 2 etc. The join criteria in a merge stage is quite restrictive and it will not let you put row number in as a key. It...

You can do this from a Routine called from a Batch or Sequence job. The OpenSeq statement opens a sequential file, Writeseq outputs a row to the file. Page 13-24 of the Server Developers manual contains the commands for Sequential File Processing. Here is an example from the manual, you just need to...

Here is an example using a GoSub and a label called GetInfo: ErrCode = DSRunJob(hJob3, DSJ.RUNNORMAL) ErrCode = DSWaitForJob(hJob3) Handle = hJob3 gosub GetInfo ... ************************************************* * Function that returns information about the job ***********************************...

DataStage Basic has a sleep command "Sleep [Seconds]". You may find it easier to write a Batch job that runs in a loop with a sleep of up to 15 minutes that runs the jobs that need to be run on a frequent schedule. This batch job can ensure aborted jobs are reset and can send emails when a...

You can call an external application from any part of DataStage that supports DataStage Basic using the DSExecute command. DSExecute has a "shelltype" parameter which is set to "Unix" for Unix commands residing on the DataStage server or "NT" for an NT server. The comma...

Try the validate and run again. Go to your project directory and move to the &PH& directory with the command cd '&PH&'. Find the last log file in this directory and look at the contents. Sometimes an error appears in this log file that does not appear in the Director. This directory ...

Put an output link in each of your transforms that leads to a flat reject file and make these all reject links at the transform constraints screen. You now have a couple of options: - you can either set your warning limit on the job to 1 so the job aborts as soon as a row is rejected by any transfor...

There are a couple things that cause this type of error. First off does the batch pass the file name or path to the job? If these parameters are incorrect the job could try to open a file that is not there. Secondly does the batch run under a different login? This could cause a file read permission ...

One method is to have a centralised logging routine which is called up at the end of each job, the routine is passed the handle of the job, it uses this handle to attach the job and retrieve the information about the last run of that job. It then logs into a database and writes the information to a ...

Thanks for the reply "datastage", I've tried to find something other than the SQL but there are no before job routines, there are no delete or truncate commands in the job and there are no other jobs running. The job is simple with just three stages. An OracleOCI select, a transform, and a...

What are the commands you are referring to? ... there are administrative type commands that can analyze the hash files then you can set the minimum modulus settings for these files which will result in higher performance. I have used the Hash File Calculator under the HFC directory on the 5.1 CD to ...

I have a problem where an Oracle OCI select statement is taking far too long when executed from a DataStage job. We have a job that performs a simple select from a table based on a date: SELECT {list of fields} FROM wp_caption WHERE last_update_date = TO_DATE('13/02/2002', 'DD/MM/YYYY') The problem ...

It's a great tool and it's saving me a lot of time. One problem I am having is that it is not showing the categories, it's just showing a list of jobs from all categories in alphabetical order. Am I using the wrong version or should I add this to a wishlist?

Try putting your code into a routine, call this routine from within the Job Sequence with the RoutineActivity stage and pass it the name of the job you are trying to access. Both the input and output variables for the routine will be available to subsequent linked stages in the job sequence. The rou...