Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Feb 12, 2008 2:45 am
You have not installed the Visual Studio C++ compiler?
Without it you will not be able to compile jobs containing Transformer or Build stages.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Tue Feb 12, 2008 3:15 am
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?
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Feb 12, 2008 6:26 am
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Feb 12, 2008 7:49 am
ramasubba wrote: seq->tr->seq - compile & run successfully
The assumption here is the compiler must be both installed
and configured. Rayo-san.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Teej
Participant
Posts: 677 Joined: Fri Aug 08, 2003 9:26 am
Location: USA
Post
by Teej » Tue Feb 12, 2008 12:00 pm
Please provide us with more warning and error messages you may have in the Oracle job failure. We need more details.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Feb 12, 2008 3:56 pm
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
nick.bond
Charter Member
Posts: 230 Joined: Thu Jan 15, 2004 12:00 pm
Location: London
Post
by nick.bond » Tue Feb 12, 2008 4:31 pm
Can you import metadata from Oracle? This will test the connection works.
As previously said are there no other error messages?
Regards,
Nick.
kcbland
Participant
Posts: 5208 Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:
Post
by kcbland » Tue Feb 12, 2008 6:05 pm
Oracle 9.1 or 9i? Client or database?
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
ramasubba
Participant
Posts: 2 Joined: Tue Nov 27, 2007 10:56 pm
Location: pune
Contact:
Post
by ramasubba » Wed Feb 13, 2008 4:59 am
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.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Feb 13, 2008 8:37 am
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
"You can never have too many knives" -- Logan Nine Fingers
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Wed Feb 13, 2008 9:24 am
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.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Feb 13, 2008 9:28 am
Yah, I meant to ask for that clarification in my first post, but didn't for some reason. Could have saved some churn.
-craig
"You can never have too many knives" -- Logan Nine Fingers