DSXchange

Sure, you can use ODBC to connect to Oracle. Oracle itself does not use ODBC but rather leverages the Oracle client over sqlnet. ODBC can also leverage the same Oracle client or can use a wired driver so that the client is not required. Thick versus thin, in other words.

Yes, correct, all checks for an Aborted job will fail if the job does not in fact abort. I personally am not aware of how a Fatal message in the log does not also Abort the job, but I do believe others have posted something similar in the past. Not sure if it's a PX thing or a bug. Do you have any r...

Please don't post the same question in multiple forums. If you recognized that this is the wrong forum, you can delete your own posts as long as they haven't been replied to yet.

Correct post is below, if you have anything to add please do it there:

http://www.dsxchange.com/viewtopic.php?t=120882

In a brute force sense, yes. You'd need to run one EReplace for each case combination you'd want to replace: "CRC", "crc", "Crc", "CrC", etc. I'm not aware of any "case insensitive" mechanism, perhaps others are. Question - is the text you want to replace always delimited as your example shows? If s...

Yes, odd. Curious... if you have the Link Collector hooked directly to the Sequential File stage, can you try inserting a Transformer between the two and see if that changes the behaviour? You may need to enable inter-process row buffering if that's not already on to do so.

Exactly. DataStage just executes SQL, bog standard SQL and doesn't do anything magical when it comes to databases. So if you code up 'cartesian product' DML then it will run the same, DataStage or no DataStage involved.

Interesting. This smells more of bug than problem with your job design, especially considering the ORA error: ORA-01480: trailing null missing from STR bind value Cause: A bind variable of type 5 (null-terminated string) does not contain the terminating null in its buffer. Action: Terminate the stri...

Are there any processes related to the job still running? If you do a "ps -ef |grep phantom" does anything show up for this 5 day job?

Welcome. :D A little confused here. Can you please explain the different between when you "compile and run it as a single job" versus the 10 server jobs run by the Sequence (no 'r') job? Is each job only processing 1/10 of the data in the latter case? Does only one job of the ten fail? I'd also be c...

What is your question or doubt?

The error you posted contains both the problem and the solution to the problem. And ps: posting in ALL CAPS is considered SHOUTING online.

There really isn't much of a choice for Oracle - you use sqlplus. And for 'some sql statements' you'll need to do that in a "here document" format. A best practice here, IMHO, is to script all of this - the sqlplus connection, the sql commands to execute, redirection of any output, post sql examinat...

Are you sure your empty file is actually empty, i.e. it doesn't have a header record? You'll need to remove any Field Marks in the output of the Execute Command stage before the number will compare correctly:

That's not the one you need. And no, there's no public download of it regardless.

A patch, yes - but not the "XP Service Pack 2" patch you mentioned. You need to get your hands on a different one, but I don't have the patch (or ecase) number handy. And AFAIK they are not publically available, your Support provider needs to make them available for you.

Nope, it be Oracle.