DSXchange

First of all never attach to the current running job. It will always hang. Second you should not be able to get run times of multiple instance jobs this way. You need to attach to each one separately. This code: Invocation_Id = DSGetJobInfo(JobHandle,DSJ.JOBINVOCATIONID) Should return a mult...

REPLACE is similar to CHANGE or EREPLACE.

The second option is basically the same as the first except you need to run a job to extract parameter values from a table into a hash file before you run any jobs. In each of these you need to get a list of parameter names from the job and then set them if they are in your sequential file or hash f...

You need to pipe to

cut -d"=" -f2

Most people use a sequential file because it is easy to edit. They use syntax like: PARAM_NAME = VALUE They process this with a batch job using openseq. I have seen Oracle and Access also used as sources. These were dumped into hash files using a job. Hash file key was the parameter name. So it was ...

Ray posted a real nice routine to do exactly this. You might want to search for it.

Ray's method is very easy to program. If you openpath to the directory where the file is located. Read the whole file in one record then just change then record you want and write it back. SeqFilePath = "./MySeqFiles" FileName = "MySeq.txt" openpath to SeqFileDir else stop read R...

The DS_JOBS table has categories in it as well as jobs. They start with "\". So to not count them you need to do what Ray posted or something similar. I prefer UNLIKE "\...". This is just Ray's style.

Try HELP at the > prompt. I would do this from a telnet or ssh connection versus Administrator Window. It maybe easier.

There are some really good posts on this topic. Try to search for them. DS.TOOLS is a menu that will do a lot of the work for you. Try it.

TO learn what these fields are you need to run the SQL and compare it to the Director. If you cannot figure out the rest of the columns then you do not understand Director. You are going to have to do some of the work here to educate yourself. We will help on complex things or unusual things like wa...

Sorry I asked. This gets uglier as it goes. I understand the concept. Is this RCD type 42 or SCD type 42. When it gets to 42 it is the answer to all our problems. Right?

There are 2 versions of ech field. Agreed it is ugly but type 3.

This is type 3 isn't it?

Ray man is too tired to say apathy serks.

We had a similar problem. We wrote a job to copy one table. We exported it. We also imported all the tables. Ray posted code along time ago to read DS_METADATA. I used this code to change the DSX to a different table. I hear that ProfileStage can do this. I have never seen it work though. It is a pr...