Search found 53125 matches

by ray.wurlod
Tue Aug 28, 2007 4:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while running the job through Unix scripts
Replies: 2
Views: 945

Post the full syntax of your dsjob command, and also a complete list of the job's parameters (dsjob -lparams project jobname).
by ray.wurlod
Tue Aug 28, 2007 4:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: accesing hashfile -doubt
Replies: 9
Views: 2175

How wide are the rows?
If 3 lakh * (rowsize) << 2GB then you are OK.
If not, you need to create your hashed file with 64-bit addressing.
by ray.wurlod
Tue Aug 28, 2007 4:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Mod 10 Check Routine
Replies: 9
Views: 2778

:!:
Beware that some credit cards (e.g. Diners Club) are 14 digits.
by ray.wurlod
Tue Aug 28, 2007 4:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Setting order of execution of two different flow in a single
Replies: 6
Views: 1055

:idea:
Always push back on illogical requirements.
by ray.wurlod
Tue Aug 28, 2007 4:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Route duplicate and non duplicate records from flat file.
Replies: 10
Views: 3123

The hashed file (or UV table) requires two key columns in my solution.
by ray.wurlod
Tue Aug 28, 2007 4:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to load subroutine on host (30105
Replies: 19
Views: 13298

Copy DSG_BP.O from one of the good projects into the Dev project.

Let us know whether that fixes matters.

Then find out who deleted DSG_BP.O and castigate them severely.
by ray.wurlod
Tue Aug 28, 2007 4:27 pm
Forum: General
Topic: Oracle Enterprise Stage performance issue
Replies: 2
Views: 1313

In particular it's running queries against Oracle system tables to try to ascertain whether the table is partitioned and, if so, by what method.
by ray.wurlod
Tue Aug 28, 2007 1:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: PX Job with C Routine aborts
Replies: 4
Views: 1416

For whatever reason your shared library search path is not being updated to include the location of your routine's library/object file.

Or is it that you're using an incompatible C++ compiler?
by ray.wurlod
Tue Aug 28, 2007 1:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: PX Job with C Routine aborts
Replies: 4
Views: 1416

For whatever reason your shared library search path is not being updated to include the location of your routine's library/object file.

Or is it that you're using an incompatible C++ compiler?
by ray.wurlod
Tue Aug 28, 2007 1:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: validation routine
Replies: 1
Views: 831

You have not provided a clear requirement. What is a "field" in your context? Start by writing a specification of your input(s) and required result. That ought to help clear in your mind what you need to do - and maybe even convince you that you probably don't need a routine.
by ray.wurlod
Tue Aug 28, 2007 1:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to load subroutine on host (30105
Replies: 19
Views: 13298

You appear to have an incompletely-installed project. Some vital entries are missing from the VOC file. To ascertain which these are, please do all of the following. 1. Create a pointer to the VOC file in another project. SETFILE /path/of/other/project/VOC otherVOC 2. Create a Select List of verbs i...
by ray.wurlod
Tue Aug 28, 2007 1:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Route duplicate and non duplicate records from flat file.
Replies: 10
Views: 3123

I still like my solution.
by ray.wurlod
Tue Aug 28, 2007 1:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Common Memory performance - read/write
Replies: 12
Views: 2414

You re-open the file each time you need a new range. If you put the file variable into COMMON as well, the file can be held open for the duration of the job. $INCLUDE UNIVERSE.INCLUDE FILEINFO.H * Variable vOpenFile is in COMMON If FileInfo(vOpenFile, FINFO$IS.FILEVAR) Else Open vSequenceFil...
by ray.wurlod
Tue Aug 28, 2007 1:06 am
Forum: General
Topic: Job Hanging.
Replies: 17
Views: 5002

Whose problem are we currently addressing, pagerakesh's or vinodhraj's? This is why we frown upon hijacking threads!
by ray.wurlod
Mon Aug 27, 2007 4:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 0 rows transferred
Replies: 5
Views: 1535

Don't rely on the GUI, for a whole heap of reasons.
Use the job log or monitor for a definitive row count.