DSXchange

What version of DataStage? I believe that you have to be up on at least 7.5 or perhaps even 7.5.1 for that to work correctly.

Don't know anything about ABAP or SAP but some generic advice...

After a job aborts, from the Director try doing a Reset of the job. Sometimes a log entry will be written with "From previous run..." in it and double-clicking on it will get you more details about the problem.

That's an interesting thought, Vincent. I'll have to play around with it. At this point, I still prefer to 'seed' things by either dragging the column metadata in from the Repository browser onto a link, or directly via the Load button inside the stage. The method depends on if I want blank derivati...

I don't use the 'Fully Generated SQL' option now and I wouldn't touch the 'SQL Builder tool' with a thirty-nine and a half foot pole. However, putting hints and other goodies in the first column's derivation works fine with the 'Column Generated' option in earlier versions and with the 'Generate SEL...

You are welcome.

Ok, stop SHOUTING. We hear you fine. Yes, Sequencer Jobs can be run from the Director just like any other jobs. No, normally no 'shell script' is required to run any kind of jobs, but you'll find that you will need one if you want a third party / Enterprise scheduling tool (like Control-M) to run th...

Nit Alert! - The 'Missing Column' rules are on the Format tab. The 'Incomplete Column' rules are the ones in the Column grid and there are three that throw a warning. Use Discard + Warn if you want to pitch the problem rows. Use those as long as you recognize that if enough warnings are generated fo...

If any way not to add jobs with ^1_1 strange end. I want three projects with the same names. Nothing strange, those are the Major and Minor version numbers for a particular job and only exist in the Version Control repository. When you 'promote' jobs to other projects that information is stripped o...

ray.wurlod wrote:A Row Generator stage would be more efficient.

Really? More efficient? Or just more PX'ian?

Reading an 'empty' file will produce exactly zero rows of output. If you want to create a job that writes out one row, then build a Server job that starts with a Transformer and outputs to your desired 'all values zero' file. Add a stage variable to the Transformer so the compiler doesn't bark. Add ...

To 'create a copy with the same name in different project' you have two choices, basically. One is Export/Import and the other is Version Control. I can do release job . Isn't it version contrl. No 'Releasing' a job is something old school and totally different. All you end up moving when you do tha...

Type it in.

Not until you upgrade to 7.x - otherwise, as Ray notes, there are third party tools like CompileAll that should still be around... somewhere.

I would think in a PX job that would happen automatically. The sequential file stage will reject any records with a metadata mismatch and since you will be using the metadata for the detail rows, that should mean any header and/or trailer records won't make the cut and will automatically be 'filtere...

What ever became of our File Library?