Search found 53125 matches

by ray.wurlod
Mon May 07, 2012 4:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Occurs Functionality through CFF stage
Replies: 11
Views: 4502

Welcome aboard. Yes, the Complex Flat File stage can process these data. Import the COBOL FD then use the imported table defintiion in the CFF stage. You could also do this with a Sequential File stage by creating appropriate table definition. ProcCode Char(5) ProcTypeOf Char(2) ProvClassifCd1 Char(...
by ray.wurlod
Mon May 07, 2012 3:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: CHAR function Clarification
Replies: 5
Views: 2230

Are you sure? (Is this a server job (as posted) or a parallel job (as marked))?
by ray.wurlod
Mon May 07, 2012 3:54 pm
Forum: General
Topic: Query reagarding Sequencer
Replies: 7
Views: 3122

Detect anything that job C does. If it's not present job C never completed successfully.
by ray.wurlod
Mon May 07, 2012 3:52 pm
Forum:
Topic: Business Glossary Workflow Comments
Replies: 6
Views: 1957

The site at which I'm currently working use the Notes field to record the original author, since a term can be suggested by any of the 30000+ people in the organisation. The Notes field carries through to the Published glossary. That said, I do believe there's a better way to do the whole governance...
by ray.wurlod
Mon May 07, 2012 2:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Aggregator stage
Replies: 3
Views: 1494

Sum them separately then sum the results. You can't do it in a single pass unless you've calculated (col1 + col2) upstream of the Aggregator stage.
by ray.wurlod
Mon May 07, 2012 12:13 am
Forum: General
Topic: Query reagarding Sequencer
Replies: 7
Views: 3122

Curiously what you need is a Sequencer. A Sequencer is one of the activity types you can use in a Sequence. Job_A ---> Job_B --------> Job_C | RunC | | | |NoC | | | +--> Sequencer <--+ (any) | | V Job_D ---> Job_E
by ray.wurlod
Sat May 05, 2012 4:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Partition & Pipeline Parallelism
Replies: 2
Views: 1463

Whether in sequential mode or not, a parallel job executes logically as op0 | op1 | op2 | op3... So pipeline parallelism is a given. Sequential mode simply means that the operator processes each executes on a single node. Data actually move through virtual Data Sets. There is one of these per link. ...
by ray.wurlod
Sat May 05, 2012 1:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: hanging the datastage job
Replies: 1
Views: 1221

When the job is hanging is it consuming CPU or not? That wil give some clue as to the cause.
by ray.wurlod
Sat May 05, 2012 1:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: unprintable characters
Replies: 6
Views: 3545

You need to know what codepoint em dash uses.
by ray.wurlod
Sat May 05, 2012 1:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Handling New Line within a column while reading
Replies: 9
Views: 2390

The newlines are part of the client's data. You can't arbitrarily delete them!
by ray.wurlod
Sat May 05, 2012 1:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: CHAR function Clarification
Replies: 5
Views: 2230

Char() function is always ASCII. If you need to process NLS characters prefer the UniChar() function.
by ray.wurlod
Sat May 05, 2012 1:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Capture Skipped records
Replies: 4
Views: 1754

Wrap the derivation of the output key value on the reject link with a function (routine) that you have to write to log a warning message associated with that key value. The routine returns its argument unchanged, so that it can be put out on to the reject link.
by ray.wurlod
Fri May 04, 2012 12:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Max inbound connections per node = 32
Replies: 2
Views: 1993

Not enough information. What stage types are involved? How many nodes in the configuration file?
by ray.wurlod
Fri May 04, 2012 12:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to convert JULIAN DATE to DATE using schema file
Replies: 5
Views: 2863

Are you sure you've tried "%yyyy%ddd"? Your initial post specified "%yyy%ddd".
by ray.wurlod
Fri May 04, 2012 12:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Handling New Line within a column while reading
Replies: 9
Views: 2390

jerome_rajan wrote:But looks like I cannot select the server sequential stage in my parallel job. Either it has been disabled or I am missing something. Your advice would be much appreciated.
Read what I wrote again, carefully.