DSXchange

....and for this very reason, I requested the OP to provide sample data for clarity.

Well yes, thats what I meant. The sequential file stage will read the entire file but process can be written to then , depending upon the instance, process different chunks of records.
I have done something like this in the past, using Instance number and
@INROWNUM.

Sure you can. You can read different amount of records and run multiple instance job on it. Look into @INROWNUM.

pravin1581 , for more clarification, give us a couple of records from both the files and how it will look after transformation.

Just for debugging purposes, if you make the job "not readonly" and "not protected" in the new environment and re-run it, do you still see this error?

chulett wrote:And as long as you don't get all crazy on us, we'll help here too.

A good laugh in the morning
I concur with Craig's advice. Its better to go through a good book for shell scripts. Get it right from the core. Start building small snippets of code. For specifics, google will help, etc etc.

Check for that field inside the transformer and if empty, send it down a reject link.

Food for thought
- Identify jobs that really require conversion
- Understand whats going on in that server job.
- Translate it into parallel job.

You need in depth understanding of both server and parallel editions for this.

Use Modify stage or transformer stage. It allows you to convert to and from different formats.

Or let your admin take care of that.

Me know that. Was just playing along the 'tricky part'

I think its case specific. Type in all caps DS.CONNECT

Do you want to replace the Month part and the yyyy part automatically or provide parameter values to them. The latter is easy. But for the former you will have to do OCONV() on Date() to get Month as you require and the OCONV() on Date() with conversion code "DY[4]" for yyyy, in the derivation of jo...

Ok. Lets get your output right first before appending the + sign. Just put DecimalToString(in.field). It has a second argument as well. Read about it in DS help and specify the correct one. Once you get that working, your Index() check for - will work and the + sign will get appended. Also make sure...

Once your inside uv prompt. Log onto your project by supplying the following command

Replace <<Your Project Name>> with your project name and then try executing DS.TOOLS again.