DSXchange

Try Alt-V (the hot key for the View menu).

Starting is not your problem. You are not checking that everything is properly shut down before trying to re-start.

It is possible in parallel jobs for this situation to obtain, because the "fatal" error applies to a player process yet the conductor process (which is the only process writing to the log) is not affected.

Return code 0 means "running". I don't believe you have that right.

Welcome aboard. Search the forum for JobMonApp.

You have a different number of columns defined in your job than the number of columns indicated by parameter markers in your SQL.

Blame Bill Gates then re-boot Windows.

The point is that a timestamp has at least 19 characters, not 10.

You can create the hashed file and its dictionary with a single CREATE TABLE command. CREATE TABLE hashedfilename DATA pathname_of_hashedfilename DICT pathname_of_D_hashedfilename ( column_definitions... ) ; RESIZE hashedfilename * * * 64BIT (You can probably include the 64BIT option in the ...

Substring and concatenation is almost certainly the most efficient. Arithmetic (with Int() and Mod() functions) will be a close second.

Create another link in your job using a Copy stage. Add a Column Generator to generate 1 for every row. Add an Aggregator to total these 1's. Write the result to your file.

Do you have SELECT privilege on the system tables that DataStage needs to access? Search the forum, or your documentation, to find out which these are.

The reason is that floating point numbers can not be stored accurately in computers - there are always precision issues. Search the web to find thousands of articles on this subject. (Double is also floating point.) To lock in a decimal representation convert the floating point data to Decimal upstr...

I suspect that EditServ.impl.JobDefnImpl@79427df4 is a name used in the common repository for Information Server. Check with IBM whether you also need to re-index that repository.

That's because it's a very strange requirement. WHY do you need to convert data to binary format, and what particular binary format is needed? There is more than one possible binary format. In short, please post the official specification that "they" have given you.