DSXchange

Use Ereplace() or Convert() to change comma to dot.

Strange. No bug that i know off. Try velgapudi_k's suggestion. Are you on windows xp server pack 2 by any chance?

Not really. You get the jobnames from the repository instead of typing it yourself. This way if any jobname changes, it will reflect in your list.

Did you try clicking on the plus sign to open the folders? Or maybe they got moved to some other folder. Can you see the jobs under a particular folder in the designer?

I dont know why I was under the impression that an array size of 1 meant about 50 rows or so. Atleast now I got my facts right. Thanks Craig.

now when I create a sequential file how will I eliminate the " that the system is putting. Read my previous post again to see how to populate date without the quotes. The system does not do anything. Your job does that. I suggest have all your parameters in a file, read them as i have suggested and...

pras wrote:Hi ,

Can we able to run sequence of jobs one after another using scripts???

Thanks,
Prasan

Sequence jobs are also datastage jobs and can be run via Job Control or a script. See Ray's reply.

Resetting the job brings back the job to its previous state. State that it was in before it got aborted.
And what do you mean by

Latha1919 wrote:
Secondly, we had a build in the same environment yesterday. Are there any chances of job aborts due to build such as jobs corruption etc.

Pelase advise.

Thanks,

Welcome Aboard,
No, just those two files for an odbc connection. This has been discussed here before, search on keywords.

Try to decrease the load amount on your server. If you absolutely have to run many jobs in parallel, then talk to your system admin to tune the kernal properly to handle simultaneous requests.

What is your while condition?

Well atleast bring this out infront of the IBM folks. See what they have to say.

A little correction, array size is not the commit level but how many rows are passed in a single go. An array size of 1 sends 50 rows i think. Transaction size is equivalent to commit level. This is a good functionality in server but I hate the fact that I have to use the array size as 1. Kills the ...

There is a limit. This limit and constraint can be better explained by a unix admin to you. They have to tune the kernal appropriately to support massive simultaneous processing. And if you push to much, you can reach resource limitations, beyond the kernal tuning.

Wow, I just realized that I said the same thing in his other post as you guys. Oh well [shrug] [shrug]