DSXchange

Our requirements are more like the first scenario where we will call the service, drop the file and then have DS read and parse the file. I will recommend that our programmers use whatever language they are more comfortable with. Thanks again for all of your help.

Ernie,

Based on what we have learned so far, we have decided to try a different route to get the file attachments from the web service. We are considering on going with either JAVA or PERL and would be interested to hear your thoughts on the advantages/disadvantages of each.

Thanks,

Mark

Sounds like we will be getting our feet wet with SOAP and XML very quickly...

Thanks for the information and we will try your suggestions over the next few days. We will be sure to let you know what we come up with...

Mark

I need help using web services in DataStage 8.7. I am trying unsuccessfully to connect to a remote Web Service using an https connection. I can connect to the service using SOAPUI but can't connect using DataStage. Thanks in advance for any help/advice that anyone may be able to provide. I am receiv...

I have a problem where I am trying to get the unique values of multiple columns from a group of records and store the concatenated unique values into a single column in the output. In the example below, if any of the values of col1 - col5 change within any group of records (d-num) then the output wo...

Keith,

That solved my problem. Thanks for your help!!

I need to combine data from several columns into 1 column only showing any duplicates only once in the output column. For example:

Col 1 = A
Col 2 = B
Col 3 = A
Col 4 = C
Col 5 = B

The output column should be: A B C

How can I do this in DataStage?

Thanks in advance for all your help

Oh Ok. That makes sense now!! Thank You for your help!!!

Mike,

The left link is to the source file and the right is to the dataset.

Thanks

Thanks for your responses. Here are the answers to some of the questions that were asked:

1) Confirmed dataset record count using the Data Set Management tool in Designer
2) Using a Left Outer Join
3) Dataset was created using a DataStage job

Thanks

I have a Dataset which contains approximately 2.0 million records. When I connect the dataset to a Join stage only 1.3 million of the records are being read. I can put a Transformer or Copy stage between the Dataset and the Join and all records from the Dataset will be read. Any ideas on why connect...