Search found 31 matches
- Tue May 19, 2020 1:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MQ Connector - Sending vs JMSType
- Replies: 3
- Views: 17611
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...
- Mon May 11, 2020 12:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MQ Connector - Sending vs JMSType
- Replies: 3
- Views: 17611
MQ Connector - Sending vs JMSType
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...
- Thu Mar 29, 2018 7:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: External Filter - Run in one project, not the other
- Replies: 4
- Views: 3986
- Wed Mar 28, 2018 12:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: External Filter - Run in one project, not the other
- Replies: 4
- Views: 3986
External Filter - Run in one project, not the other
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...
- Fri Oct 28, 2016 6:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Always load sources in varchar only schemas
- Replies: 4
- Views: 4028
- Thu Oct 27, 2016 9:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Always load sources in varchar only schemas
- Replies: 4
- Views: 4028
Always load sources in varchar only schemas
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...
- Mon Oct 03, 2016 8:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NO-OP modify stage?
- Replies: 3
- Views: 3413
NO-OP modify stage?
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
Here's the post:
viewtopic.php?p=334734#334734
Thanks
- Wed Jul 20, 2016 8:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Returning NULL from parallel routines
- Replies: 4
- Views: 4144
- Mon Jul 18, 2016 4:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Returning NULL from parallel routines
- Replies: 4
- Views: 4144
Returning NULL from parallel routines
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...
- Tue Jul 12, 2016 6:24 am
- Forum: General
- Topic: char argument in parallel routines. The point?
- Replies: 15
- Views: 8807
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...
- Mon Jul 11, 2016 2:20 pm
- Forum: General
- Topic: char argument in parallel routines. The point?
- Replies: 15
- Views: 8807
- Mon Jul 11, 2016 8:52 am
- Forum: General
- Topic: char argument in parallel routines. The point?
- Replies: 15
- Views: 8807
- Fri Jul 08, 2016 5:26 pm
- Forum: General
- Topic: char argument in parallel routines. The point?
- Replies: 15
- Views: 8807
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...
- Fri Jul 08, 2016 8:18 am
- Forum: General
- Topic: char argument in parallel routines. The point?
- Replies: 15
- Views: 8807
char argument in parallel routines. The point?
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 ...
- Wed Jul 06, 2016 7:03 am
- Forum: General
- Topic: What's the best method to write complex derivations?
- Replies: 18
- Views: 10904