DSXchange

Provided viewing of generated OSH is enabled in the project, you can view the generated OSH from the Generated OSH tab in the Job Properties dialog.

Why not include an ORDER BY clause in the extraction SQL then, in your Sort stage, you can set the sort mode to "don't sort (already sorted)". No scratch space is taken by such a Sort stage.

There IS scheduling information somewhere in XMETA. I infer this because many products (not just DataStage) can use "the IFS schedule in IBM Information Server".

vsi wrote:Hi, Iam also getting same problem while loading in seq file, did u got any resolution for this, please let me know.

Thanks,
VSI

U did not report any problem.

The second person personal pronoun in English is spelled "you".

First impression is that there is a mismatched quote.

... or simply rewind the date until it is valid.

Right. Go over the dreaded '2GB Barrier' and performance is dramatically affect because the hashed file will corrupt internally. Then, as noted, it's time to switch to 64bit hashed files. Close, but no cigar. The right time to switch is before the hashed file gets to 2GB. This means that you monito...

10000 posts from the fingers of Arnd Wussing. Way to go (wherever you are)!

Welcome aboard.

This question has been addressed over the past little while, so a Search ought to be the first thing you do.

Version 8.0 is hugely different from version 7.5, as your Search results will show.

Please post what the resolution was, even it was as simple as realizing that APT_NO_JOBMON means exactly what it says - no job monitoring.

Currently I don't believe so, but it impresses as a possibly useful idea. Why not formalize how you believe it ought to work, then post as an enhancement request?

You can create a Sequencer simply by dragging its icon into a Job Sequence.

If you call your stored procedure in an ODBC stage all rows delivered to the stage will be passed as inputs to the stored procedure.

Run the UNIX command split over the file. Or, instead of outputting one 1800-character string, output an 1802-character string with two Char(10) characters inserted. Left(InLink.TheString,600) : Char(10) : InLink.TheString[601,600] : Char(10) : Right(InLink.TheString,600&...