Search found 53125 matches

by ray.wurlod
Fri May 23, 2008 6:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Command for scheduling
Replies: 11
Views: 2230

What else can you tell us about DSSched ?
by ray.wurlod
Fri May 23, 2008 6:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Email sending with attachment
Replies: 10
Views: 2990

Yes. Either send to a "list" address (everyone@domain.grg) or use multiple recipient addresses. The separator character between these may be space, may be comma, may be semi-colon; it depends upon your mail server, not upon anything in DataStage.
by ray.wurlod
Fri May 23, 2008 6:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Diffrent Link Names and Purpose in PX
Replies: 7
Views: 1911

Names: you should adopt and maintain a naming convention for DataStage objects, including links and stages. When you go to another employer you may well find that a different convention is in place. So long it is systematic, meaningful, reasonable to use and maintain, it is a good naming convention....
by ray.wurlod
Fri May 23, 2008 6:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Does it required to install C++ to compile parallel routines
Replies: 1
Views: 706

There is no "compiler that comes by default with installation of Enterprise Edition".
by ray.wurlod
Fri May 23, 2008 6:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date Extraction
Replies: 8
Views: 1496

Without the "#" characters. Use the expression editor to build the expression, particularly to add the job parameter name, to see what I mean.
by ray.wurlod
Fri May 23, 2008 5:56 am
Forum: General
Topic: copy datastage projetc
Replies: 9
Views: 5991

It's the only way, unless you want to have to repair stuff afterwards. Well, of course, that's an over-simplification, and indeed there are other documented ways such as using the export/import capabilities of the FORMAT.CONV command or using the uvbackup/uvrestore utilities, but I don't consider th...
by ray.wurlod
Fri May 23, 2008 5:53 am
Forum: General
Topic: Get event Id based on Job start Time Stamp
Replies: 2
Views: 1338

Code: Select all

SELECT * FROM RT_LOGnnn WHERE TIMESTAMP >= 'yyyy-mm-dd hh:mm:ss' AND FULL.TEXT LIKE '%Started%' ORDER BY TIMESTAMP;
is one way.
by ray.wurlod
Fri May 23, 2008 5:51 am
Forum: General
Topic: Fetch First event Id
Replies: 7
Views: 2071

The event ID is not randomly generated. It is generated by incrementing a control record called something like //NEXT.SEQUENCE.NO in the log table.
by ray.wurlod
Fri May 23, 2008 5:49 am
Forum: IBM QualityStage
Topic: scheduling from standardization to undup
Replies: 2
Views: 1036

Re: scheduling from standardization to undup

vairus wrote: But, in the sequence job i can't include the match specification !

Why not?
Is there a particular error message generated? If so, what is it?
by ray.wurlod
Fri May 23, 2008 5:48 am
Forum: IBM QualityStage
Topic: Match Designer Match Pass run failed
Replies: 4
Views: 2016

Please add a post indicating, for future searchers, HOW this problem was resolved.
by ray.wurlod
Thu May 22, 2008 11:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing variables and parameters from unix script into DS
Replies: 1
Views: 795

Yes.

You can.

Precisely this question has been answered less than two weeks ago. Search for the question and answer.
by ray.wurlod
Thu May 22, 2008 9:39 pm
Forum: IBM QualityStage
Topic: running QS job from unix
Replies: 13
Views: 3699

Can you find any reference to this directory pathname (or its parent's) anywhere in the Scripts directory? I think you need to get official support involved in this one - it's beginning to smell like a bug.
by ray.wurlod
Thu May 22, 2008 9:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: error sequential file
Replies: 3
Views: 1229

There is a comma (your delimiter character) within your data at an unexpected location. You need to deal with it. Either convert the comma to something else, or use a different delimiter character (such as tab) that does not appear in your data.
by ray.wurlod
Thu May 22, 2008 9:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Right allign
Replies: 7
Views: 1817

The Transformer is the only stage possible without going to an External Filter or some other external mechanism. For 30 columns you set up 30 derivation expressions. You could encapsulate the logic in a routine, but you would still need 30 derivation expressions each of which invoked that routine. T...
by ray.wurlod
Thu May 22, 2008 7:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how can i kill a job from DSTOOLS on windows 2003 server?
Replies: 3
Views: 1355

Neither is DS.TOOLS executed from the operating system.

You asked about killing a job from DS.TOOLS - which is a menu, with an option for doing so.