DSXchange

Delete the Record Delimiter and keep the Record Delimiter String. See if that helps. Also, view the file with a hex editor and see what do you have at the end, exactly.

Create the lookup file set after doing a substring. Create your source keys by doing a substring. Then do the join on this key. Down the stream you can concatenate and build your true key.

But why not via a bat file or command line dsjob?
Or, keep seperate sequences and then schedule them one after the other. That is certainly doable.

Is this date field part of the key? If no, then you can certainly do it by setting a constraint in a stage variable.
Something like

Ok now its getting confusing? Where are these fields specified as char(20)? Or do you need to convert them to char(20)?

Indices need to be created explicitly, so yes, create them explicitly.

Welcome Aboard
Meaning of Transfer in DataStage means the same thing as its meaning in English Language.
Do you really mean transfer or transformer?

It depends. I had replied to a duplicate post here before I came across this one. Realizing that the other post was in the wrong forum, I had deleted my reply on that one and copied the reply over here, without paying attention to the OS. If it is a unix file then use UNIX newline . If its a dos fil...

No. But usually indices are created on keys for faster updates and retrievals.

The vice versa is also not important, i.e, if an index is set on a column, it does'nt mean it is a key.

I took your sample data and tried to read it as a fixed width file that reads three decimal columns. I had no problem. Here are my settings. Record Level Final Delimiter = End Record Delimitet = UNIX newline Record Length = Fixed Field Defaults Delimiter = None Quote = None On the Columns tab, all t...

You can use DaysSinceFromDate() or convert the dates to Ordinal dates and subtract them. Both will give you number of days between the two dates. Then divide the number by 30.46 to get a close approximation.

Go to parameters tab in job properties, you will find Add Environment Variable bottom right, click on that and hit on New. Follow the commands then.

Actually, picking up from Craig's suggestion, write a Basic routine which sends mail using DSSendMail() and consider doing this in a server job. If you are sending two emails per record, I am guessing you dont have huge amount of data, yes ???
Simply do this in a server job.

Specify Record Length as "Fixed" and see if that helps. Also try specifying Record Delmiter as "DOS newline."

How did these RT_LOG's become orphaned in the first place?
Export your entire project to a dsx file, drop the project, create a new one and then re-import the jobs. This will ensure a clean, safe removal of such files.