DSXchange

Hello, I'm writing a UNIX script which modifies 'dsjob -run' present in existing scripts to either 'dsjob -run -mode RESET' or 'dsjob -run -mode NORMAL' based on job type i.e., Job or Sequence respectively. Is there a way to find out if a job is a DataStage Job or Sequence from UNIX command line? Th...

Try this... In your ODBC Enterprise stage, go to the Columns tab. Right click anywhere in the grid and select Properties. Check the check box next to 'Extended' and click 'OK'. Back on the grid, in your column identified as TimeStamp, drop down the list box under Extended and choose MicroSeconds. Yo...

You canot parse the Language tag? Then your Xpath to the Language element has a typo or other fundamental problem. If you are getting a single language when you expect a row per Language then your Repeating element is probably mis-defined. Is the Repeating Element set to the Language element so tha...

We are trying to parse an xml file into tabular form for database update. The job looks similar to this: a sequential file -->xml input --> tranformer stage-->sequential file The xml source is written below. We are having problems with handling multiple languages in the nested tags(Languages). <?xml...

The message was never set to char. It was always a varchar. I am not sure why we were getting nulls added to the end of every message, but as soon as I set the Apt_String_Padchar variable to space, it fixed the problem. I am assuming that the MQ Connector will strip padded spaces but not nulls. How ...

Ernie,

Testing proved that adding the APT_STRING_PADCHAR environmental variable and setting it to a space fixed our problem with nulls being appended to the end of our xml messages.

Thank you for your assistance...

Thanks for your reply Ernie,

I added the APT_STRING_PADCHAR and set it to a default of blank. Initial testing is looking good. We have sent through one message and it wasn't padded with nulls. We will be doing futher testing tomorrow at which time I will update this post with the results.

I have a job that reads data from a DataSet, creates an XML message using the XML Output stage and then places the XML message onto an MQ Queue using the MQ Connector. The output XML message could be quite large because I am aggregating the message by one of the columns. I set the output column out ...

Thank you Istsaur... We actually found a solution shortly after I posted the question (after spending 5 days working on it). Our solution was to change the MCAUSER setting of the channel using the Alter Channel command. We actually created a new channel and altered it to make the DataStage user the ...

Hi All... I am usually able to find answers to my questions by searching the forum. This time, I have been unable to find a solution. I am attempting to use a Webesphere MQ Connector for the fist time. On the properties tab, I enter all the valid connection values. When I click the "Test" ...