DSXchange

The appropriate way to determine whether the WAS is running is to use the serverStatus server1 command. The servers can be started from UNIX command line (or by rebooting the server). From memory the command to start the WebSphere Application Server process is startServer server1 then you have to st...

You only have a time, not a timestamp.

Are your data partitioned on ID ?

Your UPDATE statement mentions a table called ABC.ORCHESTRATE.TBL_NAME

Is this genuinely a table name in your database? I suspect not.

Review the mechanism you've used to generate the table name.

Can you please wrap that in Code tags so that the spacing is not lost?

The problem has been reported from a stage called Transformer_1.

Maybe you're looking in the wrong place.

What error message do you get? Is the WebSphere Application Server (server1) running?

Welcome aboard. Your "some parsing error" is singularly unhelpful.

Please post the exact error message.

Not sure why you have "ORCHESTRATE" as a qualifier of the table name.

You only need one Convert() function.

What if you derive it as itself?

Find out what that character actually is, using a hex viewer such as the od -xc command in UNIX or an editor like UltraEdit. Then you can use an appropriate Char() function to represent that character and either remove it or convert it to something else. Just be sure that it's valid (according to th...

This seems to me to be a simple inner join on id, possibly followed by a sort. Make sure you get the partitioning right, though.

What happens if you provide no derivation or purpose at all for this column in the SCD stage?

Data Set files are not sequential files.

A physical Data Set consists of a descriptor file containing the record schema and the locations of the segment files that hold the actual data on the directories idenfied as disk resource in the configuration file.