Search found 53125 matches

by ray.wurlod
Wed Jan 06, 2010 1:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How can i get Error message in mail
Replies: 1
Views: 1010

Create a routine that reads the message(s) from the log and constructs and sends the email (use DSSendMail). Invoke that routine via a Routine activity from the controlling sequence.
by ray.wurlod
Wed Jan 06, 2010 1:32 am
Forum: General
Topic: Backup of IIS project directories while websphere is down
Replies: 4
Views: 1255

Assuming you mean projects on the engine tier, certainly. While the WebSphere App Server is down, it's safe to back these up, using any file system back utility. No clients can be connected and no jobs can be running because, if you are doing things correctly, you have shut down the DataStage engine...
by ray.wurlod
Tue Jan 05, 2010 4:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS_JOBS
Replies: 5
Views: 1697

Moderator: please move to Server forum
by ray.wurlod
Tue Jan 05, 2010 4:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS_JOBS
Replies: 5
Views: 1697

Hashed files are navigated by field position, rather than by field name. Non-key fields occupy positions 1, 2, 3 and so on.
by ray.wurlod
Tue Jan 05, 2010 3:46 pm
Forum: IBM QualityStage
Topic: Address Verification (AVI)
Replies: 4
Views: 2080

Some postal services (for example USA, Canada, Australia) provided databases against which you can verify that an address actually exists - that the postal service is prepared to deliver mail there. As a separately charged part of QualityStage you can purchase such of those databases as you require,...
by ray.wurlod
Tue Jan 05, 2010 2:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: decimal number format issue in fixed length file
Replies: 9
Views: 4622

Change it to a string within your DataStage job.
by ray.wurlod
Tue Jan 05, 2010 2:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Real time implementation of change data capture
Replies: 1
Views: 1262

Don't use DataStage to do the checking - it can only be after the event. Use one of the newer technologies, such as Change Data Capture, which can feed the deltas into DataStage jobs.
by ray.wurlod
Tue Jan 05, 2010 2:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to avoid the ABNORMAL TERMINATION
Replies: 5
Views: 1800

Welcome aboard. This is a huge question. The good news is that the problem is not on the client. You will have to inspect the log of each job that has aborted to learn why it has aborted, and address the identified problem. Reset the job in Director rather than recompiling. This may create an entry ...
by ray.wurlod
Tue Jan 05, 2010 2:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 'Unable to run job - -2.' error
Replies: 1
Views: 1288

Code -2 translates as DSJE.BADSTATE: job is not in correct state, either already running or not successfully compiled.
by ray.wurlod
Tue Jan 05, 2010 2:44 am
Forum: General
Topic: Restarting job sequences
Replies: 1
Views: 886

Welcome aboard. Provided that the sequence was compiled with the option to add checkpoints so that it is restartable, its status should now be Aborted/Restartable. All you have to do is to issue a new Start request. Any activities that completed successfully will be skipped - unless marked as "...
by ray.wurlod
Tue Jan 05, 2010 1:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to start Web Console for IBM Information Server
Replies: 8
Views: 11416

Yes. Don't hijack other people's threads. Start one of your own. The question you have is unrelated to the topic of this thread.
by ray.wurlod
Mon Jan 04, 2010 11:40 pm
Forum: General
Topic: "ustring[max=50]" to result type "string[max=
Replies: 6
Views: 11923

Take a slow, systematic walkthrough of the job. Look closely at all the Columns grids in all the stages. Look for instances of Unicode.
by ray.wurlod
Mon Jan 04, 2010 8:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: decimal number format issue in fixed length file
Replies: 9
Views: 4622

The space character indicates a positive (or non-negative) value. However, trailing sign is not directly supported in parallel jobs. (It can easily be done in server job or BASIC Transformer stage.) The first question, though, is to make sure that your target field is a string (not a number). Withou...
by ray.wurlod
Mon Jan 04, 2010 8:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: difference between two timestamps
Replies: 4
Views: 2125

The difference can only be seconds. This will be a numeric data type of some kind, which can implicitly be converted to string (VarChar) provided that the string maximum size (precision) is sufficiently large.
by ray.wurlod
Mon Jan 04, 2010 8:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to create any files on node
Replies: 6
Views: 2312

What permission does the executing user have to F:/IBM/InformationServer/Server/Datasets ?