DSXchange

You have not installed the Visual Studio C++ compiler?

Without it you will not be able to compile jobs containing Transformer or Build stages.

If your first job with a transform and sequential files compiled & ran then your compiler installation is probably OK. Which Oracle stage and version are you using? Can you "view data" to Oracle in a designer window? Can you import column metadata from Oracle into DataStage?

Wrong, Arndo-san! With no C++ compiler any job that does not have a Transformer or Build stage will compile and run happily on 7.5x2.

ramasubba wrote:seq->tr->seq - compile & run successfully

The assumption here is the compiler must be both installed and configured. Rayo-san.

Please provide us with more warning and error messages you may have in the Oracle job failure. We need more details.

chulett wrote:

ramasubba wrote:seq->tr->seq - compile & run successfully

The assumption here is the compiler must be both installed and configured. Rayo-san.

Ah. Yeah.

Can you import metadata from Oracle? This will test the connection works.

As previously said are there no other error messages?

Oracle 9.1 or 9i? Client or database?

hi all,

ThanQ for replay to all

You are right ray, i was not installed VB.net C++ & Frame work

i was used source of Oracle 9i,

is it needs? to install Visual Studio .net C++ and framwork.

Ok... then explain this:

ramasubba wrote:after the completion of installation then took simple job and run,

seq->tr->seq - compile & run successfully

Was, in fact, this "simple job" a Server job? If so, these kind of minor little details [cough] really need to be included in your posts.

Craig - I based my post on that statement as well, since you cannot compile a transform stage without a correctly installed C++ compiler in PX jobs. If the simple job had a transform and compiled then it must have been a server one.

Yah, I meant to ask for that clarification in my first post, but didn't for some reason. Could have saved some churn.