Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Connecting Batch job with oracle db

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
barathirajavb

New User


Joined: 15 Feb 2008
Posts: 3
Location: chennai

PostPosted: Fri Feb 15, 2008 1:13 pm    Post subject: Connecting Batch job with oracle db
Reply with quote

Hi

I'm running some 10 manual reports in oracle db (windows) daily, now i need to automate this process by running a batch job which will query against the oracle database and generate reports in flat files.

Could anyone suggest me an idea how to connect the job with oracle db ?

thanx
barathi
Back to top
View user's profile Send private message

superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4650
Location: Raleigh, NC, USA

PostPosted: Fri Feb 15, 2008 2:03 pm    Post subject: Reply to: Connecting Batch job with oracle db
Reply with quote

Use the Oracle SQL*Plus utlity.
Back to top
View user's profile Send private message
barathirajavb

New User


Joined: 15 Feb 2008
Posts: 3
Location: chennai

PostPosted: Fri Feb 15, 2008 3:50 pm    Post subject: Reply to: Connecting Batch job with oracle db
Reply with quote

kevin

Currently i'm running this reports with Sql Plus utility, i need to automate this process by submitting a batch job which will query the oracle db and it should generate reports.

i have to run some 10 reports daily , so i thought of automating it.
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4650
Location: Raleigh, NC, USA

PostPosted: Fri Feb 15, 2008 9:39 pm    Post subject: Reply to: Connecting Batch job with oracle db
Reply with quote

Maybe I'm missing something here. The only reason I originally responsed is because I was working on a very similar project a few weeks ago before I gave up on it.

SQL*Plus should exist as a PROC (ORASQL at my site) that you can use in your JCL. Provide it with the correct input for the TNSNAMES and SYSIN DD's and you should be able to do what you want:

Code:

//ORASQL   EXEC ORASQL,SSN=PGEN
//SYSERR   DD SYSOUT=*
//ORAPRINT DD SYSOUT=*
//TNSNAMES DD *
....
/*
//SYSIN    DD *
...
/*
Back to top
View user's profile Send private message
barathirajavb

New User


Joined: 15 Feb 2008
Posts: 3
Location: chennai

PostPosted: Mon Feb 18, 2008 3:56 pm    Post subject: Reply to: Connecting Batch job with oracle db
Reply with quote

hi kevin

i have done a search at my system libraries , but no such proc's or utilities were found , could u please let me know what were the utilities used in that proc...

thanx
barathi
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4650
Location: Raleigh, NC, USA

PostPosted: Thu Feb 21, 2008 8:04 pm    Post subject: Reply to: Connecting Batch job with oracle db
Reply with quote

That ORASQL proc executes the program PGM=SQLPLUS.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
No new posts Generate public-private key in batch ... vasanthz All Other Mainframe Topics 3 Fri Sep 15, 2017 9:20 am
No new posts Working with hex values in Filemanage... Emile Straker IBM Tools 0 Tue Sep 12, 2017 1:42 am
No new posts Unable to copy data from spool in a d... srikant314 JCL & VSAM 8 Fri Jul 28, 2017 9:10 pm
No new posts HLIST Utility In Batch Virendra Shambharkar TSO/ISPF 4 Fri Apr 07, 2017 3:38 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us