Search found 53125 matches

by ray.wurlod
Wed Mar 25, 2009 4:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: installation error
Replies: 2
Views: 878

Read the message. The tar command can not be found, because its parent directory is not mentioned in your command search list (that is, in your PATH environment variable's value).
by ray.wurlod
Wed Mar 25, 2009 4:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple files based on number
Replies: 9
Views: 3113

Yes. Create sufficient output links to handle the worst case scenario, and filter on row number (ideally row number from original source). Run in sequential mode.
by ray.wurlod
Wed Mar 25, 2009 1:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: getting rows between two dates
Replies: 11
Views: 3235

Do you want to generate these or do you want to retrieve them from some data source? On a stream input or a reference input link?
by ray.wurlod
Tue Mar 24, 2009 9:28 pm
Forum: Site/Forum
Topic: Premium Membership
Replies: 17
Views: 15191

I would be very surprised if no renewal email was sent. Do they have your correct/current email address?
by ray.wurlod
Tue Mar 24, 2009 2:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to identify parent process for ORCHESTRATE
Replies: 2
Views: 4539

NEVER kill DataStage processes. Enable player processes showing their PID in the log at startup. The parent of a player process will be a section leader. The parent of a section leader, if on the conductor node, will be the conductor process. All of these are "Orchestrate" processes. ps -...
by ray.wurlod
Tue Mar 24, 2009 2:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to give unlock privilege to normal users
Replies: 3
Views: 1206

Only an administrator can use UNLOCK. This fact is not negotiable.

You can build a routine that the owner of a lock might use to release that lock but it will not use UNLOCK - it will use RELEASE.
by ray.wurlod
Tue Mar 24, 2009 2:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Special Pivot.
Replies: 2
Views: 1085

Upstream of the stage doing the pivoting create more columns containing the name of each period (as constants). Pivot these columns too.
by ray.wurlod
Tue Mar 24, 2009 2:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UNICODE Characters
Replies: 4
Views: 2152

When you need to check characters beyond 255, use UniChar() and UniSeq() rather than Char() and Seq(). Convert() is not affected.

NONE is a pseudo-map that, yes, does a pass-through. Its the correct map to use for working with hashed files that don't need to be accessed by non-NLS systems.
by ray.wurlod
Tue Mar 24, 2009 2:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence get stopped automtically
Replies: 5
Views: 1592

Ask - with vigour - who is issuing Stop requests (whether from Director or from dsjob command).
by ray.wurlod
Tue Mar 24, 2009 2:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Number of jobs in Datastage
Replies: 6
Views: 2915

You need to filter on NAME and JOBTYPE as discussed in my earlier answer.
by ray.wurlod
Tue Mar 24, 2009 1:58 pm
Forum: Site/Forum
Topic: Premium Membership
Replies: 17
Views: 15191

Obvious question that should have been asked at the top - did you pay your renewal fee?
by ray.wurlod
Tue Mar 24, 2009 1:54 pm
Forum: General
Topic: Exact purpose of lookup
Replies: 4
Views: 2023

The following is as complete as I can make it out of my head, though you really should also read the chapter on the Lookup stage in the Parallel Job Developer's Guide. The Lookup stage returns row(s) whose search key value is the same as a value supplied. The lookup may be performed conditionally, a...
by ray.wurlod
Tue Mar 24, 2009 4:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Number of jobs in Datastage
Replies: 6
Views: 2915

That will not give the correct answer, Madhu. Refer to my earlier post for reasons why not.
by ray.wurlod
Tue Mar 24, 2009 4:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: creating an output record if input count is 0
Replies: 1
Views: 778

Yes.

Easiest is an after-job subroutine to test the size of the file and echo the desired value into it if the size is zero. Use ExecSH or even ExecSHSilent.