Forum Stats

  • 3,815,595 Users
  • 2,259,055 Discussions
  • 7,893,182 Comments

Discussions

Create Reports with Oracle 6i and Batch Database change

KleeSchulz
KleeSchulz Member Posts: 1
edited Oct 23, 2019 11:10AM in Social Groups

I automate our reports. The system is based on ORACLE 6i, so I use this batch command:

<span class="kwd">start</span><span class="pln"> </span><span class="pun">/</span><span class="pln">wait </span><span class="str">"Report"</span><span class="pln"> x</span><span class="pun">:\</span><span class="pln">orav60</span><span class="pun">\</span><span class="pln">bin</span><span class="pun">\</span><span class="pln">rwrun60 reportname userid</span><span class="pun">=</span><span class="pln">pos</span><span class="pun">/</span><span class="pln">pospos DESTYPE</span><span class="pun">=</span><span class="kwd">file</span><span class="pln"> DESFORMAT</span><span class="pun">=</span><span class="pln">pdf PARAMFORM</span><span class="pun">=</span><span class="pln">NO BATCH</span><span class="pun">=</span><span class="pln">YES BLANKPAGES</span><span class="pun">=</span><span class="pln">NO Von_Monat</span><span class="pun">=%</span><span class="pln">monat</span><span class="pun">%</span><span class="pln"> Bis_Monat</span><span class="pun">=%</span><span class="pln">monat</span><span class="pun">%</span><span class="pln">  DESNAME</span><span class="pun">=</span><span class="pln">path</span>

Since we have several locations, I would have to connect to different databases, how can I enter this in the batch command?