Search found 42 matches

by Sairam
Fri Jan 09, 2004 3:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC TO ORACLE NOT SUPPORTED
Replies: 12
Views: 3275

Thanks a lot guys

I sincerely appreciate your help

Sairam
by Sairam
Fri Jan 09, 2004 11:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC TO ORACLE NOT SUPPORTED
Replies: 12
Views: 3275

Hi Kenneth ,

Sorry to bother you guys..

If I use the OCI stage could you please explain the process to do that

Thanks
by Sairam
Fri Jan 09, 2004 10:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Capture @LOGNAME in Parallel Jobs
Replies: 6
Views: 2553

How to Capture @LOGNAME in Parallel Jobs

Hi Guys,

I need to know how to capture the Value of @LOGNAME in Parallel Jobs but it works in Server Jobs

Thanks
Sairam
by Sairam
Fri Jan 09, 2004 10:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC TO ORACLE NOT SUPPORTED
Replies: 12
Views: 3275

Hi Keenth, The OS :AIX 5.1 The DB:Oracle 9i Oracle Connectivity 1. Native Oracle Connection - TNS entry required for the requested Oracle instance. Oracle userid with the proper permissions for the Oracle database is required 2. ODBC Oracle Connection - ODBC to Oracle is not supported at this time. ...
by Sairam
Fri Jan 09, 2004 9:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC TO ORACLE NOT SUPPORTED
Replies: 12
Views: 3275

Hi Guys
u r responses appreciated


The Documment provided to me explains that
ODBC Oracle Connection:Not Supported

I need ur suggestions on how to call these Stored procs /insert/Update
without this ODBC Connectivity .

Is there any Alternative soln if using PX 7.0

Thanks for u r time
by Sairam
Fri Jan 09, 2004 8:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC TO ORACLE NOT SUPPORTED
Replies: 12
Views: 3275

ODBC TO ORACLE NOT SUPPORTED

Hi

we have to Insert/Update/or Use Stored proc in oracle from datastage but ODBC to Oracle is not supported right now .Can we do through basic program ? or shell script or is there any alternative for ODBC connectivy ?


Thanks for your time and consideration

Sairam
by Sairam
Thu Jan 08, 2004 6:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: TO call the Stored Proc or any other API what
Replies: 5
Views: 1684

TO call the Stored Proc or any other API what

Hi Gurus , Wish you all a happy new year 2004. To start with I need your Valuable suggestions. TO call the Stored Proc or any other API what is the best possible soln. 1)How to call them in a DS Routine . 2) How to call using shell script. I will appreciate if u can [rovide just the psuedo code . Th...
by Sairam
Mon Dec 01, 2003 11:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: What IS the Role of DATAWAREHOUSE DESIGNER
Replies: 9
Views: 1899

What IS the Role of DATAWAREHOUSE DESIGNER

Hi Gurus, Hope every one had a good Thanks Giving weekend . "What IS the Role of DATAWAREHOUSE DESIGNER ". Would any one please explain the Role of DATAWAREHOUSE DESIGNER , is he reponsible for writing specs or any ??????? New to DatawareHouse Concepts bear with me ............ Thanks in a...
by Sairam
Wed Nov 26, 2003 5:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Parallel Extendor
Replies: 4
Views: 1012

Thanks a lot guys you have been of great help .....

Sairam.
by Sairam
Wed Nov 26, 2003 9:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Parallel Extendor
Replies: 4
Views: 1012

Parallel Extendor

Hi Guys , TO start with I am at learning phase in DataStage .I need a help ,I have installed DS 6.x on my Windows Desktop ,but to run Parallel JOBS it needs Unix OS. Can I run parallel jobs on Linux OS.? Can I download Unix OS for free to practise ? What is the best Possible way to practice parallel...
by Sairam
Thu Nov 20, 2003 4:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS FAQS
Replies: 4
Views: 2184

DS FAQS

Hello Gurus, These are DS FAQS ,I would greatly apreciate if you guys might answer them . If a link is lost between stages, how will you recover? How to create master controlling jobs using DS job sequencer? How do you perform performance tuning on the repository? What are the various algorithms use...
by Sairam
Tue Nov 11, 2003 8:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sever Jobs migrate to parallel Jobs
Replies: 4
Views: 2127

Sever Jobs migrate to parallel Jobs

Hi Gurus,
Can we migrate the server jobs created in DataStage6.0 into Parallel Jobs .

I am a novice in this area .

Thanx in advance

Madhu