DSXchange

True, missed the 'into a Directory' part. Told yah I hadn't really looked at it. So... other than that, perfectly valid advice.

Probably need another patch.

samsuf2002 wrote:u tryu using after job sub routine where u can truncate the table after the job is processed

What?

Titto - you need a two step process. First select and land the records from the table. Then a separate job to truncate and reload. Two steps.

Clear Seqfile? Not sure what you are asking. All you need to do to use these routines is understand how they work and then just... use them. SeqFile is not 'a file in common storage' per se, but the name of the 'Sequence File' in use - i.e. the SDKSequences hashed file - from what I recall.

while i complie the job i'm getting an errot which says Job contains cyclic or linear dependencies and will not run Short answer is that you've created a 'loop' in your jobstream. Rather than data flowing from one end to the other, you've got it looping back on itself somehow. The compiler catches ...

Welcome. :D You've certainly chosen a non-trivial task for someone 'very new' to DataStage to tackle. It may be mitigated somewhat, however, by sticking with the 'dsjob' utility which basically turns this into a scripting exercise. Read the Command Line Interface section of the Server Job Developer'...

Who man? Apparently he man but not me man. Sorry.

You get to write everything yourself!

Do you own the TX product as well? You must in order to use this stage. And if so, probably best to also ask over in the TX forum...

These are the result of bringing the engine down with client connections currently open. Sometimes that's unavoidable because of broken connections, but you should always make an effort to ensure everyone is off that can get off before it comes down. They should clear themselves with time. We're run...

Technically, 'filters' and 'wildcards' are not equivalent. However, wildcards can be used with more than just the splat - '*'. For example on UNIX:


Will get you just file1.txt and file2.txt out of the '100 files in that folder'.

No... as it doesn't read 'records' but the full file contents all at once. And the derivation isn't used in this stage AFAIK, one of the joys of a standard 'widget' - not all fields are applicable everywhere it is used.

I haven't checked everything, just wanted to make a couple of comments since we're exposing code to the world. I tend not to use multiple steps when a single step would do just as well, hopefully without 'over-loading' the statement into obfuscation. For example, this: FileName = JobName:"_&quo...

Make sure you understand what exactly Transaction Grouping does before you go too crazy using it everywhere. It forces a Transaction Size of 1 and commits every 'group' of input links one at a time. That way you can rollback all of each 'transaction' if any one part of it fails. So it can be useful...

There is that. Curiousity... yah, that must be it.