DSXchange

Yes, I also have never seen the UNLOCK command hang like this. Are you specifying the keyword "ALL" in upper case?

You are entitled to your opinion.

I, on the other hand, rejoice in having a sense of humour.

My preference would be one Transformer stage.

It is precisely my meaning, and my post is totally off topic. I added <pedantic> tags to try to indicate that this is the case.

Not true in this case because all the RT_xxxnnn hashed files share common file dictionaries. Because the dictionary name does not correspond to the VOC entry name, the VOC entry is not deleted, instead the data file pathname (field #2) is set to nothing, as per the message. These entries will serve ...

ag_ram wrote:

ray.wurlod wrote:<pedantic>
You can't bifurcate into four.
</pedantic>

Could you please let me stay in the meaning of your words here?

The "bi" in "bifurcate" means "two".

Reading as a single column is an excellent approach. Investigate using a Column Import stage to parse the record - it may be more efficient than multiple Field() functions in a Transformer stage. Also investigate using a Schema File with a Sequential File stage, rather than explicitly defined column...

That shows that there are four clients attached to the project, of which three are defunct processes (have no process ID).

You should be able safely to execute UNLOCK userno ALL command for the three user numbers (other than 62928) that do not have process IDs.

Does your COBOL FD include information about the location of the null indicator? This is usually the first or last byte of a field, or may be a separate one-character field.

The "#" characters may be interfering. DataStage may be trying to effect job parameter substitution.

Recompiling the job should reset the wave number.

Not quite. The definition records in VOC should be deleted, not set to nothing, if the deletion is to be counted as successful.

<pedantic>
You can't bifurcate into four.
</pedantic>

How would you want to display 12-06-1008 or 12-06-3008 ?

I suggest you have not thought thoroughly through your requirement.