DSXchange

this works on ours as a routine -- *.* style wildcards work just fine... I don't know how much it needs to change for windows. Could be an OS problem though.. maybe unix allows *.ds and windows did not? deffun GetEnvVariable(Arg1) calling "DSU.GetEnvVariable" Ans="" PlatForm='UNI...

it should not be from scratch. what you have should work with only minor adaptation, and once it works, adding the write to log messages isnt too bad (but if you need help, ask). this link is a huge help: https://www.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.ds.serverjob.dev.d...

whatever is printed to the console is brought back by execute command BUT I don't know if that is only done at the end of execution or if it picks it up midstream. Is there any reason you can't put the basic into a routine (which CAN write directly to the logs easily) and call that in a routine acti...

We had this problem as well, and while we half-solved it by putting the CA workload on its own server, I ended up making a C++ routine that did pretty much the same thing and was able to do the analysis as fast as the database could be read, piped thru a quality stage job that did the statistics on ...

Not yet. I wanted to make sure its not just me not knowing where to click.
sigh. Their support ... leaves a lot to be desired. Just getting them to admit there is a problem to bother with fixing is a good month of frustration.

I gave up and made 2 connectors for now, with some smoke and mirrors on the deletion side to determine if it is enabled or not. But I would still love to understand if this is a bug or something I don't fully know how to use.

I think I did that. Inside the MQ connector, there is a button-column with 3 red arrows on the button. I used that and picked 'create new' which build a pre-generated list-parameter and added it to the job parameters. I set the default to 'keep' and its all there, but it will not compile.

I have a MQ job that I want to control whether it keeps or deletes the messages on the queue via a parameter. I have clicked in the parameter and selected create new, and it happily populated the field with the parameter and put the new param in the job params with a default and all seems good... ex...

are they all of the same format, like A operator B operator C?

you can do something snarky like make the key A*B (200*300 is the same as 300*200) or sort the 2 keys (stage variables can do this for 2 values really simple) and put them in the same order every time (so that 200,300 is 200,300 no matter how they came into the functions). Multiply has a risk of oth...

for fixed positions, left and right should do it. you can string these together eg
f1 = left(in, 12)
f2 = left(right(in,12),12)
etc

Feed it to a transformer.

In the transformer, have two output links. On one of the links, have a constraint send the data down if the column value is NULL. Also set the the link properties to abort after one row.

is the data really big? If not, can you copy the input and then do a join stage? I think that might work, what you wold do is something like read file copy stage modify left, add party1 as new field 'key' modify right, add party2 as new field 'key' join stage, on key if the data is too big for this,...

can you rig some sort of having clause into your lookup query so that if it has more than 1 it returns nothing?

I use it all the time. Its kinda like a dataset: if you have an input, you can't have an output, and if you have an output, you can't have an input. Its either the start or the end of a chain of work, in other words. to use the stage you have to click to get the java or whatever it is external gui f...