Search found 53125 matches

by ray.wurlod
Thu Jun 22, 2006 3:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to pass NULL to a function in testing phase
Replies: 2
Views: 682

There's no mechanism in the Test grid. You have to allow for it yourself. Place some conditionally compiled statements in your routine that detect a particular value (for example "<NULL>") in an argument and convert this to null. FUNCTION AddTwo(Arg1,Arg2) $DEFINE TESTING $IFDEF TESTING If A...
by ray.wurlod
Thu Jun 22, 2006 3:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IPC stage
Replies: 4
Views: 914

If two active stages are linked together, and inter-process row buffering is enabled, then the two active stages will operate in separate processes whether or not there is an IPC stage placed on the link. The IPC stage simply makes the process boundary visible in the job design, and gives a mechanis...
by ray.wurlod
Thu Jun 22, 2006 3:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Append to DataSet - expecting 3 segments, read 4 segments
Replies: 11
Views: 3370

Look in Tools > Data Set Management in Manager client. On how many partitions is each of the Data Sets actually defined?
by ray.wurlod
Thu Jun 22, 2006 2:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: phantom
Replies: 3
Views: 844

That is not correct. "From previous run..." moves unlogged messages (if any) from &PH& to the job log irrespective of job type when the job is reset.
by ray.wurlod
Thu Jun 22, 2006 2:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Failure Notification on Mobile
Replies: 7
Views: 1380

Set up a gateway in your email server. It's not something DataStage can do. What would you expect to happen if DataStage phoned you on your mobile and you answered? Maybe there's something like that in version 42.
by ray.wurlod
Thu Jun 22, 2006 2:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: The job failed in the ABC stage.
Replies: 2
Views: 800

I suspect that the temporary file that can not be created is an Informix temporary file used to store a result set that is too large to be held in memory, and that you lack privileges to the temp tablespace (I know that's not the correct term, but can't remember the right one just now) to create the...
by ray.wurlod
Thu Jun 22, 2006 12:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: \b{Irregular XML from XMLOutput stage}
Replies: 4
Views: 1035

Just the obvious one: your schema has two element tags following the close of your complex type. What is intended by these? Here are the last five lines of your schema: </xs:complexType> </xs:element> <xs:element name="BusName" type="xs:string"/> <xs:element name="BusNameState" type="xs:NCName"/> </...
by ray.wurlod
Wed Jun 21, 2006 11:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IPC stage
Replies: 4
Views: 914

Welcome aboard. :D

They are unrelated. IPC implements and makes visible pipeline parallelism in server jobs, while the Link Partitioner/Collector stages implement and make visible partition parallelism.

For more information read Chapter 2 of Parallel Job Developer's Guide
by ray.wurlod
Wed Jun 21, 2006 8:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: failed to open RT_LOGnnn file
Replies: 7
Views: 1807

XCOPY is a DOS command, so you can use it from a CMD shell on the server.
by ray.wurlod
Wed Jun 21, 2006 8:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ASCII format showing some low characters
Replies: 22
Views: 5709

The hex dump of UltraEdit always shows dots where non-display characters occur.
by ray.wurlod
Wed Jun 21, 2006 8:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: convert a number in to word
Replies: 9
Views: 3036

It's an easy enough routine to write (for the English language at least), and non-US folks can incorporate "and" if needed, for example "one hundred and five". Treat each thousands group separately, perhaps with a recursive call; this will work out to 999,999,999,999 which ought to suit most people'...
by ray.wurlod
Wed Jun 21, 2006 4:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to create a XML output
Replies: 4
Views: 977

There's your answer, then. :)
by ray.wurlod
Wed Jun 21, 2006 4:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: format string
Replies: 14
Views: 3445

You need a routine. FUNCTION RandomString(Length) * These settings limit the characters to upper case alphabetics in ASCII. * Adjust as required. Equate MINCHAR To UniSeq("A") Equate MAXCHAR To UniSeq("Z") Ans = "" For C = 1 To Length Ans := UniC...
by ray.wurlod
Wed Jun 21, 2006 4:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file corruption - Failed Writes
Replies: 8
Views: 1905

It may be that you have mainly oversized records - these have their data portion stored in OVER.30. What is your minimum, average and maximum record size? The Hashed File Calculator does make some assumptions, one of them is that there are few oversized records. It only alerts you about 64-bit when ...
by ray.wurlod
Wed Jun 21, 2006 4:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: failed to open RT_LOGnnn file
Replies: 7
Views: 1807

You could create a new job, and compile it. This will create a new, empty RT_LOGnnn where nnn is the job number for that job. You can then (recursively) copy this for each of the job numbers for which you deleted the RT_LOGnnn hashed file. Get a list of job numbers from DS_JOBS, and cp -ipr RT_LOGnn...