DSXchange

Thanks Ernie. Looks like you confirm in your own way that setting the JMSType header is not something that can be done with the current MQ Connector. I basically tried to set every options in the connector to a test value and none of them resulted in a JMSType header in the message I received in the...

Hi all, A colleague of mine in the organization would like to read messages I sent to a Q with a JMSType header in the message. The payload I'm putting on the Q is a JSON string. I know that I can find this information in the data element FormatHeaders if I read a message from a Q that contains a JM...

Chulett, the parameter set exists in both projects as well, so that's not the issue. Could have been a good clue though so thanks. I have another way of going about it with different stages, but the external filter would have made it simpler. All this because the "read select statement from fil...

Testing the stage with this. Exactly the same job: SeqFile_0 ---> EF ---> SeqFile_1 The external filter contains a "sed" instruction. It executes fine in Project A, but does absolutely nothing in Project B, which was based on Project A. In the job log from Project A, I see that external fi...

I'm also not certain why your colleague "hunts" for data specifications. Those can be easily imported from most database tables. Even when designing against early specifications where the tables aren't built, best practice is that data types should be specified, even if they have to be tw...

I'm having a debate with a colleague concerning the way to load sources in a schema. He likes to hunt for datatypes and lengths when building his source schemas before processing and I like to load my source in schemas that have only varchar datatypes before processing. Of course, the data will be t...

In this old post, the user is talking about a "no-op" modify stage. I can't find any other reference to these terms in the forums. Anybody knows what the user meant?

Here's the post:

viewtopic.php?p=334734#334734


Thanks

Ah, nice. I'll do a test with this later on and see if its works.

On a parallel routine that has a char* return value, I tried to return "", 0 and NULL from the routine to a stage variable but none of these returned true with IsNull when I checked. Is there a special value I should return from my parallel routine so that IsNull, NullToValue etc will prop...

To answer your question about the practical applications, yeah. I was testing the functions from my custom routines library and one of the functions has a char as an argument. Thanks for checking it out. Your results and mine seem to imply that there is indeed a problem with the way char arguments a...

It was giving back zeros because I was passing it strings inadvertently ... 'x' in the transformer is, as I noticed earliler today, a string not the letter x. So that makes sense now, a string parameter isnt compatible with "unsigned char". You can obviously force it to display the charac...

UCDI wrote:Is that working for you?

Nope. I tried casting like you did and it also returned 0. They only method I tried that works is the Char() Seq() combo I tested earlier. If you only use the Seq() call, it returns the proper ASCII value.

hmm I am actually having the same woes. I was able to get a value (integer, not character) with return 'R'; and various other constants. But I have been unable so far to return a value from a variable. I am still looking at this. I'm not at work, but the only way I was able to get the result I want...

I found this old post while searching for the same error I got: http://www.dsxchange.com/viewtopic.php?p=361780#361780 My question is why have the choice to have a char argument in the list if they create the error referenced at runtime in the post above? Also, why does the datastage compiler makes ...

Ok, thanks chulett. It's completely clear now. Can't say I like it compared to how Data Manager handles derivations but hey, gotta adapt right?