DSXchange

How many nodes are you using. There might be parallel connections open by you within the same job for a single Enterprise stage.

If your java adapters can execute scripts it can definately execute datastage jobs. But its better to have a wrapper script to check for return codes, do other household work as well. But to answer your quest, yes it can.

Just your connections might be 100, there might be other applications connected to the database at the same time. Take this error to your DBA so that he can analyze the number of open connections during the time this error occured and increase the maxappls.

Can you execute it from unix using the same id? If yes then try giving the command as

Never mind, its blocked on our intranet. Ill check it out at home. Disregard my previous post.

Your generating sequential number in parallel. You have to bring into consideration the partition number and the number of partitions too. There is an FAQ entry by vmcburney on how to do that. Look here.
You can also use surrogate key generator.

Here, I found it. Enjoy.

Within the script, use fully qualified paths for any file you write to or reference. Your script is complaining that skey.txt is not present. Ofcourse not, the dsengine will look for this file in its home directory. Your script works from command line because skey.txt might be present in /data/ dire...

gateleys, if at the end the performance is still not at an acceptable level, go for staging tables. Load your lookup and source into work tables and pass the same sql. Do that anyways while you wait for advice. It will give you a feel of how quick the process can be at the database level.

NullToValue() does not work. Try handle_null(). You wont find its syntax in the manual. Refer here for exact syntax.

The images are not showing up.

Do you have sorted input? Can you explain your job design a little bit more clearly. Do you have any more error messages? details man details.

You can give any group name. dstage is, generically, used in many places.

What did you find when you did a search on ExecTCL?

Comparison could be >, <, =<, => or even <>. For this very reason, not only they have to be in identical formats, they should be in YYYY-MM-DD or YYYY/MM/DD. In short, any format that first has 4 digit year, 2 digit month and 2 digit day.