Search found 53125 matches

by ray.wurlod
Wed Jan 27, 2010 3:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Scratch space help needed
Replies: 12
Views: 5372

fork failed can also be that the process table has become full. Rare, but possible. And only partially to do with disk space.
by ray.wurlod
Wed Jan 27, 2010 3:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Duplicate value for $APT_ORACLE_LOAD_OPTIONS
Replies: 1
Views: 1918

Re: Duplicate value for $APT_ORACLE_LOAD_OPTIONS

binujnair2 wrote:Is there a way to bypass this pre-compilation error apart from changing anything at the parameter set level?
No. You actually have a duplicate parameter name. You must get rid of it.
by ray.wurlod
Wed Jan 27, 2010 3:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot see Projects from Administrator
Replies: 11
Views: 3766

What happens if you specify the IP address, or the shortened hostname, for the machine hosting the server?
by ray.wurlod
Wed Jan 27, 2010 3:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NLS_LANG Not set
Replies: 2
Views: 1725

On Windows NLS_LANG needs to be set, with other environment variables, via Control Panel on the server. Windows implementation of DataStage does not use a dsenv script.

Apart from that, what Arnd advised is correct.
by ray.wurlod
Wed Jan 27, 2010 3:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: unknown files in /var/tmp
Replies: 6
Views: 2201

You should really change UVTEMP (a value in uvconfig) as well.
by ray.wurlod
Wed Jan 27, 2010 3:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Challenging Task
Replies: 5
Views: 1548

Consider a separate job to read the link row counts from the completed job and put the row into the table.

Create a generic routine to read a link row count, given the job name, active stage name and link name.
by ray.wurlod
Wed Jan 27, 2010 3:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL ERROR : Really Wierd
Replies: 3
Views: 1173

Yes, but you've already marked the thread as Resolved, so why don't you tell us?

This will assist anyone who encounters the same problem in future.

Yes, it's a silly error, but we all make those, especially while we're learning. Don't be embarrassed about posting something that will help others.
by ray.wurlod
Wed Jan 27, 2010 3:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot open executable job file RT_CONFIG60
Replies: 6
Views: 6259

Welcome aboard.

There's a Search option in the DSXchange main menu and, curiously, you're not the first to have reported this. May I suggest an exact search on "Cannot open executable job file RT_CONFIG" ?
by ray.wurlod
Wed Jan 27, 2010 3:11 pm
Forum: General
Topic: Converting Special Characters in Datastage
Replies: 3
Views: 12030

May I suggest a couple of minor improvements? One is to use the special assignment operator (:=) which is more and more efficient the longer the string gets. The other is to use a fixed width format for each Unicode codepoint. FUNCTION UniConv(TextIn) TextLen= Len(TextIn) NewText = "" For ...
by ray.wurlod
Wed Jan 27, 2010 3:02 pm
Forum:
Topic: Error while saving a lineage report
Replies: 1
Views: 1224

OK it can't find warning.gif - that may mean that warning.gif does not exist, which seems unlikely given that other clients can save reports, or that you may lack sufficient permission to get to or read warning.gif.
by ray.wurlod
Wed Jan 27, 2010 3:00 pm
Forum: IBM QualityStage
Topic: Unable to complete setlocale
Replies: 4
Views: 2420

OK, what do you think might be wrong?

Does the word "locale" trigger any thoughts?

Hint: Check NLS settings.
by ray.wurlod
Wed Jan 27, 2010 2:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: can i output to NULL from transformer ?
Replies: 5
Views: 1709

Yes, in any form of UNIX (including Linux) the file name is /dev/null. It remains the case that you must append to it, not overwrite it.
by ray.wurlod
Wed Jan 27, 2010 2:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob command
Replies: 1
Views: 1499

The second question first. If the sequence is restartable then you don't need to do anything special - the code within the sequence looks after restarting skipping any checkpointed activities. There is no command line to give you all dependent items for a job. That information has to be extracted fr...
by ray.wurlod
Wed Jan 27, 2010 2:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: can i output to NULL from transformer ?
Replies: 5
Views: 1709

Not directly, but you can use a Sequential File stage to append to the file .\NUL (which exists in every folder).

Tip: don't try to overwrite .\NUL - you have to append to it.
by ray.wurlod
Wed Jan 27, 2010 2:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading and Writing to same sequential file
Replies: 5
Views: 2605

... but not on a Windows server unless there's some kind of UNIX emulator, such as MKS Toolkit, available.