Hello All,
I have a job in DataStage that reads from an Oracle table that is on a remote server. What kind of connectivity is it using to connect to Oracle i.e SQL NET , DB LINKS or ODBC ??
Thanks.
Raj
Reading from oracle table on remote server
Moderators: chulett, rschirm, roy
In a parallel job, you're using OCI, so it's sqlnet. In a Server job, using an OCI stage, it's also sqlnet. Using an ODBC stage obviously is ODBC.
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
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
-
- Participant
- Posts: 145
- Joined: Fri May 02, 2003 9:59 am
- Location: Seattle, Washington. USA
A little more clarification with the ODBC. If you are using the Wire Protocol ODBC drivers it is ODBC, if not then the ODBC driver calls the OCI.kcbland wrote:In a parallel job, you're using OCI, so it's sqlnet. In a Server job, using an OCI stage, it's also sqlnet. Using an ODBC stage obviously is ODBC.
Shawn Ramsey
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
The poster is on DS 6.0, so they should be using the wire protocol drivers. For those on earlier releases, yes, the ODBC piggybacks the OCI.
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
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
-
- Participant
- Posts: 145
- Joined: Fri May 02, 2003 9:59 am
- Location: Seattle, Washington. USA