Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 4648
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: 4648
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: 4648
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 HLIST Utility In Batch Virendra Shambharkar TSO/ISPF 4 Fri Apr 07, 2017 3:38 pm
No new posts Batch job tuning sgandhla Testing & Performance analysis 5 Fri Mar 24, 2017 9:41 pm
No new posts MIPS/CPU consumption reduction in Batch vishwakotin DFSORT/ICETOOL 4 Sat Mar 18, 2017 5:46 pm
No new posts How does a called pgm know if its cal... Graeme Westerman COBOL Programming 5 Tue Nov 29, 2016 9:25 pm
This topic is locked: you cannot edit posts or make replies. MIPS reduction for Batch job Virendra Shambharkar All Other Mainframe Topics 8 Mon Nov 07, 2016 4:02 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us