Search found 53125 matches
- 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
- 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...
- 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....
- 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
- Wed Apr 09, 2008 5:24 am
- Forum: Site/Forum
- Topic: error while using sort stage
- Replies: 3
- Views: 2173
- Wed Apr 09, 2008 5:24 am
- Forum: Site/Forum
- Topic: How do u identify from the link marker icons
- Replies: 1
- Views: 1890
- 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
- 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 ...
- 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 ...
- 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...
- 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...
- 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
- 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...
- 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...
- 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...