DSXchange

That looks like a byte order mark.

Wow! That'd do it. Congratulations on your detective work. I didn't even think of that possibility (though it had to be an identically-named obhect of some kind).

Should be a simple query against DS_JOBOBJECTS table.

Get yourself a premium membership and read my entire solution.

It would have been nice to have a logo for the tenth anniversary of DSXchange, which recently slid by. We had a small party at IOD 2012.

Use an operating system command (such as DIR with appropriate switches) in an Execute Command activity to generate a list of file names. In a User Variables convert this list from line-terminator-delimited to comma-delimited using a Convert() function (the line terminators are represented by @FM). Y...

That's only true if ALL the Job activites are set to "reset if required". Do check this.

That looks like a simple vertical pivot (a following Column Export stage would pack the columns into a single column). What have you tried? We're not really in the business of being the developer you're pretending to be.

I have to ask: have you marked TempKeyCol as Key ? That's what gets DataStage to include in in the WHERE clause of generated SQL.

Once you find it you may find the undocumented -n option useful. It returns just the number (the words are omitted).

I'm on vacation. Nothing is urgent.

If you're not going to use pxEreplace() then you need a combination of Index() function and substring operators. For example: sv1 <-- Index(InLink.TheString, "Kolkata", 1) sv2 <-- If sv1 Then InLink.TheString[1,sv1-1] : "Calcutta" : InLink.TheString[sv1+7,Len(InLink.TheString)-7]

Can you obtain the size information by any other means outside of DataStage, such as DB2 Control Center? If so, how are you providing parameters to match the stored procedure parameter placeholders in the stored procedure call? For that matter, how are you attempting to call the stored procedure fro...

Parallel jobs do not use quite the same resources as server jobs. They do share some, but not many.

Is the WebSphere Application Server instance server1 already running when you try to start it?

Do you specify the name of the instance in your startServer.bat command?