DSXchange

Thanks Ernie. I'll try the method you mentioned. I was looking to see if XML assembly stage itself can support recursive xml.

Thank you.

Hi, Is it possible to parse recursive XML using XML assembly stage. Below is an example of recursive XML which i got from internet. There are solutions which are java based. But I've a similar structure which needs to be parsed using Datastage. Please let me know if it is possible and if so how to p...

My initial logic did not work. I implemented a different workaround. My initial problem was there were multiple lists within a node which i need to join in order, to store them in table. Since order join did not work, i used aggregate function in XML stage to combine the list in a delimiter. I creat...

Hi, I've a requirement to implement Order Join outside of XML stage. 8.x has a bug in Order Join in XML stage and it needs a patch to be applied. There is a delay in applying patch, so i need to implement workaround of doing order join outside of XML stage. 1. Is there a way to correctly implement o...

Hi, I've been using XML assembly stage to parse XML files. So far it was good but recently i started getting error in one of the file type. XML Schema looks as below with hierarchy indicated by tab. Root Header Attributes Parent 1 Child attributes List 1 (key) List 2 (message) List 3 (detail) Parent...

Thats stupid of me....it was hiding behind status. Thanks Anbu.

Hi, I was monitoring the jobs using Tools -> New monitor. I noticed that "Num Rows" column is missing. I could see rows/sec changing but "Num Rows" column is totally missing. Is there an option to get it back?

If the first seq completes successfully, everything works fine and routine returns userstatus as 0. Issue is only when it is restarted after failure.

Chulett, I actually meant if the UserStatus will never get reset in case of checkpointed sequence. I guess similar question was asked once and you adviced to use jobstatus instead of userstatus.

kandyshandy, I did try that. Its not working.

Not sure how to get updated value of userstatus.

Thanks kandyshandy. Yea Seq 2 is the master seq. updated the post.

@Chulet, for handshake between different technologies like Java/SAS/Unix scripts we had to define our custom error codes. Is there anything wrong with the design or datastage is supposed to work like this?

Hi, I've two job sequence like below. Both have check point option set. Seq 1: ------ Job Termination ( Failure) | Job Activity --- | ------ Setting User Status as 0 using routine. Seq 2: Job activity has seq1 as the job. ------ Setting User Status as 0 using routine | Job Activity --- | ------ Sett...

Thanks for the info Ray.

If it is user defined, is it necessary that it should be added to "User Defined" list in Administrator or I can directly pass it to job?

Hi, We are getting the following error in out production box wherever hash partitioning/sorting is done on the link (No external sort stage) Fatal Error: mmap failed: Not enough space When i checked the forum, it was suggested that an environment variable "APT_TSORT_STRESS_BLOCKSIZE" to be...

No Ray. It says There must be zero or one container inputs, zero or more container outputs, and at least one of either. We've a input to shared container which is a parallel dataset. The shared container has a basic transformer. Will the issue be due to parallel dataset feeding a server shared conta...

Hi, We have a parallel job that calls a server shared container. The following is the design DataSet --> Server Shared Container Container: Database | Input --> Transformer --> Seq File Here the transformer is basic transformer. When we run the job, it is throwing the following error. Abnormal termi...