DSXchange

Thanks for your reply! But I am not sure I understand it completely. :?: Is it because the ascii 0 char is not present or is it because it is present? In either case, what is the workaround? How can I ensure that the complete record will be returned by the awk statement? Is there some specific setti...

Hello, I am writing records to a sequential file and then using a shell script to split the file. The record delimiter is 'UNIX Newline' and the final delimiter is 'end'. There are 2 columns in the file and the second column is a VarChar(2000). The second column itself contains double quotes. When I...

Thanks for your inputs! I have posted the query on ADN.

Regards,
Bakul

Thanks for all your inputs.

I am using the 2 XML Output stages, 1 Merge stage and a final XML Output stage to generate an XML. The input file is around 2GB. The job completes succesfully. However the entire XML is not generated. The job log shows the error, XML_Output_14,0: Caught unknown exception from runLocally() XML_Output...

Thanks for the reply!
However my query is slightly different. I wish to know which option is better -
1) Joining in the SQL query
or
2) Joining using Join Stage

Regards,
Bakul

I have 3 tables A, B and C. I need three kinds of information 1) Information from table A 2) Information from table B for all rows in A 3) Information from table C for all the rows in B. Which of the following approaches would be better performance-wise: 1) Use 3 DB2 stages each to extract the above...

Hello, I need to read data from a database and create XML files in DS EE. To generate the XML, multiple XML Output stages have to be used. I have been able to generate the XML (by maintaining sequential flow). My only concern is about the performance. Many posts on this forum mention that the XML st...

Could you please give me an example of how to generate XML using sequential file?

A similar message has been posted earlier on the RTI Forum. I am posting it here(with updations) hoping that I might get a response. :) I want to generate an XML document of the form <header> <city name='CIT'> <customer> <name></name> <account></account> </customer> <customer> <name></name> <account...

I have used the row merger stage to combine multiple rows into one row. But with RTI jobs,since the instances are continously running, the row merger stage concatenates all the previous instance rows to the current instance rows. Is there any way to ensure that the row merger merges the rows belongi...

That would have been the perfect solution in ordinary circumstances. But the job is RTI enabled so I can't use any passive stage with both input and output links. Is there any other way to accomplish it ?

Instead of using TO_DATE(?, 'MM-DD-YYYY HH24:MI:SS') in the user-defined query,you could generate the timestamp in the transformer using, OConv(@DATE,"D-YMD[4,2,2]"):'-':Oconv(@TIME,"MTS."):'.':'000000' Define the timestamp field as timestamp with length of 26 and scale 6 Now dir...

I have a job in which I perform a lookup using some value and then update the looked up values in the next transformer. Now the problem is that if the key for lookup repeats then the values have already been updated so the lookup should return updated values. But the Lookup stage still returns the s...

I'll try to provide some more information. I want to generate an XML document of the form <header> <city> <customer> <name></name> <account></account> <account></account> <account></account> </customer> <customer> <name></name> <account></account> <account></account> </customer> <branch> <name></nam...