Search found 53125 matches

by ray.wurlod
Mon May 30, 2011 5:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Operators and Players
Replies: 5
Views: 2443

It's not necessarily true. Even after you exclude operator combination, sometimes there are more operators then stages. For example, overwriting a Data Set creates two operators (called a "composite operator"), one to delete the Data Set, the other to copy data into it. A normal lookup gen...
by ray.wurlod
Mon May 30, 2011 5:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing Hexadecimal value from Datastage to Teradata Byte(8)
Replies: 4
Views: 6445

Use a BASIC Transformer stage, and Oconv("00000002", "MX0C") will produce what you require. I doubt that there's an out-of-the-box way to do it otherwise using "strict" parallel components.
by ray.wurlod
Mon May 30, 2011 4:59 am
Forum: General
Topic: Return value in routine Activity
Replies: 8
Views: 3740

You have mismatched blocks in your code, and are missing a RETURN statement somewhere (or maybe an END statement). Formatting the code may help you to find that, or post the entire routine here and maybe we can spot it. Don't forget to enclose in Code tags so as to preserve the formatting.
by ray.wurlod
Mon May 30, 2011 12:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Operators and Players
Replies: 5
Views: 2443

An operator is an executable piece of code - an object of the APT_OPERATOR class. A player is the process that executes that code.
by ray.wurlod
Mon May 30, 2011 12:39 am
Forum: General
Topic: not able to login to datastage
Replies: 7
Views: 3990

How long is a piece of string? Total memory demand is only slightly goverened by the number of connected users - it's much more heavily affected by what those users are doing.
by ray.wurlod
Sun May 29, 2011 11:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data insert multiple times in target database
Replies: 9
Views: 4552

hargun wrote:help me please :(
Some of us prefer to have a life on the weekend.
by ray.wurlod
Sun May 29, 2011 11:22 pm
Forum: General
Topic: not able to login to datastage
Replies: 7
Views: 3990

Check the sessions and licensing. Are there any defunct sessions holding licence slots?
by ray.wurlod
Sun May 29, 2011 3:06 pm
Forum: General
Topic: Return value in routine Activity
Replies: 8
Views: 3740

No. Before/after subroutines do not return a value directly, but do do so through the second argument (ErrorCode). Any non-zero value will cause the job to abort once the subroutine returns. Before/after subroutines are not meant to be called from Routine activities; these activities are set up to c...
by ray.wurlod
Sat May 28, 2011 5:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Director one job DSObject Out of Memory
Replies: 6
Views: 4684

If there are squillions of entries in the job log it will take a very long time to return anything, as they have to be sorted. To test, disable refresh in Director then execute a manual refresh (View > Refresh) and wait (and wait) until something is returned. Time it with a wristwatch. I believe you...
by ray.wurlod
Sat May 28, 2011 5:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to Open Source file - Job Aborts
Replies: 4
Views: 4258

Clearly there's something.
DataStage wrote:SrcReadDataSeqFile,0: Unable to open H:/PATH/SOURCE/IN/T24D14PTXT: No such file or directory.
Check permissions for this executing user on every folder in the path.
by ray.wurlod
Sat May 28, 2011 5:07 pm
Forum: General
Topic: Return value in routine Activity
Replies: 8
Views: 3740

The return variable name must be Ans
by ray.wurlod
Sat May 28, 2011 2:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to Open Source file - Job Aborts
Replies: 4
Views: 4258

Check again, check particularly that the file may have a suffix that is hidden by your folder options in Windows Explorer.
by ray.wurlod
Sat May 28, 2011 2:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Questions regarding Hash files and hash file stage
Replies: 54
Views: 42070

The hash value in the partitioning algorithm is divided by the number of nodes and the remainder is the node number to be used. Similarly the hash value in the hashing algorithm (for a hashed file) is divided by the number of groups in the hashed file and the remainder (plus 1) is the group number t...
by ray.wurlod
Sat May 28, 2011 2:08 am
Forum: General
Topic: Installation Issue : Logon failure
Replies: 4
Views: 1194

Did you read my entire answer?
by ray.wurlod
Fri May 27, 2011 3:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Director one job DSObject Out of Memory
Replies: 6
Views: 4684

Looks more like a client side error to me.

Close a few other windows. Ideally, re-boot the client machine.

Purge old entries from the job log.