DSXchange

This is what I have tried: [dsadm@perf MyProject]$ pwd /opt/IBM/Ascential/DataStage/Projects/MyProject [dsadm@perf MyProject]$ /opt/IBM/Ascential/DataStage/DSEngine/bin/dsjob -jobinfo "MyProject" testseq Job Status : NOT RUNNING (99) Job Controller : not available Job Start Time : Fri Mar ...

Thanks, I have waded through a few of them, but most are non relevant.

I will wait for one of the others.

Geez, I would hope not! Lol

I mean, direct me how to do this:

perfman wrote:Thanks Ray!
I got the Ereplace code which I wouldn't have found without your guidance.

So now I have the code, I just want to know, in the "build" stage type dialogue, where exactly do I put this code?

Thanks Ray, I tryied that and it did not work. This is still un resolved, however I have put this problem to the side for now, I hope to resolve it sometime, but as I have a workaround in place it is not as important.

Can you just direct me how to do it? I would really appreciate the help.

Cheers!

Thanks Ray! I got the Ereplace code which I wouldn't have found without your guidance. So now I have the code, I just want to know, in the "build" stage type dialogue, where exactly do I put this code? Now I would love to search for this but I am a bit vague on what key words to search on ...

My money is your friend. Haha. Did I say that! Lol

Thanks, I will go and have a look right now.

Thanks Ray,

I can see the dialogue.

Do you have a sample C++ code that will take one parameter and do the most simplest of tasks that I can get working in a parallel job?

I understand things much better when I see a working example even if it is very simple.

Thanks.

I have programming experience in other languages, so I guess I could work it out with a little research. What would help me in the meantime then would be for someone to explain to me exactly how to implement a custom C++ stage into a parallel job. Maybe show me a simple one that will add 1 to a valu...

My jobs do not use Hash File, they use Sequential file. So Does that mean I am using a Parallel Extender job? I know that I am using a "Parallel" Job, but I have not seen or heard the phrase "Parallel Extender" before.

Thanks for your help.

Thanks ArndW, First I'm not really sure of what is the difference between server and PX, so that is why I posted in General.

Can you show me what commands I would need to use in the routine?

Dear experts,

I need to calculate the buisness hours between two timestamps.

Buisness hours are between 7am and 9pm Mon - Sat (no pub holiday exeptions)

I'm guessing I will need to write a routine for this. What are your suggestions?

When I changed to Load/Append method instead of Upsert, the problem solved. Is there any reason for that?

Hi Ray,

Here is my format tab:

Hi, I am using DataStage 7.5.1 I am trying to load a test csv file which reads like this: "16/11/2005 13:58:38","17/05/2007 09:59:29",0,"This one does not have a null date" "16/11/2005 13:58:38",,1,"This one does have a null date in field 2" "16...