DSXchange

It is comparing to timestamp field, why do you concern about the length?
Its OK to compare two timestamp.

Since your jobs are attached with jobcontrol process, it might cause the problem. We have a similar jobcontrol process and it won't allow a single warning. So if any job in the sequence get a single warning, job finished but sequence aborted due to the job warning.

As you mentioned, your Job status as "Finished (see log)" , means you have some warning in your job. Sequence might be aborted because of that, since the previous job not finished "OK". Please check this too.

Just to check.

Take only one record to test and send it PEEK stage and compare each and every column. You might get a clue from that.

Best of luck.

1. Check whether you have same number of columns in your before and after link. 2. Verify the key column and change columns, and see whether you add any surrogate or generated column in your before and after column list or not. 3. Check whether you are doing any kind of transformation before loading...

1. Check whether you have same number of columns in your before and after link. 2. Verify the key column and change columns, and see whether you add any surrogate or generated column in your before and after column list or not. 3. Check whether you are doing any kind of transformation before loading...

1. Check whether you have same number of columns in your before and after link.

2. Verify the key column and change columns, and see whether you add any surrogate or generated column in your before and after column list or not.

Select option "Clear" in "Preserver Partitioning" of your transformer output link.

Do you have separate file for two link?
Check RCP check box in your job.

Use LEFT fiunction if you want to strip last three (fixed) character from your input value.

Use LEFT fiunction if you want to strip last three (fixed) character from your input value.

Could you please tell us detail about your requirement? If you are selecting only one column from DB2 and try to get the result as you shown then CONVERT can do this. Use Convert function and write into another seqfile, and read the same file in the next job. But if you are selecting multiple column...

Hi,
Open your source file in a file editor that can handle ASCII as well as NON_ASCII character, let see whether there is any invalid character there or not. It may be a non printable character, not shown in your log from PEEK or from other stage.

Hi, Why are you using default decimal[38,10] in your input, sincne you know that the value should be within the range of NUMBER(5)? Probably you are using some oracle function when you select this from the source. Use CAST utility of oracle and get the value as NUMBER(5) instead of [38,10].

You can't do it. You need to scrambled password value and write into a file. Un-scramble < Cat the file and used password inside your script.
You can use PERL scripte for this.