DSXchange

Forty two is the ultimate answer to life, the universe and everything.

Or, to extend Kim's suggestion, use the job's user status area. There's no point using a parallel job to process just one row, and it's much easier to use a server job's user status area. The contents of the user status area are available downstream in the job sequence as an Activity variable called...

Not all warnings in parallel job are bad; some - like these - are alerts. The Aggregator stage performs its calculations so as to generate dfloat results; this eliminates the possibility of arithmetic overflows (at least in our lifetimes). When you specify a different data type in the output columns...

The job sequence allows as many outputs as you wish from a job activity (there's probably some upper limit like 127; I've never bothered to check). What message is produced when you try? Are you creating a link from the Job activity to an activity that already has one input but does not support more...

Check the output link execution order. Make sure that the rejects link is being processed last. I am waiting for some one hand.,, This is an all-volunteer site. If you post on a weekend, you can not expect anyone to respond on a weekend. People post as and when they can, and tend not to if they have...

Do you want restart within a job ? That is an entirely different question. Consider the following job sequence. JobA ----> JobB ----> JobC ----> JobD Job sequence is executed. JobA finishes successfully and gets a checkpoint. JobB finishes successfully and gets a checkpoint. JobC fails. When the job...

It appears that the SMTP client does not recognize the sender's email address. Can you use the mail command from the UNIX prompt? If so what is the identity of the sender? You could use that. Also find out how other, more experienced, developers at Target code the sending of email via Notification a...

My bad, insufficient attention to detail. Shall have to plead jet lag. I read it as "DataStage account locked" (sometimes displays as "account locked by Administrator").

Check that you have both UPDATE and INSERT table privileges. Though if you do not I would expect warnings to have been logged.

Were there any? You didn't say.

Add this user to a group to which the DataStage Operator role only is assigned, and to no group to which the DataStage Developer role is assigned for this project. Check the "operator can view full log" when configuring DataStage roles for this project.

It may be that Sprint does not extend to South Africa, but most mobile phone providers have a similar service.

Upgrade to version 8.0. Then you get range lookups.

Works OK in version 7.5. Maybe they've introduced a bug? Check with your support provider. Meanwhile, perhaps you could use a character string override rather than a pattern override?

Restart DataStage on the server.

You can also use the Trans() function - also in the DataStage BASIC manual. This may be easier if there is only a single record that needs to be accessed by the routine.