DSXchange

i am running a job sequence which contains 4 jobs. after every job successfully runs it is taking exactly 8 mins to initialize the next job. that means it is taking exactly 32 mins to run all the jobs in the sequence. whenever i am running individual jobs it is taking only 40-50 secs to run a job. B...

Hi,
getting rejectfiles using sequentialfile

The image you had given in the link is too unclear to read.

Please post the SQL State Code which you get in the error message.

Check the code page setting of the DB2/400 with your DBA. Couldn't remember the exact code set to be used at the moment.

Also try using the ODBC enterprise stage for the extract. If that also fails then it is good to look into the .odbc.ini file once to see if it is properly configured.

There's a problem in the query as per the error message which you'd posted earlier. The syntax may be right for SQL assistant but not for Teradata stage.

The problem is more likely with the transformer. The cause is a mismatch in the JVM's of both the transformers. In all the three stages starting with the first transformer in your job design, go to advanced tab and set the combinability mode as "Don't Combine". Then re-compile and see if i...

Metadata mismatch probably. Use a sequential file or dataset stage to capture & analyse the reject rows.

Abhilash,

If you do a total sort then hashing on both the columns would still give desired output.

If the job runs on three nodes without total sort the same value will be repeated thrice.

If you have checkpoint option enabled at the project level, then Yes.

Dataset Management Utility

Refer to Parallel Job Developer Guide in the documentation.

This link also has the information you need
http://publib.boulder.ibm.com/infocente ... rator.html

When defining duplicates, it is done at the individual column level only not by concatenating 2 or more fields. By using remove duplicates stage and retaining the first record as James and others have suggested, your output will be Col1 Col2 A 05:00 B 03:00 This is the desired output as per your pos...

jwiles wrote:No, the decimal will be length 3 scale 2.

Slipped out of mind...

As per the copy book specifications, The length of the ID field should be 4 and the decimal is (1,2).
When using a fixed length file, the metadata has to be precise. Try after making the above changes.

Hi,

What is the user defined environment variable you are trying to define?