DSXchange

Select a column by what?

From source or as a reference ?

If it is from source, you have to look at the link information.

If it is from reference, you are looking for a lookup stage.

Did you try recompiling the sequence or copying and running the copy.

What about the parameter values ?
Does the run start giving rows before aborting ?
Did you check that you have permission to access all objects required in the job ?

Try "left outer" join.

Depending on its performance you can tune it better.

Your source field description file can be used in place of copy files. Can you paste few lines from it so we can confirm.

Record delimiter and other properties are optional. So more information about the data file - such as fixed width, header & trailer etc may give your more useful answers.

Try index()

It was DS 7.5.1 which required a patch.

Remember seeing exactly (almost) similar post few days ago.

Did you search ?

It varies based on Unix flavour and version. Generally it is 255.

Have faced similar issue before.

Try doing "vi fileName" with full path.

You have options to choose from - something like

1.) using external script like awk
2.) crossing with a dummy row generator and to extract individual values
3.) build op

Before processing a file, move it to an intermediate folder and work from there. This will avoid another instance / process reusing it.

Can't you create a new instance for each file ?

If you want to run fixed max number of instances, you can take n files at a time and branch through links in sequencer each calling the job with appropriate invocation id or a dummy link each connecting into a sequence object with ALL.

To put it short, in V7, version control is similar to another project where you can have copies of job.

The maintenance is done internally and have some good features such as to baseline.

Look for 'Version Manager'.

I think it is a separate add-on component and not free.

Check your job log for run timings and check whether there is any overlap.

Also check the datetime in the dataset files.

You can use orchadmin on datasets

The logic is fine.

What is the question ?

What have you tried ?