DSXchange

Have you ever been able to log in to this project? Can you log in with the Administrator client? Somewhere you have either a permissions or credentials problem, or you installation of DataStage server has not been successful.

Welcome aboard. You need to get a UNIX-based ODBC driver for Excel, then you can use the ODBC Enterprise stage.

Most stage types are instantiated from the CCustomStage class. You will need to find some other way to identify the particular stage type (perhaps not in the first fifteen fields). Right now I am in an airport lounge without access to that information.

There are test utilities in branded_odbc that can be used with any configured DSN. Within DataStage you can use DS_CONNECT (from the TCL prompt). You can also try importing metadata and View Data via an ODBC stage.

Can you use the 99XXXXXX password with any other client, such as TOAD or SQL Navigator?

I would expect to see all these rows in the reject file. You have declared three fields (999., XXX. and XXX.) but the "good" data have more fields than three.

Version 7.5 can not use the default shared memory key (since version 8.0 is already using it) - you will need to make the version 7.5 server install an "itag" install. Apart from that (and apart from the usual caveats) it should be OK. The clients install in separate locations so no problems with th...

Because intermediate arithmetic results are dfloat. The result of StringToDate() has to be converted to a numeric data type (dfloat) before 1 can be subtracted from it.

If Oracle do do away with sqlldr it will only be to replace it with something faster/better. Would you like us to start some counter-rumour that you can challenge your old-timer with - maybe that no-one over 35 will be permitted to work in IT after 2012 so as to guarantee jobs for young people?

sujaoschin wrote:My input column 'AC_COMPLETED' is in the date format of '20060801'.

This was the cause of my question, of course.

No, given that the delete is conditional.

I'm surprised that 133 million records are taking that long. How are you loading them? Any reason not to use sqlldr (Oracle bulk load stage)? Do the data have to be normalized into Oracle, or would you be happy with, say, comma-delimited strings? In that case simply convert the value marks of multi-...

What error message appears when you fail to connect? What are you using to try to connect?

Pkease post the entire error message - the subject line truncates it. ASB = Application Server Backbone.

In one sense no stage supports pipeline parallelism, because pipeline parallelism is between stages and is implemented using virtual Data Sets. In another sense every stage supports pipeline parallelism because a Data Set is the only input or output with which an Orchestrate operator can deal.