DSXchange

If it is PX and if you need first 11n distinct records based on the two field, you have many approach, like using remove duplicate stage in conjunction with transformer, or sort stage with the KeyValueChange option.
But you need to give out more information of what is you exactly need in?

That way I can generate my own restart capability that might, for example, include unwinding updates from the previous run, sending specific emails to users and so on. Building up of own job control rather than job sequence would do. You can check for the return status of the job is stopped DSJ.JOB...

Try the convert after setting APT_PADCHAR to ' ' (Space).
You can optionally perform the tr in the filter command if its a sequential file or in External filter stage if the source is database.

Are you trying to feed default null value as '' to output Decimal field?

##W TBLD 000000 02:51:08(005) <main_program> Error when checking composite operator: Output from subprocess: sh: /usr/vacpp/bin/xlC_r: not found.

Is it the first time you are trying to compile, It also seems that C++ complier is not installed properly.

I hope all the appreciation boost you to contribute more.

Aim at moon... Humm..

Aim at Ray, if missed, you can reach Craig

I have no option to try now, but may I know what is the interesting SQL generated? Where my guess goes like, first datastage tries to insert the row and due to constraints it fails, and later tring to delete the row, and so deleting the left out table row.

The latest log could have given you the information where the job is waiiting. Any useful message from that.

Did you got any other error?
Have you tried to get partial data by substr() fn, so that you can come to a conclusion whether the length is the only matter.

bondcaliwood wrote:If the tables are not in the same database load them both into temp staging tables in the same database and perform join in there.

Still it will run for long if row are large in numbers.

Still lacking information. If your target is database and if you collecting the information on the reject records, the way ray sais would do. Add another column where you can supply the link variables to get more information. Allong with that you will have the rejected record as well. Not sure what ...

It is not possible. Refer this similar post.

Check the option avaialble in Permission tab "DataStage operator can view full log" in DS Adminstrator client.

Atlast the option you chosed was the work around provided by Ascential support

Which is very similar ot Cartesian product by using Join stage.