DSXchange

Hi Prasanna,

I am sure it won't be parallel enough to trigger all the jobs at same time but it triggers as it loops through and doesn't wait for the first one to fail or succeed.

and, I have not given the wait option in DSJOB command.

Thanks...!

Thanks a ton Craig and Ray. I have been able to achieve what I wanted. I have a sequence which has a job activity and this activity reads the rows from table and then these rows are stored in a file. Then I use Execute command to read this file (as pointed by Ray) and then I have a start loop to loo...

Hi Craig,

No, we won't be running 100 jobs, right now we will be setting the higher limit to 15 and in future we can vary it based on resource and utilization factors.

So, if that's the case, I can try with the Ray's approach and see if I get what I am looking for.

Thanks...!

Thanks Ray and Craig for your comments. Ray: Though I was only able to part of your post but I think I understand what you are saying is to have all those rows converted to a big column and then loop through it. In that case my next question would be, that will it scale in the sense that if I get le...

Hi Chulett, I am trying to implement this by storing data in a file and reading it with execute command and then using dsrunjob command in a loop for all rows with waiting for status. But, I am not sure on how to read multiple rows and parse them to run in a loop. Any help will be appreciated. Thank...

Hi Craig, So, if I understood correctly you are saying the loop will also run these jobs sequentially, I wasn't able to test that part because I was always getting last row and it was triggering same job 3 times. And then (if I can ask) what would be the best way to implement my requirements which a...

Hi Chulett, Thanks for quick reply. Though I am not able to see your full reply (because I am not a premium user and can't be a as I work occasionally on DS). I tried to use the UtilityRunJob in the server job itself and then triggering my following jobs but it doesn't trigger them parallely it does...

Hi All, I am reading from a table (can be one or multiple rows) and the row/s have job name and required job parameters. Based on my read I need to trigger the those different or same multi-instance data load jobs parallely with two common multi-instance jobs (one before data load and one after data...

Thanks craig,

We are also checking with IBM support but was making sure if anyone else has faced the same issue earlier so that i can directly to the point.

Thanks for your help...!

Hi, I am trying to parse a xml but it is failing with error "is not a valid property list: Error parsing list for property "DSDescription" Error parsing list for property "DSDisplayWidth" Error parsing list for property "DSSQLType" Error parsing list for property &...

Hi,

Here is the transformation iam using

StringToTimestamp(DateToString(DSLink3.DAT):" ":DSLink3.TIM[1,2]:":":DSLink3.TIM[3,2]:":":DSLink3.TIM[5,2])

In this case DAT: 2007-08-13
and TIM: 16184530

Please let me know in case you require any oher info.

Thanks...!

Hi, I am importing data from ODBC stage to a table in Teradata and using a transformer to combine date and time cols to load as timestamp in TD. As there are some duplicates in table, i am using Remove Duplicate stage to remove those duplicates and they are row level duplicates, but when i am runnin...

Hi,

In .dshome it was earlier pointing to Ds 7.5.1 home, then i pointed it to Ds 8.0.1 and again the answer was same.

I restarted the DS 8.0.1 server again..... but again the result was same....

Thanks...!

Thanks...!

Thanks a lot Raghavendra.

Hi, I have two versions of DS(7.5.1 & 8.0.1) installed on our unix server. They are installed at different paths but when i am trying to run a job with dsjob command it is still pointing to the older version projects(7.5.1). When i do dsjob -lprojects it lists down all the projects which are exi...