Search found 53125 matches

by ray.wurlod
Thu Mar 02, 2006 4:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ms_ole_db multiple row lookup
Replies: 27
Views: 5812

Code: Select all

        [___Hashed___File___Stage___]
             |      |      |      |
             |      |      |      |
             V      V      V      V
--->    [     Transformer Stage      ]  ---->
by ray.wurlod
Thu Mar 02, 2006 4:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null date in transformer
Replies: 14
Views: 5774

Is NLS enabled on this Job? If "YES" IsNull will not work for UStrings. Make sure that Date field is not Ustring. Is that fact (that IsNull() does not work for ustring when NLS is enabled) documented anywhere? As far as I was aware, IsNull() should work with any data type, whether or not NLS is ena...
by ray.wurlod
Thu Mar 02, 2006 4:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to call the PX routine in job control of DS PX job
Replies: 9
Views: 3088

But it can't call a parallel routine.
by ray.wurlod
Thu Mar 02, 2006 4:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dsjob.exe
Replies: 9
Views: 2244

dsjob.exe on UNIX ??
by ray.wurlod
Thu Mar 02, 2006 4:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ms_ole_db multiple row lookup
Replies: 27
Views: 5812

What you've actually got is the cleaner of the two approaches. You can bring all four reference links out of the same Hashed File stage. You can enable link public cache or even system cache for the hashed file. The nice thing about this approach is you can tell exactly which piece of the puzzle is ...
by ray.wurlod
Thu Mar 02, 2006 4:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ds_uvput() write failed for the record id '022947811'
Replies: 6
Views: 4173

Use the UNIX command ls -l hashedfilepath to report the size of DATA.30 and OVER.30. I would have expected different error messages if you'd corrupted the hashed file. Can you write other records to it? Perhaps the key value you've supplied contains a non-printable "mark character": these are not pe...
by ray.wurlod
Thu Mar 02, 2006 4:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: job name length
Replies: 3
Views: 1226

The maximum length for a job name by default is 768 bytes. This is because the job name is the key to the hashed file DS_JOBS. The maximum job name length is set by the MAXKEYLENGTH tunable in the uvconfig file. In current versions this is set to 768 by default. It can be increased to 2048, but ther...
by ray.wurlod
Thu Mar 02, 2006 3:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Slowness is kicking off jobs
Replies: 9
Views: 2928

If multiple jobs read the same parameter file using the same routine, only the one that actually owns the lock is reading it at any time. The others are queueing waiting for the lock to be released. There may be some sleep time involved in this, depending on how your particular operating system impl...
by ray.wurlod
Thu Mar 02, 2006 3:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ms_ole_db multiple row lookup
Replies: 27
Views: 5812

You find the corresponding value in the input stream, and put that column name in the reference key expression field.
by ray.wurlod
Thu Mar 02, 2006 3:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of stage
Replies: 14
Views: 3910

Address DE in the object code is associated with the source statement GET.Pin%%V0S1P5 which (from source line 33) maps to a GET (get next row) call on the main input link into the stage (link name zoph_arde_out) and which, from line 112, is a call to $DSP.GetNext. My main reason for wanting to see t...
by ray.wurlod
Thu Mar 02, 2006 12:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of stage
Replies: 14
Views: 3910

We need something from further down the "big log" - specifically what's happing at and around address DE.
by ray.wurlod
Thu Mar 02, 2006 12:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Exporting User-defined environment variables
Replies: 5
Views: 2759

That would be with a symbolic link (on UNIX, created with an ln command). On a Windows server you could use a "shortcut" - which really means the same thing.
by ray.wurlod
Thu Mar 02, 2006 12:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ms_ole_db multiple row lookup
Replies: 27
Views: 5812

Yes, but you want to see whether it EXISTS, so it should point to itself. The value from the input stream is then mapped onto this column via the reference key expression.
by ray.wurlod
Thu Mar 02, 2006 12:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Slowness is kicking off jobs
Replies: 9
Views: 2928

This is usually a symptom of machine overload. What else is happening on the machine? For example, is it a domain controller as well? Those kinds of activities run at a higher priority than all other processes.
by ray.wurlod
Thu Mar 02, 2006 12:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of stage
Replies: 14
Views: 3910

Please post the output of the following command, executed at TCL:

Code: Select all

VLIST RT_BP802 JOB.1617952052.DT.139397119.TRANS1