DSXchange

Kirtikumar wrote:I already had once created such routine for one my X assignments Craig!!!

Me too!!!

Not what I meant. If you click on the OP's handle and then do a 'Find all posts by', you'll see that the last umpty posts they have made have all been about a Quest For Log Files. It's been... interesting.

How about enlightening us with the 'why' behind the question... why do you think you need to do this?

And the article I linked to.

You must also have the privilege of owning the 7.5x2 version of DataStage.

If all of this is in one job, then you can't control the restart like you would like. If you break it up into three separate jobs, and run those jobs in a Sequence job (even in parallel) you can do what you want.

You are right. we are creating files on unix and emaling to windows. Actually, what I said was you are creating a UNIX file, not creating files on UNIX. Different thing and as Ray noted, it's all about the record terminator you've chosen in the stage. Change it to 'DOS' so it uses CR/LF pairs rathe...

Kirtikumar wrote:Rajan, have you written or using a routine to read the log files and then building the normal file from it?

I guess you haven't been following this little... 'exercise', eh?

Excellent... then my answer stands. Ditch the commas.

Why did I get a strange sense of deja vu when I read your post?

Why in the heck are you running around, replying to ancient posts?

There's no need to add this bit of advice to every dang post you can find here...

I would guess you are creating a UNIX file and then emailing it to your Windows machine. Try creating the file as a DOS file instead.

And now, at 6:38PM they start showing up again. Go figure.

Or a Solaris thing. No such shenanigans required on H-PUX. Glad you got it worked out. :D

The correct syntax for Convert would actually be: Convert('$@!%#','NNNNN', DSLink3.SPEC_CHAR) No commas... unless you want those replaced as well... with another comma. I'd still like to see examples of these 'special characters' before people go too crazy with the suggestions... Edited to a...

Nope. Turns out to be a wrong choice of terminology... as noted later, the OP is actually attempting CDD.