DSXchange

I have been using 'otherwise' to capture the records that don't meet the criteria in a transformer for so many years. Just today found out that some records that should meet the requirement are being captured by 'otherwise' link on a Transformer. I displayed every single criteria in the output files...

The second poster is correct. Index won't work.. I am trying to avoid 10 different if statements with 9999 different indentations

Is there a way to figure out if a field is equal to a value in a set using transformer constraints? What I am trying to do is to avoid doing Link.Field = 1 or Link.Field = 2 or Link.Field = 3 but write something like Link.field in (1,2,3) I couldn't find a way to do this in the constraints pull down...

We have 8.1.

I have this simple text file that i converted both to LookupFileStage and DataSet so that i can use them as reference in Lookup stage. In both cases i am having hard time getting them to work with similar reasons. (I think) When I generate the lookup file set and dataset I make sure that the field i...

How long does it take after one pays for the membership? I need to read some replies from Ray so that i can finish things up in this project that i am working. Should I tell client i will get a delay because 'I cannot talk to Ray'

I am getting the following error when i try to test the connection on TD connector. It sound like either an installation issue or a bug but i wanted to ask if everyone has got similar problems before. IBM 's tech support knows the problem but i though i might get a faster response from here. (It usu...

I remember using a UNIX command to release jobs being hung by the Datastage Designer but I cannot find it in my notes.. Can anyone send me the command?

Thanks,

Baha

Anytime i am trying to delete a job from repository on 8.1 client the designer hangs. Has anyone experienced similar issues. I am trying to determine if this is a client or server issue.

thanks,

Baha

Ernie,
the descriptor information might be needed for reporting purposes. you are correct that i needed the message load to be transferred and that's been accomplished now.
thanks for the help..

Baha

Ernie, there was a table def under Table Definitions -> Real Time -> Websphere MQ Connector named MQ message. I have a feeling like this is added under table def once the MQ connector is installed. It worked fine for me. As a matter of fact it had way more information than i needed. Thanks, Baha

Ok I found the Data Element Column in Column definitions , so I am guessing that will be the way to import queue related information into the metadata i defined.. I am still looking for a way to load the message payload though.

Ermie and Vince, thanks for the help. I was able to view the data after little bit of a research.(message padding, etc. ) The data is coming with different format but they are in the expected forms. Splitting the data and then merging later will not be an issue. What i am not able to get is how to g...

It's an MQ message.. If it's already done through the XML it should not be an issue then..

I have to read data that is coming from mainframe that was put into an MQ. The mainframe data has a lot of redefines in it and this is making the things a bit more complicated for me. I have never worked with MQ before. After setting the values of the MQ connector i was able to view the data in the ...