Search found 53125 matches

by ray.wurlod
Sat Jan 15, 2011 4:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Handling rejected data
Replies: 5
Views: 2662

What is the desired format of the target table that receives the rejected records and associated information (in particular, what are you using for its key)? Some more information about the "business rules" you need to test would probably be useful as well.
by ray.wurlod
Fri Jan 14, 2011 2:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conbine Records Stage
Replies: 3
Views: 2271

Start by enabling RCP and allowing DataStage to generate the schema on the output of the Combine Records stage. Then take a look at that schema. Not sure what your upstream stage is - look in the score to determine whether it is using consecutive modify operators - if so, do as the message suggests ...
by ray.wurlod
Fri Jan 14, 2011 2:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Rejecting Null values during file import
Replies: 3
Views: 5177

Set the Null Field Value property in the Sequential File stage. Filter out the rows with Col1 is null in a downstream Filter or Transformer stage.
by ray.wurlod
Fri Jan 14, 2011 2:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Services with Datastage 8.1
Replies: 1
Views: 1094

Yes; it's name has changed to WISD (or just ISD). Deployment and control of services is managed differently, because the W in WISD is "WebSphere". But it's well described in the manuals and you could even search DSXchange because I'm sure Ernie Ostic has explained the process on at least o...
by ray.wurlod
Fri Jan 14, 2011 2:30 pm
Forum: General
Topic: Job from command prompt
Replies: 12
Views: 3893

Execution-wise Batch:: is just the same as a sequence job which, in turn, is the same as a server job that contains no stages but only a job control routine.
by ray.wurlod
Fri Jan 14, 2011 2:26 pm
Forum: General
Topic: Scratch and Temp directory files
Replies: 4
Views: 1635

As a general rule anything can be removed from scratch that does not relate to a currently-running job. You're right that they should be removed automatically, but when a job aborts this does not always happen. The machine log files in the temp directory and/or your home directory should be archived...
by ray.wurlod
Fri Jan 14, 2011 2:25 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Execute Column Analysis in IA
Replies: 13
Views: 6144

Using the web console for Information Server, can you view the log for the DataStage project (presumably ANALYZERPROJECT)?
by ray.wurlod
Fri Jan 14, 2011 2:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: performance and capability
Replies: 2
Views: 1437

Better for what?

Each has its specific purpose.
by ray.wurlod
Fri Jan 14, 2011 2:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Field defaults Quotes In Sequential File stage
Replies: 6
Views: 3075

Yes, multiple quote characters are treated as alternates, rather than as a single "quote" designator. Read your data unquoted and clean up subsequently, or get the data provider to supply data that conform to one of the industry standards, such as CSV.
by ray.wurlod
Fri Jan 14, 2011 2:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: difference between V7.5.1.A and 7.5.3
Replies: 9
Views: 2802

None, but I bypassed 7.5.3, going straight from 7.5.2 to 8.0.1 (and soon after that to 8.1.2).
by ray.wurlod
Fri Jan 14, 2011 2:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job error
Replies: 4
Views: 3420

No idea. Contact your official support provider. Somewhere they will have the source code that will make the stack trace meaningful.
by ray.wurlod
Fri Jan 14, 2011 2:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential file delimiter
Replies: 8
Views: 2668

If the three-character string "|" is your delimiter string, set the quote character to none. If the single character | is your delimiter and character strings are quoted with " then set the delimiter to | and the quote character to double. Either will work. However, if you want to hav...
by ray.wurlod
Thu Jan 13, 2011 8:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: multiple recs through looping
Replies: 3
Views: 987

How many times are you going to post this question ?!!!!!
:x
by ray.wurlod
Thu Jan 13, 2011 8:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parent in hierarchy
Replies: 5
Views: 1499

Server job (as posted) or parallel job (as marked)? Are you seeking to construct this hierarchy or to read from it?
by ray.wurlod
Thu Jan 13, 2011 8:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential File
Replies: 19
Views: 20686

Premium membership is the main way that the hosting and bandwidth costs of DSXchange are met. It's not expensive, at less than 30c per day. So, instead of me undermining the continued existence of DSXchange, why don't you obtain a premium membership?