DSXchange

Oh, wow, a SQL Server shell for Oracle! What a concept!

But, why not? We have UNIX shells for Windows, and DOS shells for UNIX.

Thinks... is there a niche market here?

Data Direct is the name of a software company (www.datadirect.com) that sells ODBC drivers. It is not "something else". A search on their web site failed to find any reference to Postgres. Direct access to major database tables (such as DB2 or Oracle) - that is, reading the rows directly - is possib...

There needs to be a colon between "Attach" and the path name, not a space.

They ARE converted; the View Data mechanism converts them back to scientific notation if they are very small or very large. Try writing to a database table with the column specified as Decimal with sufficiently large precision and scale. When writing to a text file (recall that text files don't have...

No colon after "Attach"?

Open the Administrator client. Open the Properties for your project. Make sure you have the General tab open. Click Help. At the bottom of the Help screen is the check box "Generate operational meta data". That's where it should be in your project. Close Help. If the check box is not present in your...

How large is the record specified for source file MALADDR? That is, what is the highest column number defined in its file definition?

What is the size (in characters) of the MALADDR file?

There must be more information available. Run the job with APT_DISABLE_COMBINATION set to True.

You appear to be running the job in reset mode from Tivoli. Is this the case? In that case I would expect the job status code to be 21.

What version of DataStage (precisely) are you running? There were some issues in version 7.0.x with the wrong byte of the return code being passed back.

You tell us about nulls in the data - how the heck could we know?!! Instead of using a Link Collector, have you tried using a Merge stage (to join the files) or even cat to merge them at UNIX level. cat SeqFile1 SeqFile2 > SeqFile3 | sort will achieve what you're bursting a blood vessel to achieve i...

The only place you're going to find a 360 these days is in a museum! (Probably in the archaeology department!) I can remember.....

So whats the difficulty? The first job is run from a job sequence that makes the decision about whether to run the second job or to send email.

It may be an installation issue. It may be a bug in version 8.0. I have not yet played with version 8.0, so am not really qualified to comment. You need to involve your "official" support provider, I suggest.

This item might give you pause for thought.

You did not report whether you had tried setting the Record Length property to "Fixed".