Search found 53125 matches

by ray.wurlod
Tue Oct 30, 2012 7:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting Next row value and cumulative value for all i/p recs
Replies: 4
Views: 5516

1) Sort data in reverse order and use stage variables in Transformer stage to "remember" previous row value. If necessary re-sort after Transformer stage. 2) This is a classic 'fork join' design. Use a Copy stage to split your data stream into two. One stream runs through an Aggregator sta...
by ray.wurlod
Tue Oct 30, 2012 10:31 am
Forum: General
Topic: Emailing error/failure reports
Replies: 3
Views: 1218

Verify that you have it checked. If it is, then any warning or error will flag a warning in the controlling sequence. This can be detected on completion of the controlling sequence (its status can not be Finished if there is a warning).
by ray.wurlod
Tue Oct 30, 2012 10:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to know the basics of working with Loops in Transformer
Replies: 6
Views: 3193

The examples in the menu are very straightforward and easy to understand. Have you read these? Which part did you struggle with?
by ray.wurlod
Tue Oct 30, 2012 10:28 am
Forum: General
Topic: Unlocking a Parallel job
Replies: 2
Views: 783

Identify the session ID in the message that informs you that the job is locked. Open Web Console for Information Server as a suite administrator and open the Session Management menu. Find the session that owns the lock. If you open the session it will give the identity of the user - contact that use...
by ray.wurlod
Tue Oct 30, 2012 10:25 am
Forum:
Topic: Weird Behavior by Import Export Manager
Replies: 5
Views: 1963

None.

Can you try the command line interface importexportmanager ?
by ray.wurlod
Mon Oct 29, 2012 9:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: to read last n records from a flat file
Replies: 1
Views: 1989

Welcome aboard.

I'd suggest using tail -n filename as the Filter Command in the Sequential File stage.
by ray.wurlod
Mon Oct 29, 2012 9:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Copy VOC entries of Hashed files
Replies: 10
Views: 4823

You can not use this technique with a hashed file except one that has a SICA (security and integrity constraints area), which means that you the hashed file was created with a UniVerse stage as a UniVerse/SQL table. That's why I referred you to the documentation, so you could be aware of the restric...
by ray.wurlod
Mon Oct 29, 2012 9:28 pm
Forum: General
Topic: Emailing error/failure reports
Replies: 3
Views: 1218

Have the sequences also generate a warning for any activity that finished with a status other than Success. This will cause the top level sequence to be notified (through the exit status mechanism) of any problem. You then create a routine to identify the components of the top level sequence that ha...
by ray.wurlod
Mon Oct 29, 2012 10:40 am
Forum: General
Topic: Search hard code values
Replies: 6
Views: 2251

If you get a premium membership the content will not be blocked.

At less than Rs12 per day it is a worthwhile investment if you purport to be a developer in any of the Information Server suite products.
by ray.wurlod
Mon Oct 29, 2012 10:35 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Web Service invocation fails
Replies: 3
Views: 4239

The "s" in "https" means "secure" and does require some kind of authentication. As Ernie suggests, find out if the web service can be invoked using http as the protocol.
by ray.wurlod
Mon Oct 29, 2012 10:33 am
Forum: General
Topic: Can not start datastage 8.5 service
Replies: 3
Views: 6160

The error message suggests that the wrong password is in place for the wasadmin user. Might it be the case that you set up this user with an expiring password? You can use DirectoryAdmin.sh -was to replace the password. I strongly recommend that you read the relevant part of the Information Server A...
by ray.wurlod
Mon Oct 29, 2012 12:35 am
Forum: General
Topic: Search hard code values
Replies: 6
Views: 2251

As noted, search DSXchange for examples. They've been published many times. I prefer to teach you to fish than to give you a fish.
by ray.wurlod
Sun Oct 28, 2012 4:13 am
Forum: General
Topic: Search hard code values
Replies: 6
Views: 2251

A query on DS_JOBOBJECTS joined to DS_JOBS should do it. There are plenty of examples here. Use a LIKE operator to check against EVAL "@RECORD" and constrain OLETYPE to 'CTransformerStage'.
by ray.wurlod
Sat Oct 27, 2012 4:32 pm
Forum: General
Topic: Big Data
Replies: 2
Views: 1078

Big Data

My pedometer racked up 32078 steps at IOD 2012.
by ray.wurlod
Sat Oct 27, 2012 4:15 pm
Forum: General
Topic: "tr" command not working properly in test environm
Replies: 10
Views: 2994

:idea: Try using the [:lower:] and [:upper:] classes instead. The default shell is set in the operating system, via the SHELL environment variable and via the login process (in which case the SHELL environment variable may not be set). Check the .profile script for the user under which connections a...