Search found 53125 matches

by ray.wurlod
Wed Apr 09, 2008 5:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to preview the data from FileStage
Replies: 5
Views: 1854

There is still no such thing as a FileStage.
:roll:
by ray.wurlod
Wed Apr 09, 2008 5:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: regd ORAOCI and OES
Replies: 5
Views: 1350

What is xrmigrator? View Data works differently in server and parallel jobs. It always displays the decimal placeholder character in the parallel version, as well as adding leading and trailing zeroes sufficient to prove that precision and scale are being handled properly. That's how it is, and ther...
by ray.wurlod
Wed Apr 09, 2008 5:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: "Server not responding " error in Datastage 8.0.1
Replies: 14
Views: 7521

What, even they have no idea what the problem is? Or which server it is that's not responding, or why? There are three that you have to check: the Information Server, the WebSphere Application Server and the DataStage Server. Perhaps the port number will give you a clue of the most likely candidate....
by ray.wurlod
Wed Apr 09, 2008 5:26 am
Forum: Site/Forum
Topic: How to list all job name created by a user
Replies: 9
Views: 3305

How is this post a suggestion for improving the DSXchange site or its forums?

Do post in the correct forum.

Your question will not be answered in this forum.
by ray.wurlod
Wed Apr 09, 2008 5:24 am
Forum: Site/Forum
Topic: error while using sort stage
Replies: 3
Views: 2173

Please do not answer questions manifestly in the wrong forum. It makes future searches more difficult.
by ray.wurlod
Wed Apr 09, 2008 5:24 am
Forum: Site/Forum
Topic: How do u identify from the link marker icons
Replies: 1
Views: 1890

You would have to ask U that question; however U does not log in here very often.

How is this post a suggestion for improving the DSXchange site or its forums?

Do post in the correct forum.

Your question will not be answered in this forum.
by ray.wurlod
Wed Apr 09, 2008 5:23 am
Forum: Site/Forum
Topic: How will you come to know whether its a SMP system or MPP
Replies: 1
Views: 1920

How is this a suggestion for improving the DSXchange site or its forums?

Do post in the correct forum.

Your question will not be answered in this forum.
by ray.wurlod
Wed Apr 09, 2008 3:25 am
Forum: Site/Forum
Topic: error while using sort stage
Replies: 3
Views: 2173

Please advise in what way this post could be regarded as a suggestion for improving the DSXchange site or forum. If you can not, then please post your question in the appropriate forum. Before you do that, read the error message carefully; it tells you precisely what your problem is. You might also ...
by ray.wurlod
Wed Apr 09, 2008 3:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to preview the data from FileStage
Replies: 5
Views: 1854

What do you mean by "file stage"? There is no such-named stage type. Be specific not only about which stage type you are meaning, and how its properties have been set. Also make sure that your /tmp file system (I'm guessing that is where you have configured scratch disk resource) has plenty of free ...
by ray.wurlod
Wed Apr 09, 2008 3:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need help in basic programming
Replies: 3
Views: 1502

Precisely what I advised, which is to use sequential file access techniques, in which the locking and appending is managed automatically for you. You might also Search the forum for a very useful routine (function) called OpenSequentialFile, which can do all of the dull part of getting the file open...
by ray.wurlod
Wed Apr 09, 2008 3:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to handle partially loaded type-2 DIM tables
Replies: 1
Views: 561

In server jobs your restart will need to discover which rows have already been committed, and either delete those and re-do from start, or figure out how to start from the next row in your ready-to-load staging area. It will also need to re-initialize the knowledge within DataStage of the next avail...
by ray.wurlod
Wed Apr 09, 2008 3:16 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Information Analyzer:: Analysis of Files and Database Tables
Replies: 9
Views: 6493

It's a patch (set of patches?) from the vendor containing ten smaller sets of fixes, all in one application.

Without it you will get very strange behaviours - and occasional non-behaviours - from Information Analyzer.
by ray.wurlod
Wed Apr 09, 2008 2:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need help in basic programming
Replies: 3
Views: 1502

You can't do it with OpenPath then Write. If you are going to use OpenPath then you have to read what's already there, append your new text, and write the whole lot back (remembering to lock the record while you're holding it. Rather more efficient would be to open the file itself for sequential acc...
by ray.wurlod
Wed Apr 09, 2008 2:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: AS400/flat file sources, NLS, UTF8 & a new NLS-related e
Replies: 5
Views: 2314

Can you try it using the ISO8859-1 map? It is the first character in your data that is giving the problem - the "?" is an indicator of "unmappable character". In hex it is 0xC9. The next two characters (0x4B and 0x4F) are being mapped as "K" and "O" respectively, which is correct. 0xC9 is 201 in Dec...
by ray.wurlod
Wed Apr 09, 2008 2:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Checkpointing in Datastage Server Jobs
Replies: 3
Views: 873

Ah, you're using version 6. This automatic checkpointing functionality is in your future. Right now you're on your own - you have to code a mechanism into your job control code to record which controlled jobs completed successfully and which aborted, and to make use of the recorded knowledge in a re...