Search found 53125 matches

by ray.wurlod
Wed Feb 16, 2011 4:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Throttling performance on a grid?
Replies: 12
Views: 4908

You can certainly create a configuration file that requests fewer nodes than usual, but you can't prevent "them" from starting zillions of jobs each of which will dynamically request that number of nodes from the grid. Some grid management software will let you throttle the number of nodes...
by ray.wurlod
Wed Feb 16, 2011 4:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How do we prevent importing "unicode" Extended opt
Replies: 8
Views: 5259

When importing the table definition (at least for a sequential file) you can set the NLS map to NONE. This will prevent every string data type being flagged as Unicode because (for example) the default map being set to UTF-8.
by ray.wurlod
Wed Feb 16, 2011 4:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to find the group of jobs using the same Dataset
Replies: 4
Views: 4038

Assuming that you saved/loaded the DataSet table definition (which we all do, right?), it's as easy as performing a "where used" analysis on that table definition.
by ray.wurlod
Wed Feb 16, 2011 4:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to convert the packed decimal fields to string
Replies: 3
Views: 2500

Have you done a search of DSXchange for "packed decimal"? In those posts you will learn how packed decimal storage is organized, and some code for unpacking the same. You ought never to need to look at them.
by ray.wurlod
Wed Feb 16, 2011 3:01 pm
Forum: General
Topic: Code Quality Tool for DataStage
Replies: 6
Views: 6268

At all of the sites where my company is engaged a set of standards is established early in the project, and a peer review process, aided by a checklist, is used for design quality assurance.
by ray.wurlod
Wed Feb 16, 2011 2:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Load last 2 Entries
Replies: 14
Views: 4176

Use Head stage for first record(s), Tail stage for last record(s).
by ray.wurlod
Wed Feb 16, 2011 2:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Define New Column
Replies: 6
Views: 4499

Build stage, External Filter stage, just off the top of my head.
by ray.wurlod
Wed Feb 16, 2011 2:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: same hash file usage in multiple batch jobs
Replies: 10
Views: 4171

It's a hashed file, not a hash file.
:x
by ray.wurlod
Wed Feb 16, 2011 2:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DAT file
Replies: 14
Views: 7417

Ask about DIS file as well.
:lol:
by ray.wurlod
Wed Feb 16, 2011 2:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to convert the packed decimal fields to string
Replies: 3
Views: 2500

What does "special" mean?
by ray.wurlod
Wed Feb 16, 2011 2:44 pm
Forum: General
Topic: orchdbutil fails
Replies: 7
Views: 3358

Check also that APT_CONFIG_FILE and APT_ORCHHOME are set.
by ray.wurlod
Wed Feb 16, 2011 2:41 pm
Forum: IBM QualityStage
Topic: Which columns for standardizing names using USNAME rule set?
Replies: 13
Views: 6795

Custom rule sets can be used as often as necessary. It is better, therefore, if some thought has gone into their construction, particularly about handling conditions as generally as possible.
by ray.wurlod
Wed Feb 16, 2011 1:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Throttling performance on a grid?
Replies: 12
Views: 4908

Electrify their keyboards when you want them not to work.
:lol:
by ray.wurlod
Wed Feb 16, 2011 1:19 am
Forum: General
Topic: Job names not appearing on repository
Replies: 10
Views: 4337

Search DSXchange for "DS.REINDEX"
by ray.wurlod
Wed Feb 16, 2011 1:17 am
Forum: General
Topic: I'll take "Shakespearean Transformation" for 800..
Replies: 3
Views: 1525

Question - but there's also IsNotNull() :wink:

Players - unless they're section leaders or the conductor.