Search found 53125 matches

by ray.wurlod
Tue Jun 02, 2009 11:36 pm
Forum: General
Topic: Detecting job restart within a Job Sequence
Replies: 12
Views: 5457

Can you show us how you got the "parent JS jobhandle"? I'm assuming you've applied DSAttachJob() to the name returned by DSJobController macro (or equivalent call to DSGetJobInfo(). The other way is to check for the existence of a CHECKPOINT record in the RT_STATUSnnn hashed file for the j...
by ray.wurlod
Tue Jun 02, 2009 8:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSPrepareJob ordering in a job control code
Replies: 5
Views: 3632

Did this message come from DSPrepareJob() or from DSRunJob() ?
by ray.wurlod
Tue Jun 02, 2009 8:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: user defined query error
Replies: 21
Views: 8712

If it's urgent get your official support provider to earn some of the money you are paying them. No-one here is guaranteed to answer quickly - they may be in a different time zone from you, and asleep. Basically we on DSXchange are all volunteers and cannot do "asap".
by ray.wurlod
Tue Jun 02, 2009 4:28 pm
Forum: General
Topic: Parameterset in Datastage 8.0
Replies: 11
Views: 10575

DSXchange Learning Center recently had a webinar on Parameter Sets. It can be viewed from the linked web site.
by ray.wurlod
Tue Jun 02, 2009 4:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: do you usually keep partitioning on "Auto" in your
Replies: 5
Views: 1778

DSXchange Learning Center has a server to parallel transition class available either in DVD format or as an instructor-led class.

Both IBM's and my advanced classes address the issues of best choice of partitioning algorithm.
by ray.wurlod
Tue Jun 02, 2009 4:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: connectivity to oracle
Replies: 5
Views: 2976

Re: connectivity to oracle

pavan_test wrote:I could not read the complete response
That part, at least, is easily remedied by your purchasing premium membership.

There are man pages on all UNIX commands including ldd.
by ray.wurlod
Tue Jun 02, 2009 4:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: See for Constraints in Transformer from Basic Routines
Replies: 2
Views: 1328

Moderator: please move to server forum
by ray.wurlod
Tue Jun 02, 2009 4:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Migration of DS7.1 to DS7.5.2:- Data quality issue
Replies: 10
Views: 4145

What was the corruption? How did you discover it? How do you think it happened? What steps have you take to prevent it from occurring again?
by ray.wurlod
Tue Jun 02, 2009 4:04 pm
Forum: General
Topic: Export DSX into IBM's Infosphere Data Architect
Replies: 9
Views: 11971

If this is Rational Data Architect, you shouldn't need to export anything. Just make the DataStage table definition a shared table definition so that other tools can access it in the unified metadata repository for IBM Information Server (there's got to be a shorter way to say that!).
by ray.wurlod
Tue Jun 02, 2009 12:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: fatal error C1083: Cannot open source file: 'C:Greatest.c':
Replies: 1
Views: 1880

Windows pathnames need backslash. In particular, one is mandated following the drive letter specification. For example "C:\Greatest.c".
by ray.wurlod
Tue Jun 02, 2009 12:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Checking non printable and extended characters
Replies: 5
Views: 2125

If you want to replace every extended character with a space, then svReplaceChars needs as many space characters as there are in svExtendedChars. If there are fewer, then unmatched svExtendedChars characters are replaced with "", effectively deleting them.
by ray.wurlod
Tue Jun 02, 2009 12:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Look up is vey slow
Replies: 5
Views: 1951

Here are the three main ideas for getting the best out of write performance with hashed files. Critically examine what rows and columns are loaded into the hashed file, and eliminate any that are not required. Pre-size the hashed file using MINIMUM.MODULUS setting (get an approximate value from the ...
by ray.wurlod
Mon Jun 01, 2009 7:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Checking non printable and extended characters
Replies: 5
Views: 2125

Because you've included Char(128) which is the internal representation of NULL.
by ray.wurlod
Mon Jun 01, 2009 7:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: clarification on external filter
Replies: 1
Views: 1019

The answers you seek are in the manual. (a) There are restrictions on the commands that can be executed, but in summary the commands that are used must be "pipe safe". (b) "*.ds" files are Data Set descriptor files. They are binary files. You should never attempt to process these...
by ray.wurlod
Mon Jun 01, 2009 7:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sort before lookup/cdc
Replies: 7
Views: 2519

Did you Search? This has been explained in the past. In short, though, it is to minimize demand on memory. The Lookup stage does not require, and can not benefit from, sorted inputs. The Join stage requires sorted input. The Merge stage requires sorted inputs but can tolerate unsorted master input. ...