DSXchange

Hello Mr. Craig! Thanks for the quick response! Right on the money, yet again! :D You are exactly right. Easily checked by simply putting the xml message in notepad, saving as an .xml, and viewing in IE or other browser. With just a '&' the xml will not view, but replacing '&' with '&' (...

Hello DataStagers: I am reading a string from a 9.7DB2 table. The string contains the ampersand "&" sign. (an example "Johnson & Johnson")When I pass the VARCHAR string to an XML Input Stage (not the 8.5 XML Stage) with fatal, error, and warning set to go to a reject link...

Hello DataStagers! After a few emails to the IBM support teams, the original fix patch JR43541 did not completely solve the problem, it had a bug, the actual fix is JR45664. What was happening to cause the original null path exception is that XPATH expressions were not being populated/formed on WSDL...

Hello Datastagers! How have you solved this problem? I am loading a large amount of data >100million records and I am using the IIS 8.7 64Bit AIX 6.2 surrogate key generation stage to connect to a DB2 9.7 FP7 Unix 64 bit database sequence with cached values we have created. Due to the fact that mult...

Hello Ernie: Now I know there really is a light at the end of the tunnel, and its not a train, when Ernie gets involved. Basically the input is hard coded on the Web Services Client Output tab> Input Arguments. We have had to get IBM Tech Support involved and they have reproduced this error and are ...

Hello Ray and Istsaur: Thanks for the quick response. I know I am close when I have good people like you two on the case. I have not checked the actual Web Service through SOAPUI explicitly, which is an excellent first step in checking connectivity, yet I have checked it through another IIS 8.7 wind...

Hello DataStagers: AIX 6.2, IIS 8.7. I have a simple Web Service Client to Peek calling the Weather Web Service (http://wsf.cdyne.com/WeatherWS/Weather.asmx?WSDL) I enter the appropriate information, zip, and get the following error: wscWeather,0: Info: Weather_WebService_Call.wscWeather: com.ascent...

Hello times29: I agree with priyadarshikunal that the trim does nothing. The IsNotNull will return a 0 if it is Null and 1 if it is not, so no need to trim. Are you doing this as a Stage Variable or a Derivation? I have seen "unexpected results" when using SetNull in a Stage Variable. A qu...

Hello DataStagers! Thank you MT for your reply! If you bulk load a table in a DB2 database that is in Log Retain mode, it will place the tablespace in Back-up pending. If you do not want to be able to recover the load if the database goes down before the next back-up (which was OK in my case), you c...

Hello DataStagers! Thank you for the insight Ray. You are always on top of things! This is what I did. Since the record has multiple ooccurrences of the value I needed to replace and some of those occurrences did not need to be replaced, I just 1) used the Pivot Stage to pivot the columns that had t...

Hello DataStagers! Thank you ArndW for your info. For those of you who want more info, the best insight that I can give is to read the Orchestrate 7.0 User Guide and the Orchestrate 7.0 Developer's Guide. Specifically, on page 14.29 of the user guide will give the information on the example. I highl...

Hello DataStagers! Would someone please post an example from their working Custom Stage (Build Type) Build tab> Logic> Definitions and Per-Record sub tabs. My objective is to use this stage and I cannot find a single example to determine syntax, usage, etc. All of the Advanced Developers Guides from...

Hello DataStagers! Your assistance please. Environment: Database- DB2 9.7 Unix, Database is Log Retain Mode (Not Circular Logging); IIS 8.7 Unix I am attempting to use the DB2 Connector configured with Write Mode: Bulk Load, Table Action: Append. The table loads correctly; however, since the logging...

Hello DataStagers: I also received this message. I am running IIS8.7 Win2008R2 64 bit client to AIX 6.1. IBM does have a link to this problem https://www-304.ibm.com/support/docview.wss?uid=swg21515435. However it did not provide the information I needed that eventually solved the problem. :( Search...

Hello: Question: What is the best way to replace a character(s) that is found in multiple columns of a record with a standard value? Condition: Picture a record with 10 fixed length columns. Five of the columns contain a character in the last position that needs to be converted to a standard value. ...