DSXchange

Hmmm... could you post details of your job design, including what your source is and what settings you are using in the Folder stage? I'd also be curious what 8.x version you are running.

Are you perhaps reading it from your source as a CHAR? You are correct that it should only preserve any existing trailing spaces and not add anything to the data when it is sent to Oracle.

D'oh! That's what I get for just looking at the pictures when I should have been reading the articles.

#3 would have been excellent information to include in your original post, don'tcha think?

From what I recall reading in a Vincent blog - 8.5. It was listed as one of the reasons to upgrade.

I'm going to pull this one thing from Ernie's comprehensive post so you can see it, a link:

http://dsrealtime.wordpress.com/2007/12 ... ormations/

Yikes. That routine looks... overly complex and requires a ton of specific parameters be added to each job. Sridhar, I'm concerned you've chosen a route that you say you are not proficient in, that being UNIX shell scripting. That's what you would need to if you wanted to break a "Job Report&qu...

Which doesn't really change the answer you were given. You still need to pivot the data and then remove the duplicates, you just need to add a step to filter out the records with a null postal code between them.

I believe the second question may actually be "has the job ever run before?".

OK... getting some of the values will be pretty simple, like start time and end time for example. However, with no naming conventions that I can see for the stages and especially for the links, how will you recognize which are which? Until you start naming things consistently (like all reject links ...

MathBlade wrote:First, if this is in the wrong place my apologies, I'm a bit new to posting on DSXChange. I'm an avid reader of it though.

No worries - topics on things like writing routine code belong in the General forum and so... here we are.

Post the full contents of one of the job reports.

Sorry but why do you think you need to 'grep' them? For what purpose? Perhaps if you explained in detail what exactly you are trying to accomplish, we could do a better job of helping you get there.

bobbysridhar wrote:i am not able to get the files specific to that sequence and club them to one file.there I got struck.

I don't see the need to "club" them together at all. Can you not simply load them all using a File Pattern?

bobbysridhar wrote:In tfm but still not getting total records are 0.

... and you won't. Zero records in = zero records out. That's why you can't do this in job but should (as I already noted) do it as a separate process after job.