Search found 42189 matches

by chulett
Mon Mar 27, 2006 7:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: reset the job and run
Replies: 6
Views: 1063

Re: reset the job and run

That wasn't really the question, Kumar. say my 3rd job fails in the sequencer,the next time when I run it should run from 3rd job. Simple - checkpoints. Look on the General tab of any Sequence job for the following options: * Add checkpoints so sequence is restartable on failure * Automatically hand...
by chulett
Sun Mar 26, 2006 2:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: so* directories or opf* files within DataStage Project dir
Replies: 5
Views: 2860

The Sort stage in Server jobs has a property to control the location of its temp files. Unfortunately, it defaults to being empty and that means they wind up in the 'current working directory' i.e. the Project. I'm always on the lookout for them as they mean someone has forgotten the rule we have th...
by chulett
Sat Mar 25, 2006 11:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML output
Replies: 3
Views: 1035

It will be in the 'Docs' directory under where you installed your client along with all the other pdf documents that ship with the product.
by chulett
Sat Mar 25, 2006 7:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML output
Replies: 3
Views: 1035

Hopefully you have an example .xsd for the XML output you need to create. If not that, then a sample xml file you can generate one from using a tool like XML Spy. From that you import the metadata into the Manager, this will give you the XPath expressions you will need. Without that you'll need to t...
by chulett
Sat Mar 25, 2006 7:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Extract COBOL file data using CFF
Replies: 7
Views: 4307

From what I've read here, comments seem to confuse it... best to remove them, especially around an area of redefines.
by chulett
Sat Mar 25, 2006 7:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple source files single ETL
Replies: 33
Views: 8464

No, I think Ray meant exactly what he said. I'm assuming the intent with the piped pair of commands would be to first get everything but the first line and then everything but the last line. When you're done, all you've got left is the creamy goodness in the middle of the cookie. With yours, Kumar, ...
by chulett
Sat Mar 25, 2006 1:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Invalid Arguments when run from command line
Replies: 10
Views: 2046

Re: Invalid Arguments when run from command line

kaps wrote:I took the piece of code which assigns the parameters from parameter file from one of the post here...

You've posted the same thing here and at ADN and both times said it was a post 'here'... which here is here? Can you provide a link to the original post? That may help clear things up.
by chulett
Sat Mar 25, 2006 1:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Passing parameter out of datastage job
Replies: 21
Views: 34623

Odd... seems you posted that over nine hours after I did. I don't see any timestamp issues, but then my acoustic coupler is probably seated a little tighter than yours. :wink:
by chulett
Sat Mar 25, 2006 12:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple source files single ETL
Replies: 33
Views: 8464

Can I use Job Parameter to pass 'ABC'...'XYZ' as i mentioned to 'filename'. so that it will become 'filename_ABC' ....'filename_XYZ'..? I am using SEQ file stage. Sure - you can parameterize as much of the filename as you need. Typical parameter usage would be one for the directory the file lives i...
by chulett
Sat Mar 25, 2006 12:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML message
Replies: 2
Views: 571

Are all what things possible in Server? Create XML? Sure. Use a field as a repeating group? Sure. Aggregate values? Sure. Limit output file size to 2MB? No, not exactly. The XML Output stage can be triggered to switch to a new file when the value in a certain field changes. It's on the Stage / Trans...
by chulett
Fri Mar 24, 2006 5:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Passing parameter out of datastage job
Replies: 21
Views: 34623

Now, that bit of advice sounds really familiar. :wink:
by chulett
Fri Mar 24, 2006 12:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Is There any way to abort a job after 50 warnings
Replies: 16
Views: 3424

I dont think you can do that at the job level. Forcing a job to abort inside the job, never heard of it, and cant think of any way to do it. It's a propery of every constraint. You can change the 'Abort after' value from zero rows (which means never) to a specific number - and when that many rows h...
by chulett
Fri Mar 24, 2006 10:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: JOB report on Category/Folder
Replies: 18
Views: 4521

Ah... that's what you get when you run it from the 'Status' view in the Director. For the gory details, you need to run it from the 'Log' view instead.
by chulett
Fri Mar 24, 2006 10:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: JOB report on Category/Folder
Replies: 18
Views: 4521

You missed something. :wink: It's all there - as long as you select 'full details'.
by chulett
Fri Mar 24, 2006 9:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: JOB report on Category/Folder
Replies: 18
Views: 4521

If this is a 'where do I find it in the log' question, that information is in the 'finishing...' log records for each active stage: blah-blah: DSD.StageRun Active stage finishing. 105 rows read from Something 105 rows written to Somewhere 105 rows written to SomewhereElse 0.080 CPU seconds used, 1.0...