DSXchange

A merge stage cannot be used in this scenario because a merge stage takes no inputs. The xml documents to be merged are generated in the job itself. Also,any passive stage with both an input and output link cannot be used in an RTI enabled job.

Is it possible to specify more than one XML Repetition path?

Is there anyway to merge 2 XML documents. I don't want to concat them,I want to merge them.

I have 2 transformers generating 2 different XML's but the output has to be a single XML.Is there any way to accomplish this?

Thanks and Regards,
Bakul

Thanks all for the response! I have used job parameters and that seems to help!

I'll try to explain what I want to do. I have to generate 2 types of queries based on an input parameter. In one query , I need to select the rows with field 'STATUS' = 'A' . In another query, I need to select the rows if the 'STATUS' is either 'A' or 'B' or 'C'. The query to run depends on the inpu...

I have a situation where I have to retrieve values for the same fields from a DB2 database every time but the where condition depends on the input data.
Is there any way to dynamically change the where clause in a DB2/UDB or ODBC stage used for lookup?

Thanks and regards,
Bakul

I tried writing DBMSCODE, SQLSTATE and REJECTEDCODE to a sequential file. I had given 3 records as input, each of which had a required column missing. I also tried giving a NULL value to a NON-NULL field. In the output sequential file the DBMSCODE and SQLSTATE are blank. The REJECTEDCODE shows a val...

Yep..that seems to be it! But now I have a problem with insert/update. The structure is something like this, Input ------> Tfm1 ------> DB2/UDB | | | XMLOutput None of the links here are lookup links. The link ordering is such that, the insert/update to DB2 happens first and then the data is passed ...

I had another doubt. If LASTERR/DBMSCODE/SQLSTATE variables aren't available till the PUT operation on the output link is over,what constraint should I use to send rows with errors on link OUTPUT2 and the correct rows on OUTPUT link? Note: The output stage is not a static stage in both cases. Thanks...

Thanks Ray!
I guess I'll have to try and work around it!

Thanks and Regards,
Bakul

Thanks Ray! But I have a problem. I want the DBMSCODE or SQLCODE which indicates the error to be carried forward on the same output link as the remaining data and so cannot use a second output link Output2. Any suggestions on how I could carry forward the DBMSCODE/SQLCODE on the same link as the dat...

Hi, I am using a DB2/UDB stage for lookup. I need to access the SQLSTATE and DBMSCODE variables in the transformer. However,even when a match is not found in the lookup, the SQLSTATE and DBMSCODE fields in the transformer are blank. How do I get the exact sqlstate in the transformer? db2/udb | | <lo...