DSXchange

Hello Ray, Thank you. Apologize for the delayed reply. I'm still waiting from my Premium Membership to kick in so I can see your entire reply. I see the first couple of sentence that talk about bridges. In the meantime I have been looking at bridges and they seem fine for established systems/tools/E...

Hello rkashyap, This works. Thank you.

Hello ray.wurlod, works perfectly. Thank you.

Hello PaulVL,

I agree and that was my reaction as well, which included a scheduler, but that the requirement.

Hello All, I have a Sequence Job w/ a User Variables Activity within a Start and End Loop Activity. In the User Variables Activity I am creating a DB2 timestamp using the following expression: Oconv(@DATE, "D-YMD[4,2,2]") : "-" : Oconv(@TIME, "MTS.") : ".000000&quo...

Hello All, I have the task of continually watching for and moving a file from one directory to another directory. It must be: 1) DataStage only 2) Continually watch a directory for a particular file to appear. The file is being FTPed to that landing directory. 3) Moving that landed file to a new dir...

Hello chulett,

Outstanding. That worked just fine. Thanks so much.

Hello PaulVL,

Thanks for your reply.

I have a Job in hand I want to reuse as-is, but it's built for 1 node. When I use the project's 3 nodes I get dups, warnings, etc. I don't want to change the job for 3 nodes. I want to use it as-is.

Hello All,

I have a job I want to use one node. The project config files has 3.

Is there a way to have my job use one node? Is there a way to override the 3 in the project?

Thanks in advance for any help.

Hello all, How can I protect a Shared Container from being changed / updated by others? I have a Shared Container being called from dozens of jobs, the calling jobs are not always owned by me. The calling jobs uses a reference to the container. I tried exporting the container as an executable only a...

Apologies MT, having a Homer moment. I asked you "With this solution it seems we loss that multi-language support. True?" My original tests was in English. I reran both test using Spanish language, which included inserts and export from the DB. The results were perfect. So it seems the sol...

Hello ray, I do have a reject link. Records never seem to land there. High-level, as a test I have the commit set to 2000, load three records. The first and third are fine the second has an invalid date. DataStage throws a warned on the second record, did not load that record, nothing landed in the ...

Will do. Thanks

Apologies chulett,

Right now, I think this issue is causing an issue with records being dropped at insert time (a second issue). Right now I don't know for sure if they are related or not. If we can resolve this one, then I'll know for sure that they are related or they are two separate issues.

Hello chulett,

Agreed. There is a larger issue, where I am losing records at insert time and DB2 connector is not rolling back. I will ask this in a follow-on post, once this issue is resolved and if the issue continues.