DSXchange

Thanks, Ernie!!! That is the workaround we were thinking of.. but I'd rather have the XML output stage work "as advertised". This one is going to IBM as a bug and i'm marking this post as resolved: Workaround. Thanks a ton for the assistance Ernie!!!!! As Craig mentioned recently, You're t...

Additionally, If i use the following XML chunk (The Ideal XML chunk mentioned in the above post) and input it directly into the WEB Services Transformer stage, it works: <ns1:CtoF xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/&qu...

The problem i am facing right now is with the XML Output Stage. The XPath I get for the "temp" column when i import the CToF_IN tabledef is: /ns1:CtoF/temp[@xsi:type="xsd:int"]/text() The XML chunk that <B>Ideally should</B> be generated considering the above xpath is: __________...

Thanks for the response Ernie!!! This is where i am as of now: a) "load" the _IN table into the Input link of the XMLOutput Stage placed prior to your WSTransformer... Done b) load the _OUT table into the Output link of the XMLInput Stage placed after your WSTransformer. Not Done. I would ...

Hi all, Trying to test the webservices transformer to post data to a web service. The webservice I've used is the Temperature Conversions service (Starting small as recommended here and elswhere(Thanks ernie for your amazing blogs)). The web service page is: http://xmethods.net/ve2/ViewListing.po?ke...

Also if you build a custom stage, the onus is on you to ensure that it is properly coded, tested and does not have any memory leaks.. etc. Also the person who will support it afterwards better understand C++ and what exactly the stage does. Too much work/risk IMO. Especially when there is a standard...

I also suspect (But do not have enough info to confirm) that a routine could have the housekeeping overhead akin to a procedure or function call while a transform is more like a macro that is expanded inline with the actual transformer code.

A crazier solution that might just work (cannot test it as no PX available nor have i had to try it out before as i always used a transformer )is to use a Column Export stage to get the 2 (Or more) columns together in the format needed.

That said, I'd go with the transformer.

I have noticed the same thing. Designer does not seem to like this( I always get an angry red font) but the code does work. Must be something to do with the fact that the Transformer already has evaluated the all columns for Lookup1 and has the corresponding data from the reference data source befor...

The question is for the Lookup Stage and the Jobtype correctly mentions Parallel; However this query has been posted in the Server forum. The lookup stage can be configured to push lookup failures down a reject link. Option 1: If the 100 rows is constant A transformer( running in sequential mode) co...

I have a server job solution that should work for any number (Actually 99999999 :) ) of such fields: Job is: SeqFile----->Transformer----->SeqFile(No delimiter;No quote;Unix Format) The seq file is read in as a single row as is being done now. there are 3 stage variables in the transformer: V1=field...

Hi!

Welcome to DSXchange!!


Difference 1:
The first does not exist in PX and the other does.

Apologies,

But I do not see why the two need ever be compared.

Point 3 will be taken care of along with Point 2. The exception handler code will be trigerred when DataStage does not know how to proceed in the middle of a sequence map. E.g. Job1-----> Job2-----> Job3 OK OK Exception Handler-----><Do Something> If Job 1/2 ends in a status other than OK, the excep...

I suspect that this post is about the Oracle Enterprise stage in PX VS the Oracle load stages in Server?

2 things: 1. reseting the job may provide additional input in the director log. 2. I've usually encountered this warning when a null was passed to a routine that expected a numeric value (been a while since i've seen this; I might be wrong). The NullToZero transform (wherever viable) usually takes c...