DSXchange

I think it's not possible because the syntax editor in the transformer derivation won't accept something that looks like <parameter name>(....), which, I think, is what is being asked - i.e. to have the actual function to be called be a parameter.

Just what I needed. Thanks.

Does anyone know of a way to access the multiple job compile process from a script running on a client windows machine? I looked in istool, searched this site and the IBM documentation and haven't found anything. Ideally, we would be able to write a script to run on the Designer client machine that ...

D'oh. Mea culpa - problem was changing the input link metadata without updating the reject link - previous input had nullable columns but new link did not, so all the columns on the reject remained nullable until I deleted and re-added the stage. Then it got the new metadata.

yes - it is, but we could put something in between or use some other stage if it would help resolve this issue - we need to have rejects end up somewhere where we can look at them.

We have jobs running fine with ~~50 record formats in a CFF stage, so for sure 8 is not a limit. (V8.1) I have had the problem in the Designer client with record layouts failing to add, especially if you try to do several in succession, or delete some records then add. When I encountered this, I dis...

Yes, that is the case for SF stages. Sorry I wasn't clear, these rejects are on transformer stages.

Do you have any suggestions on how to handle nullable columns when the sequential file is a reject link? In that case, you don't have the option to handle nulls when you edit the row for the column. We have a large number of jobs with this situation, and a large number of columns in most of the rela...

Thanks for the comments. I'll be sure to look into those alternatives. Still being relatively new to DS I had not yet discovered the job monitoring/control facilities.

I have a situation where a source system is going to generate a number of files (max 200) each of which will be input to a DS sequence job which will produce an output file. After all these jobs run, we need to initiate another non-DS process that will use the resulting files as input. We're running...

In transformer stage, have code to set a stage variable to the location of a string in another string using index function. Search argument consists of hard coded value concatenated to an input column, i.e. 'ABC':<input column>. The problem is that in certain cases, a value of all spaces is a valid...

In transformer stage, have code to set a stage variable to the location of a string in another string using index function. Search argument consists of hard coded value concatenated to an input column, i.e. 'ABC':<input column>. The problem is that in certain cases, a value of all spaces is a valid ...