DSXchange

I think that DataDirect (the most common tool) cannot do this. You'd have to research a bit. If you do find something that can do this, please post it on this thread.

Makreddy, DataStage Server & PX are complicated products. They can be installed on a wide range of hardware systems. There is no magic switch that can be turned on to tune jobs. The question is far too broad to be able to answer; you would need to specific the requirements in a much narrower fas...

Mimi,

no, there is no option to do this. Have you been able to reproduce your problem with a simple example?

Can you not use a DataStage job with one transform using stage variables in order to solve this problem? A short perl or awk would do it as well, but since you have DS you might as well use it.

Hello Falchetto, usually the log file of the job that aborted will contain additional information on the cause of the abort - you should start by looking there. It might be that the error code of 255 (suspicious in that it is the high-value for a single byte) is coming from a plugin stage and not di...

The data format might be better defined as text instead binary, even for the numbers. Try declaring them as text instead of int2/int4 and see if that works. You can look at the file using the UNIX head command, there is also an option in cat to display numeric values for strings. Can you not get the...

Ice, if the job has Aborted then it is no longer running, and therefore there is no way to check it's status inside of the job. The call to DSLogFatal() is immediate and doesn't return to any parts of the job. Could you explain what you are trying to do and perhaps there is another way to solve this?

Hello Rajeev, accessing Excel directly on UNIX is not a builtin feature of DataStage or of UNIX. There are software packages that will let you declare an Excel document to be accessible via ODBC on UNIX, but you need to buy the software. DataDirect is one supplier of this software and there might be...

There is no "driver" to do this in DataStage. The simplest way is to use Word to convert the file to a .txt file and then read that file into DataStage and I have seen tools that will convert a word document into other forms. The main problem is that Word documents can contain unstructured data whic...

Whatever is happening in this project is not normal. Do you have other projects on your system and do you have the same problem there? If not, then you might have a corrupted project or at least broken indices. You can try re-indexing using the DS.TOOLS command

Can you find any jobs at all or are just the ones in subcategories missing?

deepesh,

I think you might have noticed that multiple postings all within a very short period of time have the exact opposite effect from what you wanted. Have you read up on what mutex locks actually are?

I am not quite sure what Alisoviejo meant, but server and PX job can coexist in the same project and a sequencer doesn't differentiate between the two types when they are called.

I can't think of a reason why this could happen. Can you create a hashed file and write to that as well? How many rows does the hashed file have? If it is the correct number, write a short job that selects your table with too many entries and do a lookup on the hashed file. You should get 12 rows th...

Chand,

Does your sqlserver table contain triggers? How are you arriving at the number of rows in the target (144880), is it through a sql select count(*)?

What are the extra rows that are inserted, have you selected and displayed those?