DSXchange

Well atleast now you have a work around. In the mean time you can pursue this strange behaviour and get in touch with IBM support.

Symav, you have just hijacked a post. Please start a new post and it will be answered there.
Regards,

Ok i am confused. Why do you want to run your code for 365 times for each table. Let all the historical data go through. For daily load you will be just doing a select for the current year right? or you will be doing a select from all the history tables. Maintaining history is easy, the standard typ...

What are the error messages that you are getting?

Well examine those routines. One or more variables that you are using inside the routine was never assigned a value and/or never intialzed.

Is that job using any routines?

It depends upon your datasize. Also depends if your dba will be fussy about giving you load permissions. Bulk loader will be much faster. Inserts will be slow. But if data size is small use the API else use the bulk loader.

Whats your job design? Looks like your using a transformer. Any special transformations involved. Need more info then that.

What a blunder. Sorry owow. Do an exact search on 'xp patch'.

I believe in one of the transformers your using a variable that never gets assigned a value and is not initialized. I think...

Welcome Aboard
There is a patch for it. Was covered recently. Search on keywords "Wondows Xp Patch"

So do you think if we remove synctimeout parameter from Additional connection option job would wait endlessly till the resources are available. I dont think removing synctimeout will make it wait endlessly. It might fall to a default timeout. Plus letting a job wait endlessly is not advisable and c...

Pretty impressive Kim. Keep up the good work. All of us look up to you, so let us in on your secret .

WHile setting up the parallel routine via DataStage, what 'Type' did you provide as the input variables? It should be defined as char*. But now that i re-read your question, you are saying that its 'return' value is getting messed up, the return value will depend upon your input. Maybe your not hand...

DSGetStageInfo().