In the mean time I have completed your suggested solution and have a new transformation that allows the user to set the option for UNIQUEINDEX.   And - while I was at it - also modified the "List Cluster Content" transformation to include the "/VERBOSE" and "OUT=" option (as described in "Querying and Reading Member Tables in a Dynamic Cluster". This opposed to the included version that uses the content of the macro variable SPDSLIST to generate a list of members, does not allow the inclusion of the values for the variables that are included in the MINMAXVARLIST and does not have an actual output table in the transformation. ... View more

That was my plan B    I was hoping that I had missed something in the transformation. ... View more

Not sure if I fully understand your comment. But my understanding is that this option is defined at cluster level during the creation of the cluster.   As described in the SPD Server SQL Cluster Operations for the cluster creation: After you have organized the SPD Server tables, issue a PROC SPDO command to bind the tables into a dynamic cluster table. The general form for the PROC SPDO cluster create command is as follows: CLUSTER CREATE <cluster-tablename> MEM|MEMBER=<membername> MAXSLOT=<max-slot-num-spec> UNIQUEINDEX=YES|NO DELETE=YES|NO; The CLUSTER CREATE command options are as follows: UNIQUEINDEX=YES|NO validates a unique index. The default setting is YES. DELETE=YES|NO permanently deletes the cluster and its members. The default setting is NO.   The indicated transformation, as far as I can see, generates code for the following part of the code: CLUSTER CREATE <cluster-tablename> MEM|MEMBER=<membername> MAXSLOT=<max-slot-num-spec>;   However there are no possibilities - what I can see - to add/alter either the UNIQUEINDEX or DELETE option   EDIT:  For reference (from the SPD Server 4.4 Administration Guide): "The CLUSTER CREATE command in PROC SPDO has a new option that allows the user to specify whether unique indexes that are defined in the member tables should be validated and marked as unique in the cluster. If the UNIQUEINDEX option is set to No, then unique indexes are not validated, and the cluster metadata does not mark the indexes as unique within the cluster. If the UNIQUEINDEX option is not specified, then it defaults to YES and the indexes are validated and marked unique within the cluster." We do not require this validation and as such would like to set the option to NO.   ... View more

Hi Jan, In your last post you indicated:   jklaverstijn wrote: I am now consider addressing the issue at SGF in the Quad. And in that case we'll have plenty of opportunity to dicsuss the outcome. Out of curiosity (although I know what this did to the cat) .... Did you find time to address this at SGF? And if so, any news on this item? ... View more

Hi, At our company we have created an open-source tool called EOM Job Monitor (you can find a brief explanation on/demonstration of this tool here).   The information about the job flows and the jobs that are shown in the tool is retrieved from the metadata and can give real time progress on running flows plus information on completion, warnings and errors found. There are some prerequisites for the tool to work.   Bottomline is that this information can be retrieved from the metadata. ... View more

Hi ja karman, The fact that there may be more background within a project you are working on may very well be the case. However your information is only taking this thread off-topic. Your technical and/or functional requirements may be different to what the feature provides but that is a topic for discussion inside your project. This thread is about a feature currently available.   IMHO the question as stated by the OP is simple: There is seemingly a new feature in the SMC for the batch server and it is not working for him. All the OP is interested in (and so am I) is how to get this feature working or, if misinterpreted, what is the actual meaning of the new feature.     ... View more

Hi ja karman, Regardless of the fact whether what you state is relevant or not I fail to see the relation of your reply to the question of the OP.   IMHO the OP indicates that the new option that is currently available for the batch server, that is to redirect output (.lst files) to a location of your own choosing, does not seem to live up to expectations. Basically the OP would like to know if he is overlooking something causing it not to work for him.   I have seen the same option and also for me it is not working yet. So if anyone has find the solution I am also curious to hear it.   😉   ... View more