DSXchange

eostic wrote:How many posts do I have compared to some of you true heros on this forum?

Don't matter - you are the DataStage XML God-Like Guru. And we all know you're holding back so as to not embarass us all.

Thanks for popping in and contributing.

eostic wrote:this is fairly well documented in the best practices doc that is referenced in many places on this forum.

Available at Kim Duke's website for download. Operators are standing by.

Funny. Was wondering how long before someone registed with that nick. Ray's gonna have to be careful about saying "there's no 'U' here" from now on.

Hey Ernie - there's a new TV show that at first I thougt was about you. It's called "Thank God You're Here!".

:D

For Server jobs, the answer is no - they are highly portable, 'executables' and all. I doubt that is the case with PX jobs containing a Transformer stage, they would need to be recompiled. May be some issues with generating flat files and choosing record terminators or slash direction but at a high ...

And however did you manage to come to that conclusion?

Was referring to AIX being at the head of the UNIX ports.

The ORABULK stage is old and really was meant only for Oracle 7 databases. Stick with the ORAOCIBL a.k.a. the 'Oracle OCI Load' stage. There you have a choice of Automatic versus Manual mode. The former is 'bulk loading on the fly' and the latter creates the files you are expecting and you must then...

You sure you have ISAM files? They were replaced by VSAM ages ago from what I recall. Regardless, I really don't believe they can be accessed via a Sequential File stage - but what the heck, give it a shot. It's all good clean fun.

Don't ask me, I don't have it yet. I doubt it does but that really should be a question to your Support provider.

kommven wrote:You should be using ONLY ODBC Stage.

Why? I shun ODBC at every opportunity, preferring native interfaces whenever possible.

Never done this, hence the 'possibly' part. And it would require purchasing ODBC drivers for this, nothing ships with DataStage that would handle the files in question. Or something like an iWay Adapter for VSAM or whatever you needed to access. Since either would need to be purchased, I'll stick wi...

Index files? You mean like ISAM or VSAM? You won't be able to read them directly except possibly via ODBC with the right drivers. Or via a COBOL program.

Best to arrange to get the data dumped to a flat file.

Looks like the error itself gives you a couple of suggestions. Why not start with those?

Doh! Thanks, going too fast today - I've corrected my previous post.

TO_CHAR() on select sql, TO_DATE() on 'update' sql.