DSXchange

"jobname.$JobName"? :? That should be the name of the first job, either hard-coded or you can use that syntax if "jobname" is the name of the first Job Activity stage. How are you handling the downstream jobs, trigger expressions? If so can you post them? If you are unsure what y...

And what 'same problem' would that be, exactly?

Have you tried creating the hashed file with Varchar keys? And can you please verify that whatever column layout was used to create / populate the hashed file is identical to the columns used in the lookup?

Sounds like a google for "how to backup db2 database" is in order. I'm sure whatever you'd need is already there.

As long as you don't make me tell bad jokes too, I'm cool with that. :D

There are only so many things that cause a hashed lookup to fail when you think it shouldn't. First and foremost is a data mismatch as noted, primarily a string trimming issue. Second is typically from using different metadata in the lookup when compared to how the hashed file was created - people s...

Hmmm... did you generate all of the 'child' bits as chunks? They shouldn't have anything header-wise before the final merge.

Still happens... and now that I have The Power, I clean them up as I find them.

Of course.

I'd wager you are missing a soft link from where the file actually is to where DataStage is expecting to find it. I've seen it, the solution is posted here somewhere or you can involve your official support provider.

My Sequence job is like from CSV file1-->transformer-->database table and my loop is designed as Start loop-->call the sequence job-->end loop in start loop I manually added file names as file1.csv,file2.csv.......etc i.e separated by comma And? It's been long enough that I have no idea what your q...

This sounds completely different to me, what with connectors for source, lookup and target. Increasing the heap size is probably just delaying the inevitable and sounds more like a workaround than a solution to me. [shrug]

Could be a bug with the Connector stage, me thinks.

Post your syntax and (for grins) specify your operating system.

OK, if that's the case then you need to have a chat with your DBA.