MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Login to oracle database from mainframe ISPF command option

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Problem Determination
View previous topic :: View next topic  
Author Message
lal
Beginner


Joined: 21 Oct 2003
Posts: 70
Topics: 25

PostPosted: Wed Jan 13, 2010 12:04 pm    Post subject: Login to oracle database from mainframe ISPF command option Reply with quote

Hi,
Can someone please list down the steps to connect to oracle database from ISPF command option (Where we enter TSO commands).

Thanks in advance,

Thanks,
Lal
Back to top
View user's profile Send private message
superk
Advanced


Joined: 19 Dec 2002
Posts: 684
Topics: 5

PostPosted: Wed Jan 13, 2010 12:36 pm    Post subject: Reply with quote

Why don't you show us what you're currently trying and what issues or problems you're experiencing?
Back to top
View user's profile Send private message
lal
Beginner


Joined: 21 Oct 2003
Posts: 70
Topics: 25

PostPosted: Wed Jan 13, 2010 1:14 pm    Post subject: Reply with quote

Hi Superk,
I remember in past of watching the way to connect to oracle database from mainframe command option, but I don't remember the command anymore. So I posted the question so that someone could referesh my memory.

Thanks,
Lal
Back to top
View user's profile Send private message
superk
Advanced


Joined: 19 Dec 2002
Posts: 684
Topics: 5

PostPosted: Wed Jan 13, 2010 3:16 pm    Post subject: Reply with quote

I do it by calling the same program (SQLPLUS) that I execute in batch, after I allocate all of the necessary datasets to my TSO session.

Maybe this document will help:

http://download.oracle.com/docs/html/A90087_01/sql_plus.htm#13477
Back to top
View user's profile Send private message
lal
Beginner


Joined: 21 Oct 2003
Posts: 70
Topics: 25

PostPosted: Wed Jan 13, 2010 6:46 pm    Post subject: Reply with quote

Thanks Superk,
But when I type the SQLPLUS in ISPF command option it says the command is not found.

Thanks,
Lal
Back to top
View user's profile Send private message
Anuj Dhawan
Intermediate


Joined: 19 Jul 2007
Posts: 298
Topics: 7
Location: Mumbai,India

PostPosted: Thu Jan 14, 2010 6:21 am    Post subject: Reply with quote

lal wrote:
But when I type the SQLPLUS in ISPF command option it says the command is not found.
This is a site-specific stuff, you should get in touch with your local support.
_________________
Regards,
Anuj
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Problem Determination All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group