Search found 53125 matches

by ray.wurlod
Thu May 03, 2012 3:52 pm
Forum: General
Topic: Parameter not picked up by job
Replies: 7
Views: 2526

Then report it to IBM. Even as first-level support providers you are probably entitled to do that?
by ray.wurlod
Thu May 03, 2012 12:50 am
Forum: General
Topic: Parameter not picked up by job
Replies: 7
Views: 2526

So now you have evidence to present to your support provider that parameter values are not being passed from the sequence. There may already be a patch for this. Have you checked?
by ray.wurlod
Wed May 02, 2012 9:33 pm
Forum: General
Topic: Processing list of files in a Sequence job
Replies: 5
Views: 2367

Use a User Variables activity to remove the final line terminator from the output. Left(CmdActivity.$CommandOutput, Len(CmdActivity.$CommandOutput)-1) This will work on both UNIX and Windows environments because DataStage has translated either kind of line terminator to field mark by the time it get...
by ray.wurlod
Wed May 02, 2012 3:59 pm
Forum: General
Topic: No Engine credentials were found on the Services Tier
Replies: 37
Views: 24566

The user needs appropriate read/write permission to objects in DataStage. I'd put the user ID into the global DataStage group (which I usually call dstage).
by ray.wurlod
Wed May 02, 2012 3:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: count of the column by using loop variables
Replies: 11
Views: 5065

Search DSXchange for "fork join". This is not a task for the Transformer stage.
by ray.wurlod
Wed May 02, 2012 3:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Timeline splitup logic
Replies: 1
Views: 1025

Have you analysed your logic and written out an algorithm? What have you already tried?

Or are you just expecting us to do your work for you?
by ray.wurlod
Wed May 02, 2012 3:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: main_program: There are no sort keys in the dataset schema.
Replies: 2
Views: 2256

Does the design include a sort/merge collector (perhaps on the input to a Sequential File stage)?
by ray.wurlod
Wed May 02, 2012 3:47 pm
Forum: General
Topic: No Engine credentials were found on the Services Tier
Replies: 37
Views: 24566

Engine credentials must map to an operating system user on the engine tier.
by ray.wurlod
Wed May 02, 2012 3:45 pm
Forum: General
Topic: Reg Database topology
Replies: 2
Views: 1623

1. It doesn't really matter.
2. Probably not. But it depends on many other factors, particularly on the speed of the network segments between the database servers and your services and (especially) engine tiers.
by ray.wurlod
Wed May 02, 2012 3:44 pm
Forum: General
Topic: Parameter not picked up by job
Replies: 7
Views: 2526

Show us detail of the following events:
"job run requested" from the sequence log
"job started" from the job log

Each of these should show the parameter values that were used.
by ray.wurlod
Wed May 02, 2012 3:39 pm
Forum: General
Topic: dsjob command getting hanged when -jobstatus option is used.
Replies: 8
Views: 5062

Can you capture the value of reconJob$Status before the call to DSExecute()? I'm not of a mind to try to balance your quote characters by eye.
by ray.wurlod
Wed May 02, 2012 3:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hash partitioning
Replies: 7
Views: 3824

That's because hashing is a very common technique in IT, and has been for half a century. They don't feel it's necessary to document the actual algorithm they use. As a rough guide, a simple hashing algorithm might be to add together all of the code point values (ASCII or Unicode code points, for ex...
by ray.wurlod
Wed May 02, 2012 3:55 am
Forum: General
Topic: dsjob command getting hanged when -jobstatus option is used.
Replies: 8
Views: 5062

Show us the actual syntax that you are using. Your routine code might also be useful.
by ray.wurlod
Wed May 02, 2012 12:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Execution Mode & Node Map Constraint
Replies: 2
Views: 1335

Sequential execution is controlled by the configuration file. When the score is composed, the node used is a resource allocation exercise; usually sequential operators are allocated to the free-est available node from the default node pool (the node pool whose name is ""). Using a node map...
by ray.wurlod
Tue May 01, 2012 4:30 pm
Forum: General
Topic: DataStage projects not visible
Replies: 6
Views: 2903

Can you please try this variant of the command?

Code: Select all

VERIFY.SQL SCHEMA C:\Ascential\DataStage\Projects\project123