Oracle Application Server Reports Services Publishing Reports to the Web 10g (9.0.4) Part Number B10314-01 |
|
This appendix contains descriptions and examples of command line options that can be used with one or more of the following commands: rwclient
, rwrun
, rwbuilder
, rwconverter
, rwservlet
, rwcgi
, and rwserver
. Each option description includes a table that indicates which commands can use which option keywords.
Note: For examples of using command line options in your runtime URL, see Running Report Requests. |
The following topics are discussed in this appendix:
This section provides a brief description of the commands whose keywords/options are discussed in this appendix, including:
Each command description includes a list of the keywords that can be used with it. In the command line, you must use the keyword along with its option. When you enter a command line, you can use the keywords in any order.
The rwclient
command parses and transfers a command line to the specified (or default) Reports Server. All file names and paths specified in rwclient
refer to files and directories on the server machine, except for files specified in the CMDFILE
keyword. In this case, the CMDFILE
specified will be read and appended to the original command line (of which CMDFILE
is a part) before being sent to the Reports Server. The runtime engine will not re-read the CMDFILE
.
The brackets surrounding each keyword in this list are there to create a separation between keywords and has no other significance.
rwclient [ACCESSIBLE] [ARRAYSIZE] [AUTHID] [AUTOCOMMIT] [BACKGROUND] [BCC] [BLANKPAGES] [BUFFERS] [CACHELOB] [CC] [CELLWRAPPER] [CMDFILE][COLLATE] [COPIES] [CUSTOMIZE] [DATEFORMATMASK] [DELIMITED_HDR] [DELIMITER] [DESFORMAT] [DESNAME] [DESTINATION] [DESTYPE] [DISTRIBUTE] [ENGINERESPONSETIMEOUT] [EXPIRATION] [EXPRESS_SERVER] [FROM] [JOBNAME] [JOBTYPE] [LONGCHUNK] [MODE] [MODULE|REPORT] [NONBLOCKSQL] [NOTIFYFAILURE][NOTIFYSUCCESS][NUMBERFORMATMASK] [OLAP_CON] [ONFAILURE] [ONSUCCESS] [ORIENTATION] [OUTPUTIMAGEFORMAT] [PAGESIZE] [PDFCOMP] [PDFEMBED] [READONLY] [RECURSIVE_LOAD] [REPLYTO] [REPORT|MODULE] [ROLE] [RUNDEBUG] [SCHEDULE] [SERVER][SQLTRACE][SUBJECT][SUPPRESSLAYOUT][TOLERANCE] [TRACEFILE] [TRACEMODE] [TRACEOPTS] [USERID]
Running a paper report to a browser (cache)
rwclient server=myrepserv report=test.rdf userid=scott/tiger@mydb DESFORMAT=pdf DESTYPE=cache
Sending a report output to a file
rwclient server=myrepserv report=test.rdf userid=scott/tiger@mydb desformat=pdf DESTYPE=file DESNAME=c:\mydir\test
Sending a report output to a printer
rwclient server=myrepserv report=test.rdf userid=scott/tiger@mydb desformat=pdf DESTYPE=printer DESNAME=myprinter
Sending a report output via e-mail
rwclient server=myrepserv report=test.rdf userid=scott/tiger@mydb desformat=pdf DESTYPE=mail DESNAME="emp1@comp.com, emp2@comp.com" cc="emp3@comp.com" bcc="mgr@comp.com" replyto="me@comp.com" from="me@comp.com"
Sending a report output to WebDAV (any WebDAV server or OracleAS Portal WebDAV)
rwclient server=myrepserv report=test.rdf userid=scott/tiger@mydb desformat=htmlcss DESTYPE=webdav DESNAME="http://myusername:mypassword@mywebdavserv.com/mydir/test.html"
Sending a report output to OracleAS Portal
rwclient server=myrepserv report=test.rdf userid=scott/tiger@mydb DESTYPE=oracleportal desformat=PDF PAGEGROUP=mypagegrp OUTPUTPAGE=reports_output ITEMTITLE=pushtoportal STATUSPAGE=result
Sending an XML PDS report output to a file
rwclient server=myrepserv report=myxmlpdstest.rdf destype=file desformat=PDF desname=c:\mydir\my.pdf
Sending a JDBC PDS report output to a file
rwclient server=myrepserv report=myjdbcpdstest.rdf destype=file desformat=PDF desname=c:\mydir\myxml.pdf p_jdbcpds=sybuser/sybpwd@server1.mydomain.com:1300
Distributing a report output to multiple destinations:
rwclient server=myrepserv report=test.rdf userid=scott/tiger@mydb DISTRIBUTE=yes DESTINATION=c:\mydistribute.xml
Running scheduled reports
rwclient server=myrepserver report=test.rdf SCHEDULE="every first fri of month from 15:53 Oct 23, 1999 retry 3 after 1 hour" destype=file desformat=pdf desname=test.pdf
Using a secured Reports Server
rwclient server=myrepserv report=test.rdf userid=scott/tiger@mydb desformat=pdf destype=file desname=test.pdf AUTHID=myadmin/myadmin
Running a report with e-mail notification
rwclient server=myrepserver report=test.rdf userid=scott/tiger@mydb destype=file desformat=pdf desname=test.pdf NOTIFYSUCCESS="emp@comp.com" NOTIFYFAILURE="admin@comp.com"
Running a report that specifies a URL to be fetched with the URL engine:
rwclient server=myrepserver report=test.rdf userid=scott/tiger@mydb destype=file desformat=pdf desname=test.pdf JOBTYPE=rwurl URLPARAMETER="http://www.oracle.com"
Running a report with the traceopts
enabled
rwclient server=myrepserver report=test.rdf userid=scott/tiger@mydb destype=file desformat=pdf desname=test.pdf TRACEOPTS=trace_prf TRACEMODE=trace_replace
The rwrun
command runs a report using the OracleAS Reports Services in-process server. When you run a .rep
file, the PL/SQL is already compiled and will not be recompiled. If you are running an .rdf
file, the PL/SQL is automatically recompiled, if necessary. It becomes necessary if the report wasn't compiled and saved from Reports Builder or the platform or version on which you were running the report is incompatible with the platform on which it was last compiled and saved.
The brackets surrounding each keyword in this list are there to create a separation between keywords and has no other significance.
rwrun [ACCESSIBLE] [ARRAYSIZE] [AUTHID] [AUTOCOMMIT] [BCC] [BLANKPAGES] [BUFFERS] [CACHELOB] [CC] [CELLWRAPPER] [CMDFILE] [COLLATE] [COPIES] [CUSTOMIZE] [DATEFORMATMASK] [DELIMITED_HDR] [DELIMITER] [DESFORMAT] [DESNAME] [DESTINATION] [DESTYPE] [DISTRIBUTE] [EXPRESS_SERVER] [FROM] [LONGCHUNK] [MODE] [MODULE|REPORT] [NONBLOCKSQL] [NOTIFYFAILURE][NOTIFYSUCCESS][OLAP_CON] [ONFAILURE] [ONSUCCESS] [ORIENTATION] [OUTPUTIMAGEFORMAT] [PAGESIZE] [PAGESTREAM] [PDFCOMP] [PDFEMBED] [PRINTJOB] [READONLY] [RECURSIVE_LOAD] [REPLYTO] [REPORT|MODULE] [ROLE] [RUNDEBUG] [SAVE_RDF] [SQLTRACE][SUBJECT][SUPPRESSLAYOUT][TRACEFILE] [TRACEMODE] [TRACEOPTS] [USERID]
Customizing a report
rwrun userid=scott/tiger@mydb report=emp.rdf CUSTOMIZE=empcustomize.xml destype=file desformat=pdf desname=emp.pdf
Running a paper report to a browser (cache)
rwrun report=test.rdf userid=scott/tiger@mydb desformat=pdf destype=cache Example 3: Sending report output to a file rwrun report=test.rdf userid=scott/tiger@mydb desformat=pdf DESTYPE=file DESNAME=c:\mydir\test.pdf
Sending a report output to a printer
rwrun report=test.rdf userid=scott/tiger@mydb desformat=pdf DESTYPE=printer DESNAME=myprinter
Sending a report output via e-mail
rwrun report=test.rdf userid=scott/tiger@mydb desformat=pdf DESTYPE=mail DESNAME="emp1@comp.com, emp2@comp.com"cc="emp3@comp.com"bcc="mgr@comp.com" replyto="me@comp.com" from="me@comp.com"
Sending a report output to WebDAV (any WebDAV server or OracleAS Portal WebDAV)
rwrun report=test.rdf userid=scott/tiger@mydb desformat=htmlcss DESTYPE=webdav DESNAME="http://myusername:mypassword@mywebdavserv.com/mydir/test.html"
Sending a report output to OracleAS Portal
rwrun report=test.rdf userid=scott/tiger@mydb DESTYPE=oracleportal desformat=PDF PAGEGROUP=mypagegrp OUTPUTPAGE=reports_output ITEMTITLE=pushtoportal STATUSPAGE=result
Sending an XML PDS report output to a file
rwrun report=myxmlpdstest.rdf destype=file desformat=PDF desname=c:\mydir\my.pdf
Sending a JDBC PDS report output to a file
rwrun report=myjdbcpdstest.rdf destype=file desformat=PDF desname=c:\mydir\myxml.pdf p_jdbcpds=sybuser/sybpwd@server1.mydomain.com:1300
Distributing a report output to multiple destinations
rwrun report=test.rdf userid=scott/tiger@mydb DISTRIBUTE=yes DESTINATION=c:\mydistribute.xml
Using a secured Reports Server
rwrun report=test.rdf userid=scott/tiger@mydb desformat=pdf destype=file desname=test.pdf AUTHID=myadmin/myadmin
Running a report with e-mail notification
rwrun report=test.rdf userid=scott/tiger@mydb destype=file desformat=pdf desname=test.pdf NOTIFYSUCCESS="emp@comp.com" NOTIFYFAILURE="admin@comp.com"
Running a report with the traceopts
enabled
rwrun report=test.rdf userid=scott/tiger@mydb destype=file desformat=pdf desname=test.pdf TRACEOPTS=trace_prf TRACEMODE=trace_replace
The rwbuilder
command invokes Reports Builder. When you include a REPORT|MODULE
keyword with the rwbuilder
command at the command prompt, then press Enter, Reports Builder opens with the specified report highlighted in the Object Navigator. When no report is specified, Reports Builder opens with a Welcome dialog offering you the choice of opening an existing report or creating a new one.
rwbuilder
The brackets surrounding each keyword in this list are there to create a separation between keywords and has no other significance.
rwbuilder [ACCESSIBLE] [ARRAYSIZE] [AUTOCOMMIT] [BLANKPAGES] [BUFFERS] [CACHELOB] [CMDFILE] [EXPRESS_SERVER] [LONGCHUNK] [MODULE|REPORT] [NONBLOCKSQL] [OLAP_CON] [ONFAILURE] [ONSUCCESS] [OUTPUTIMAGEFORMAT] [PAGESIZE] [PRINTJOB] [READONLY] [REPORT|MODULE] [RUNDEBUG] [SAVE_RDF][SQLTRACE] [SUPPRESSLAYOUT] [TRACEFILE] [TRACEMODE] [TRACEOPTS] [USERID] [WEBSERVER_DEBUG] [WEBSERVER_ DOCROOT] [WEBSERVER_PORT] Example: rwbuilder report=myrep.rdf userid=scott/tiger@mydb
The rwconverter
command enables you to convert one or more report definitions or PL/SQL libraries from one storage format to another. For example, you can use rwconverter
to:
.rdf
file to a .rep,
.rex,
.jsp,
or .tdf
(template) file.
rex
file to an .rdf
or a template (.tdf
file)
pld
or .pll
file
pld
file into a database library or a .pll
file
.pll
file into a database library of a .pld
file
In some cases, rwconverter
will automatically compile the report's PL/SQL as part of the conversion process. Provided your conversion destination is not a .rex file, rwconverter
automatically compiles PL/SQL under the following conditions:
.rep
file. If there are compile errors, rwconverter
displays an error message and the .rep file is not created.
.rex
file as the source
In all other situations, you must compile the report's PL/SQL yourself (e.g., using Program >> Compile >> All in Reports Builder).
The brackets surrounding each keyword in this list are there to create a separation between keywords and has no other significance.
rwconverter [BATCH] [CMDFILE] [CUSTOMIZE] [DEST] [DTYPE] [DUNIT] [FORMSIZE] [NOTIFYFAILURE] [OVERWRITE] [PAGESIZE] [SOURCE] [STYPE] [USERID] [P_OWNER] [P_ SERVERS] [P_NAME] [P_DESCRIPTION] [P_PRIVILEGE] [P_AVAILABILITY] [P_TYPES] [P_ FORMATS] [P_PRINTERS] [P_PFORMTEMPLATE] [P_TRIGGER] [RECURSIVE_LOAD][UPGRADE_ PLSQL] Example: rwconverter scott/tiger@mydb stype=rdffile source=inven1.rdf dtype=xmlfile dest=inven1_new.xml
rwservlet
translates and delivers information between either a Web server or a J2EE Container (for example, OC4J) and the Reports Server, enabling you to run a report dynamically from your Web browser. Optionally, it can use the In-Process Server, which reduces the maintenance and administration of the Reports Server by providing a means for starting the server automatically, whenever it receives the first request from the client.
Note:
When you use the |
The brackets surrounding each keyword in this list are there to create a separation between keywords and has no other significance.
rwservlet [ACCESSIBLE] [ARRAYSIZE] [AUTHID] [AUTOCOMMIT] [BACKGROUND][BCC] [BLANKPAGES] [BUFFERS] [CACHELOB] [CC] [CELLWRAPPER] [CMDKEY] [CONTENTAREA*] [COLLATE] [COPIES] [CUSTOMIZE] [DATEFORMATMASK] [DELAUTH] [DELIMITED_HDR] [DELIMITER] [DESFORMAT] [DESNAME] [DESTINATION] [DESTYPE] [DISTRIBUTE] [ENGINERESPONSETIMEOUT] [EXPIRATION] [EXPIREDAYS] [EXPRESS_SERVER] [FROM] [GETJOBID] [GETSERVERINFO] [HELP] [ITEMTITLE] [JOBNAME] [JOBTYPE] [KILLJOBID] [LONGCHUNK] [MIMETYPE] [MODE] [MODULE|REPORT] [NONBLOCKSQL] [NOTIFYFAILURE] [NOTIFYSUCCESS] [OLAP_CON] [ONFAILURE] [ONSUCCESS] [ORIENTATION] [OUTPUTFOLDER*] [OUTPUTIMAGEFORMAT] [OUTPUTPAGE] [PAGEGROUP] [PAGESIZE] [PAGESTREAM] [PARAMFORM] [PARSEQUERY] [PDFCOMP] [PDFEMBED] [READONLY] [RECURSIVE_LOAD] [REPLACEITEM] [REPLYTO] [REPORT|MODULE] [ROLE] [RUNDEBUG] [SCHEDULE] [SERVER] [SHOWAUTH] [SHOWENV] [SHOWMAP][SHOWJOBID] [SHOWJOBS] [SHOWMYJOBS] [SITENAME*][SQLTRACE][STATUSFORMAT] [STATUSFOLDER*] [STATUSPAGE] [SSOCONN] [SUBJECT][SUPPRESSLAYOUT][TOLERANCE] [TRACEMODE] [TRACEOPTS] [URLPARAMETER] [USERID]
* maintained for backward compatibility with Oracle9iAS Portal Release 1 and/or Oracle WebDB Release 2.2.
Note: The following keywords are commands rather than keyword-value pairs, i.e., commands are entered by themselves without a corresponding value: SHOWENV, SHOWJOBS, SHOWMAP, SHOWMYJOBS, KILLJOBID, PARSEQUERY, DELAUTH, GETJOBID, and GETSERVERINFO. |
http://myiasFoot 1.mycomp.com:7779Foot 2/reports/rwservlet?server=myrepserver+report=myrep o.rdf+desname=sample.pdf+desformat=pdf+destype=file http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserver+authidFoot 3=myrepu ser/myreppassword+report=myrepo.rdf+desname=sample.pdf+desformat=pdf+destype=fil e
Running a paper report to a browser (cache)
http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+ userid=scott/tiger@mydb+desformat=pdf+DESTYPE=cache
Sending a report output to a file
http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+ userid=scott/tiger@mydb+desformat=pdf+DESTYPE=file+DESNAME=c:\mydir\test.
Sending a report output to a printer
http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+ userid=scott/tiger@mydb+desformat=pdf+DESTYPE=printer+DESNAME=myprinter
Sending a report output via e-mail
http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+ userid=scott/tiger@mydb+desformat=pdf+DESTYPE=mail+DESNAME="emp1@comp.com,emp2@c omp.com"+CC="emp3@comp.com"+BCC="mgr@comp.com"+REPLYTO="me@comp.com"+FROM=me@com p.com"
Sending a report output to WebDAV (any WebDAV server or OracleAS Portal WebDAV)
http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+ userid=scott/tiger@mydb+desformat=htmlcss+DESTYPE=webdav+DESNAME="http://myusern ame:mypassword@mywebdavserv.com/mydir/test.html"
Sending a report output to OracleAS Portal
http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+ userid=scott/tiger@mydb+destype=oracleportal+desformat=PDF+PAGEGROUP=mypagegrp+O UTPUTPAGE=reports_output+ITEMTITLE=pushtoportal+STATUSPAGE=result
Sending an XML PDS report output to a file
http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=myxmlpdst est.rdf+destype=file+desformat=PDF+DESNAME=c:\mydir\my.pdf
Sending a JDBC PDS report output to a file
http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=myjdbcpds test.rdf+destype=file+desformat=PDF+desname=c:\mydir\myxml.pdf+p_ jdbcpds=sybuser/sybpwd@server1.mydomain.com:1300
Distributing a report output to multiple destinations
http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+ userid=scott/tiger@mydb+DISTRIBUTE=yes+DESTINATION=c:\mydistribute.xml
Running scheduled reports
http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserver+report=test.rd f+SCHEDULE="every first fri of month from 15:53 Oct 23, 1999 retry 3 after 1 hour"+destype=file+desformat=pdf+desname=test.pdf
Using a secured Reports Server
http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+ userid=scott/tiger@mydb+desformat=pdf+destype=file+desname=test.pdf+AUTHID=myadm in/myadmin
Using a key file
http://myias.mycomp.com:7779/report/rwservlet?key1
where
key1=
key defined in the cgicmd.dat
file (the keyname should be the first parameter)
or
http://myias.mycomp.com:7779/report/rwservlet?server=myrepserv+userparam=12+CMDK EY*=keyname
*when used with cmdkey
, it can be anywhere in the URL
Running a report with a Parameter Form
http://myias.mycomp.com:7779/rwservlet?server=myrepserver+report=test.rdf+userid =scott/tiger@mydb+destype=cache+desformat=htmlcss+PARAMFORM=yes
Running a report with e-mail notification
http://myias.mycomp.com:7779/rwservlet?server=myrepserver+report=test.rdf+userid =scott/tiger@mydb+destype=file+desformat=pdf+desname=test.pdf+NOTIFYSUCCESS="emp @comp.com"+NOTIFYFAILURE="admin@comp"
Running a report that specifies a URL to be fetched with the URL engine
http://myias.mycomp.com:7779/rwservlet?server=myrepserver+report=test.rdf+userid =scott/tiger@mydb+destype=file+desformat=pdf+desname=test.pdf+JOBTYPE=rwurl+URLP ARAMETER="http://www.oracle.com"
Running a report with the traceopts
enabled
http://myias.mycomp.com:7779/rwservlet?server=myrepserver+report=test.rdf+userid =scott/tiger@mydb+destype=file+desformat=pdf+desname=test.pdf+TRACEOPTS=trace_ prf+TRACEMODE=trace_replace
Like rwservlet
, rwcgi
(the Common Gateway Interface (CGI) translates and delivers information between either a Web server or a J2EE Container (for example, OC4J) and the Reports Server, enabling you to run a report dynamically from your Web browser.
The brackets surrounding each keyword in this list are there to create a separation between keywords and has no other significance.
rwcgi [ACCESSIBLE] [ARRAYSIZE] [AUTHID] [AUTOCOMMIT] [BACKGROUND][BCC] [BLANKPAGES] [BUFFERS] [CACHELOB] [CC] [CELLWRAPPER] [COLLATE] [CONTENTAREA*] [COPIES] [CUSTOMIZE] [DATEFORMATMASK] [DELAUTH][DELIMITED_HDR] [DELIMITER] [DESFORMAT] [DESNAME] [DESTINATION] [DESTYPE] [DISTRIBUTE] [ENGINERESPONSETIMEOUT] [EXPIRATION] [EXPIREDAYS] [EXPRESS_SERVER] [FROM][GETJOBID][ITEMTITLE] [JOBNAME] [JOBTYPE][KILLJOBID][LONGCHUNK] [MIMETYPE] [MODE] [MODULE|REPORT] [NONBLOCKSQL] [NOTIFYFAILURE] [NOTIFYSUCCESS] [OLAP_CON] [ONFAILURE] [ONSUCCESS] [ORIENTATION] [OUTPUTFOLDER*] [OUTPUTIMAGEFORMAT] [OUTPUTPAGE] [PAGEGROUP] [PAGESIZE] [PAGESTREAM] [PARAMFORM][PARSEQUERY][PDFCOMP][PDFEMBED] [READONLY] [RECURSIVE_LOAD] [REPLACEITEM] [REPLYTO] [REPORT|MODULE] [ROLE][RUNDEBUG][SCHEDULE][SERVER] [SHOWENV][SHOWMAP][SHOWJOBID][SHOWJOBS] [SHOWMYJOBS] [SHOWAUTH] [SITENAME*] [SQLTRACE] [STATUSFOLDER*] [STATUSPAGE] [SUBJECT][SUPPRESSLAYOUT][TOLERANCE] [TRACEMODE] [TRACEOPTS] [USERID]
* maintained for backward compatibility with Oracle9iAS Portal Release 1 and/or Oracle WebDB Release 2.2.
http://mywebserver.comFoot 4:7779Foot 5/cgi-bin/rwcgi.exeFoot 6?server=myrepserver+report=myrepo .rdf+desname=sample.pdf+desformat=pdf+destype=file http://mywebserver.com:7779/cgi-bin/rwcgi.shFoot 7?server=myrepserver+authidFoot 8=myrepus er/myreppassword+report=myrepo.rdf+desname=sample.pdf+desformat=pdf+destype=file
Running a paper report to a browser (cache)
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+u serid=scott/tiger@mydb+DESFORMAT=pdf+DESTYPE=cache
Sending a report output to a file
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+u serid=scott/tiger@mydb+desformat=pdf+DESTYPE=file+DESNAME=c:\mydir\test
Sending a report output to a printer
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+u serid=scott/tiger@mydb+desformat=pdf+DESTYPE=printer+DESNAME=myprinter
Sending a report output via e-mail
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+u serid=scott/tiger@mydb+desformat=pdf+DESTYPE=mail+DESNAME="emp1@comp.com, emp2@comp.com+CC=emp3@comp.com"+BCC="mgr@comp.com"+REPLYTO="me@comp.com+from=me@ comp.com"
Sending report output to WebDAV (any WebDAV server or OracleAS Portal WebDAV)
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+u serid=scott/tiger@mydb+desformat=htmlcss+DESTYPE=webdav+DESNAME="http://myuserna me:mypassword@mywebdavserv.com/mydir/test.html"
Sending a report output to OracleAS Portal
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+u serid=scott/tiger@mydb+DESTYPE=oracleportal+desformat=PDF+PAGEGROUP=mypagegrp+OU TPUTPAGE=reports_output+ITEMTITLE=pushtoportal+STATUSPAGE=result
Sending XML PDS report output to a file
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=myxmlpdste st.rdf+DESTYPE=file+desformat=PDF+desname=c:\mydir\my.pdf
Sending a JDBC PDS report output to a file
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=myjdbcpdst est.rdf+destype=file+desformat=PDF+desname=c:\mydir\myxml.pdf+p_ jdbcpds=sybuser/sybpwd@server1.mydomain.com:1300
Distributing report output to multiple destinations
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+u serid=scott/tiger@mydb+DISTRIBUTE=yes+DESTINATION=c:\mydistribute.xml
Running scheduled reports
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserver+report=test.rdf +SCHEDULE="every first fri of month from 15:53 Oct 23, 1999 retry 3 after 1 hour"+destype=file+desformat=pdf+desname=test.pdf
Using a secured Reports Server
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+u serid=scott/tiger@mydb+desformat=pdf+destype=file+desname=test.pdf+AUTHID=myadmi n/myadmin
Using a key file
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?key1
where key1=key defined in the cgicmd.dat
file (the keyname should be the first parameter)
or
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+userparam=12+CMDK EY=key1
*when used with cmdkey
, it can be anywhere in the URL
Running a report with a Parameter Form
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserver+report=test.rdf +userid=scott/tiger@mydb+destype=cache+desformat=htmlcss+PARAMFORM=yes
Running a report with e-mail notification
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserver+report=test.rdf +userid=scott/tiger@mydb+destype=file+desformat=pdf+desname=test.pdf+NOTIFYSUCCE SS="emp@comp.com"+NOTIFYFAILURE="admin@comp.com"
Running a report that specifies a URL to be fetched with the URL engine
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserver+report=test.rdf +userid=scott/tiger@mydb+destype=file+desformat=pdf+desname=test.pdf+JOBTYPE=rwu rl+URLPARAMETER="http://www.oracle.com"
Running a report with the traceopts
enabled
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserver+report=test.rdf +userid=scott/tiger@mydb+destype=file+desformat=pdf+desname=test.pdf+TRACEOPTS=t race_prf+TRACEMODE=trace_replace
The rwserver
command invokes the Reports Server. The Reports Server processes client requests, which includes ushering them through its various services, such as authentication and authorization checking, scheduling, caching, and distribution (including distribution to custom or pluggable output destinations). Reports Server also spawns runtime engines for generating requested reports, fetches completed reports from the Reports cache, and notifies the client that the job is ready.
The brackets surrounding each keyword in this list are there to create a separation between keywords and has no other significance.
rwserver[AUTHID] [AUTOSTART] [BATCH] [SERVER] [SHUTDOWN] [TRACEOPTS] [INSTALL] [UNINSTALL][JVMOPTIONS] Example: rwserver -install myrepserver batch=yes autostart=yes
Following is the syntax for a command line, where keyword=value
is a valid command line option:
rwclient REPORT|MODULE=runfile USERID=username/password@database [ [keyword=]value|(value1, value2, ...) ] SERVER=server_name
Keywords must be specified and can be used in any order following the command.
CMDFILE=
). In this case, the CMDFILE specified will be read and appended to the original command line (of which CMDFILE
is a part) before being sent to the Reports Server. The runtime engine will not re-read the CMDFILE
.
REPORTS_PATH
environment variable.
Table A-1 indicates which commands can use the ACCESSIBLE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
yes |
yes |
no |
Use ACCESSIBLE
to specify whether accessibility-related features offered through Oracle Reports are enabled (YES
) or disabled (NO
) for PDF output.
ACCESSIBLE={YES|NO}
YES
Accessibility features are enabled for PDF output.
NO
Accessibility feature is not enabled for PDF output.
NO
Table A-2 indicates which commands can use the ARRAYSIZE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
yes |
yes |
no |
Use ARRAYSIZE
to specify the size (in kilobytes) for use with Oracle9i array processing. Generally, the larger the array size, the faster the report will run.
ARRAYSIZE=
n
n A number from 1 through 9999 (no comma is used with thousands). This means that Reports Runtime can use this number of kilobytes of memory per query in your report.
10
ARRAYSIZE
can be used when running JSP-based Web reports from the command line.
Table A-3 indicates which commands can use the AUTHID
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
yes |
Use AUTHID
to specify the user name and the password to be used to authenticate users to the restricted Reports Server. User authentication ensures that the users making report requests have access privileges to run the requested report.
AUTHID=
username
/
password
username/password
Any valid user name and password created in OracleAS Portal. See your DBA to create new users accounts in OracleAS Portal.
None
AUTHID
can be used when running JSP-based Web reports from the command line.
AUTHID
.
Table A-4 indicates which commands can use the AUTOCOMMIT
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
yes |
yes |
no |
Use AUTOCOMMIT
to specify whether database changes (for example, CREATE) should be automatically committed to the database. Some non-Oracle databases (for example, SQL Server) require that AUTOCOMMIT=YES
.
AUTOCOMMIT={YES|NO}
YES
Data changes are committed to the database automatically.
NO
Data changes are not committed to the database until the COMMIT command runs or one of the PL/SQL commands that cause the data to be committed runs.
AUTOCOMMIT
can be used when running JSP-based Web reports from the command line.
Table A-5 indicates which commands can use the AUTOSTART
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
no |
no |
yes |
Use AUTOSTART
to specify that the Reports Server will automatically start after initial installation and after a reboot, without requiring a user logon.
AUTOSTART={YES|NO}
YES
The service will automatically start at reboot, without requiring a user logon.
NO
The service will not automatically start at reboot, requiring a user logon.
NO
The AUTOSTART
keyword is only recognized on Microsoft Windows platforms.
Table A-6 indicates which commands can use the BACKGROUND
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
no |
no |
no |
yes |
yes |
no |
BACKGROUND
specifies whether a report on the server should be run synchronously (NO
) or asynchronously (YES
).
BACKGROUND={YES|NO}
YES
Runs the report asynchronously. The client sends the call to the server, then continues with other processes without waiting for the report job to complete. If the client process is killed, the job is canceled.
NO
Runs the report synchronously. The client waits for the report to queue, be assigned to a runtime engine, run, and finish.
NO
If BACKGROUND=YES
is used with rwbuilder
or rwrun
, a warning is issued and the keyword is ignored.
Table A-7 indicates which commands can use the BATCH
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
yes |
no |
no |
yes |
For all relevant commands, the BATCH
option tells the server to run in no-UI mode. How it is used across commands is similar in that no UI is produced by the application when running from a command line that includes BATCH=YES
. For example, for rwserver
this allows the server to be run from scripts and remote agents so that no server dialog comes up while it is running.
With rwconverter
, BATCH
suppresses all terminal input and output in order to convert reports/libraries without user intervention. With rwserver
, BATCH
turns the server window dialog off (YES
) or on (NO
) to display or suppress process messages.
BATCH={YES|NO}
YES
Suppresses all terminal input and output (report is run in the background). This is the default for rwrun
.
NO
Allows special terminal input and output. For rwconverter
, the Convert dialog box is displayed, and when you accept the dialog box, the conversion is performed.
NO
BATCH=YES
, error messages are sent to SYSOUT.
For more information on SYSOUT
, see DESNAME.
BATCH=YES,
PARAMFORM=YES
is invalid because it is not meaningful to have the Runtime Parameter Form appear in batch mode.
Table A-8 indicates which commands can use the BCC
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use BCC
to specify e-mail recipient(s) of a blind courtesy copy (that is, one in which the names of specified recipients are not visible (published) to other recipients).
BCC=emailid | ("emailid","emailid", ...)
emailid
A valid e-mail address in the form someone
@foo
.com.
None
BCC
can be used when running JSP-based Web reports from the command line.
Table A-9 indicates which commands can use the BLANKPAGES
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
yes |
yes |
no |
Use BLANKPAGES
to specify whether to suppress blank pages when you print a report. Use this keyword when there are blank pages in your report output that you do not want to print.
BLANKPAGES={YES|NO}
YES
BLANKPAGES
is especially useful if your logical page spans multiple physical pages (or panels), and you wish to suppress the printing of any blank physical pages.
Table A-10 indicates which commands can use the BUFFERS
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
yes |
yes |
no |
Use BUFFERS
to specify the size of the virtual memory cache in kilobytes. You should tune this setting to ensure that you have enough space to run your reports, but not so much that you are using too much of your system's resources.
BUFFERS
=n
n A number from 1 through 9999 (note that thousands are not expressed with any internal punctuation, e.g., a comma or a decimal point). For some operating systems, the upper limit might be lower.
640
BUFFERS
can be used when running JSP-based Web reports from the command line.
Table A-11 indicates which commands can use the CACHELOB
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
yes |
yes |
no |
Use CACHELOB
to specify whether to cache retrieved ORACLE large object or objects in the temporary file directory on the Reports Server (specified in the environment variable REPORTS_TMP
or by the tempDir
property of the engine element in the Reports Server configuration file, server_name.
conf
; note that a tempDir
setting overrides a REPORTS_TMP
setting.).
CACHELOB={YES|NO}
YES
The LOB will be cached in the temporary file directory.
NO
The LOB will not be cached in the temporary file directory.
YES
NO
. Setting the value to NO
, however, might decrease performance, as the LOB might need to be fetched from the database multiple times.
CACHELOB
can be used when running JSP-based Web reports from the command line.
Table A-12 indicates which commands can use the CC
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use CC
to specify e-mail recipient(s) of a courtesy copy.
CC=emailid | ("emailid","emailid", ...)
emailid
A valid e-mail address in the form someone
@foo
.com
.
None
Table A-13 indicates which commands can use the CELLWRAPPER
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use CELLWRAPPER
to specify the character or characters that displays around the delimited cells in your report output.
CELLWRAPPER=
value
value Any alphanumeric character or string of alphanumeric characters.
Value | Description |
---|---|
|
A double quotation mark displays on each side of the cell |
|
A single quotation mark displays on each side of the cell |
Value | Description |
---|---|
|
A tab displays on each side of the cell |
|
A single space displays on each side of the cell |
|
A new line displays on each side of the cell |
|
No cell wrapper is used |
Value | Description |
---|---|
|
A tab displays on each side of the cell |
|
A new line displays on each side of the cell |
None
DESFORMAT=DELIMITED
or DESFORMAT=DELIMITEDDATA
.
Table A-17 indicates which commands can use the CMDFILE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
yes |
no |
no |
no |
Use CMDFILE
to call a file that contains one report's command line options. The file called must be an ASCII file, either .txt
or any other ASCII-type file.
CMDFILE
differs from the cgicmd.dat
file, in that CMDFILE
can contain one command line for one report, where the cgicmd.dat
file can contain multiple key-identified commands for multiple reports. Additionally, the CMDFILE
keyword can be used along with other arguments in a command line; while, when you use the key argument associated with cgicmd.dat
, it is the only argument that appears in the command line.
The CMDFILE
keyword enables you to run a report without specifying a large number of options each time you invoke a run command.
CMDFILE=
filename
filename
Any valid command file name.
None
rwservlet
and rwcgi
, use the CMDKEY
keyword to refer to a key in the cgicmd.dat
file in lieu of using the CMDFILE
keyword.
rwclient
from the command line with COPIES
set to 1 and CMDFILE
set to RUNONE
(a command file). The RUNONE
file also specifies a value for COPIES
, but it is set to 2. The value specified for COPIES
in the command line (1) overrides the value specified for COPIES
in the RUNONE
file (2). Only one copy of the report will be generated.
Table A-18 indicates which commands can use the CMDKEY
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
yes |
no |
no |
Use CMDKEY
to call a key-identified command line in the cgicmd.dat
file. For example:
http://yourwebserver
/reports/rwservlet?cmdkey=key& ...
CMDKEY=
key
key The name of any key associated with a command line specified in the cgicmd.dat
file.
None
CMDKEY
with rwservlet
, you can use it in any order in the command line (or the URL, following the question mark). With rwservlet
, you can use additional command line keywords along with CMDKEY
.
CMDKEY
can be used when running JSP-based Web reports from the command line.
Table A-19 indicates which commands can use the COLLATE keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use Collate to control the collating behavior when a report is output to a printer.
For example, printing three copies of a three page document with COLLATE
set to YES
would result in output similar to the following:
1 2 3|1 2 3| 1 2 3
The order specified is the page numbers being printed. This behavior is similar to selecting the Collate check box in the Print dialog box.
Printing three copies of a three page document with COLLATE
set to NO
would result in output similar to the following:
1 1 1| 2 2 2| 3 3 3
COLLATE={YES|NO}
YES
Collates the pages when output to a printer.
NO
Does not collate the pages when output to a printer.
YES
Table A-20 indicates which commands can use the CONTENTAREA
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use CONTENTAREA
to specify the Oracle9iAS Portal Release 1 content area to which report output should be pushed. This keyword is maintained for backward compatibility with Oracle9iAS Portal Release 1; for backward compatibility with Oracle WebDB Release 2.2, see SITENAME. Beginning with OracleAS Portal Release 2, use PAGEGROUP.
CONTENTAREA=
name
name
The name (internal name) of any valid Oracle9iAS Portal Release 1 content area.
None
CONTENTAREA
name should be the internal name and not the display name. The internal name is used to uniquely identify the Oracle9iAS Portal Release 1 component instance.
* maintained for backward compatibility with Oracle9iAS Portal Release 1 and/or Oracle WebDB Release 2.2.
Table A-21 indicates which commands can use the COPIES
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use COPIES
to specify the number of copies of the report output to print.
COPIES=
n
n
Any valid integer from 1 through 9999 (note that thousands are not expressed with any internal punctuation, e.g., a comma or a decimal point).
Taken from the Initial Value property of the COPIES
parameter (the Initial Value was defined in Reports Builder at design time).
DESTYPE
is not PRINTER
.
COPIES
is left blank on the Runtime Parameter Form, then it defaults to one.
Table A-22 indicates which commands can use the CUSTOMIZE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
yes |
yes |
yes |
no |
Use CUSTOMIZE
to specify an Oracle Reports XML file to be run against the current report. The XML file contains customizations (for example, changes to the layout or data model) that change the report definition in some way.
CUSTOMIZE=
filename
.xml | (
filename1
.xml,
filename2
.xml, ...)
filenamen
.xml
The names of the files that contain a valid XML report definition, with path information prefixed to the name(s) if necessary. (if the files are not located in a path specified in the REPORTS_PATH
registry or SourceDir
property for the engine element).
Note: For more information on customizing reports at runtime with XML customization files, see Customizing Reports with XML. |
None
xml
, but it does not have to be when it is used with the CUSTOMIZE
keyword.
CUSTOMIZE
can be used when running JSP-based Web reports from the command line.
Table A-23 indicates which commands can use the DATEFORMATMASK
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use DATEFORMATMASK
to specify how date values display in your delimited report output.
DATEFORMATMASK=
mask
mask
Any valid date format mask.
None
DESFORMAT=DELIMITED
or DESFORMAT=DELIMITEDDATA
.
DATEFORMATMASK
can be used when running JSP-based Web reports from the command line.
Table A-24 indicates which commands can use the DELAUTH
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
yes |
yes |
no |
Use DELAUTH
to delete rwservlet
or rwcgi user ID cookies.
http://yourwebserver/reports/rwservlet/delauth[?][server=servername][&authid=use rname/password]
See Syntax.
None
Table A-25 indicates which commands can use the DELIMITED_HDR
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use DELIMITED_HDR
to turn off boilerplate text (such as the report header) when running a report with DESFORMAT=DELIMITED or DESFORMAT=DELIMITEDDATA.
DELIMITED_HDR={YES|NO}
YES
Turn off all boilerplate text in the delimited output file.
NO
Leave boilerplate text as is in the delimited output file.
YES
This keyword can be used only if you have specified DESFORMAT=DELIMITED or DESFORMAT=DELIMITEDDATA.
Table A-26 indicates which commands can use the DELIMITER
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use DELIMITER
to specify the character or characters to use to separate the cells in your report output.
DELIMITER=
value
value
Any alphanumeric character or string of alphanumeric characters, such as:
Values | Description |
---|---|
|
A comma separates each cell |
|
A period separates each cell |
Any of these reserved values:
Values | Description |
---|---|
tab |
A tab separates each cell |
space |
A space separates each cell |
return |
A new line separates each cell |
none |
No delimiter is used |
Values | Description |
---|---|
|
A tab separates each cell |
|
A new line separates each cell |
Tab
This keyword can be used only if you have specified DESFORMAT=DELIMITED or DESFORMAT=DELIMITEDDATA
.
Table A-30 indicates which commands can use the DESFORMAT
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use DESFORMAT
to specify the format for the job output. Use DESFORMAT
to specify the printer driver to be used when DESTYPE
is FILE
and DESNAME=
filename
.
DESFORMAT=
desformat
Any valid destination format not to exceed 1 kilobyte in length. Examples of valid values for this keyword are listed and described in Table A-31.
Value | Description |
---|---|
|
The report output is sent to a file that can be read by standard spreadsheet utilities, such as Microsoft Excel. If you do not specify a delimiter (via the |
|
Provides the same functionality as |
|
This report output is sent to a file that is in HTML format. |
|
This report output is sent to a file that includes style sheet extensions. |
|
This report output is sent to a file that is in PDF format and can be read by a PDF viewer, such as Adobe Acrobat. PDF output is based upon the currently configured printer for your system. The drivers for the currently selected printer are used to produce the output; you must have a printer configured for the machine on which you are running the report. |
|
This report output is sent to a file that is in PostScript format. |
|
The printer definition to use when formatting the report when If MODE=BITMAP, this is the name of the printer.
If MODE=CHARACTER, this is the character-mode printer definition file (. |
|
The report output is sent to a file that can be read by word processors (such as Microsoft Word). When you open the file in Microsoft Word, you must choose View > Page Layout to view all the graphics and objects in your report. |
|
This report output is saved as an XML file. This report can be opened and read in an XML-supporting browser, or your choice of XML viewing application. |
Taken from the Initial Value property of the DESFORMAT
parameter (the Initial Value was defined in Reports Builder at design time). When you run a report via Reports Builder and DESFORMAT
is blank or dflt
, then the current printer driver (specified in File > Printer ) is used. If a Printer Name has not been selected using the drop down list, then Reports Builder defaults to PostScript.
DESFORMAT=HTML
or DESFORMAT=HTMLCSS
, spaces are replaced with
. This default behavior eliminates alignment issues for number values that are right-aligned. If you do not want spaces replaced with
in your HTML and HTMLCSS output, then you must set REPORTS_NO_HTML_SPACE_REPLACE
to YES
. This removes the functionality of the DELIMITER
command line keyword for HTML and HTMLCSS output (DELIMITER
is still valid when DESFORMAT=DELIMITED
).
DESFORMAT=DELIMITED
is not supported in a .dst
file. In this case, Oracle Reports displays error:
REP-34305: Invalid keyword setting for the destid='DEST1'
DESFORMAT=DELIMITEDDATA
, the DelimitedData driver runs off the data model and operates in much the same way as the XML driver. Since the driver runs off the data model, any formatting changes defined in the layout are not reflected in the DelimitedData output. You can set the following column properties to alter column names and exclude columns from the DelimitedData output file:
The DelimitedData functionality also honors the DELIMITER, CELLWRAPPER, NUMBERFORMATMASK, and DATEFORMATMASK command line options just as the DELIMITED
does.
Table A-32 indicates which commands can use the DESNAME
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use DESNAME
to specify the name of the cache, file, printer, OracleAS Portal, or e-mail ID (or distribution list) to which the report output will be sent.
DESNAME
=desname
desname
Any valid cache destination, file name, printer name, e-mail ID, or OraclePortal, not to exceed 1K in length. For printer names, you can optionally specify a port. For example:
DESNAME=printer,LPT1: DESNAME=printer,FILE:
Taken from the Initial Value property of the DESNAME
parameter (the Initial Value was defined in Reports Builder at design time). If DESTYPE
=
FILE
and DESNAME
is an empty string, then it defaults to reportname.lis
at runtime.
name,name,name
Table A-33 indicates which commands can use the DEST
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
yes |
no |
no |
no |
Use DEST
to specify the name(s) of the converted reports or libraries.
DEST={
dest_name|(dest_name1, dest_name2,
...)|pathname
}
dest_name
Any valid report/library name or filename, or a list of valid report/library names of filenames enclosed in parentheses and separated by commas (e.g., (qanda,text,dmast)
).
If the DEST
keyword is not specified, rwconverter uses the following default names:
PLDFILE
, then the DEST
default name is source.pld
.
PLLFILE
, then the DEST
default name is source.pll
.
RDFFILE
, then the DEST
default name is source.rdf
.
REPFILE
, then the DEST
default name is source.rep
.
REXFILE
, then the DEST
default name is source.rex
.
XMLFILE
, then the DEST
default name is source.xml
.
REGISTER
, then the DEST
default name is the name of the SQL*Plus script output file (e.g., output.sql
).
(qanda,test,dmast) or (qanda, test, dmast)
DEST
keyword may be operating system-specific.
DTYPE = REGISTER
, multiple destinations are not required. If you list more than one SQL*Plus script file name for DEST
, only the first one is recognized. The others are ignored.
Table A-34 indicates which commands can use the DESTINATION
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use the DESTINATION
keyword to specify the name of an XML file that defines the distribution for the current run of the report.
DESTINATION=
filename.xml
filename.xml
The name of an XML file that defines a report or report section distribution.
None
To enable the DESTINATION
keyword, you must specify DISTRIBUTE=YES
on the command line. If both these keywords are specified, DESTYPE, DESNAME, and DESFORMAT are ignored if they are also specified.
Note: For more information about creating advanced distributions, see Chapter 15, "Creating Advanced Distributions". |
Table A-35 indicates which commands can use the DESTYPE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use DESTYPE
to specify the type of device that will receive the report output. If you have created your own pluggable destination via the Oracle Reports Destination API, this is how the destination you created gets called.
DESTYPE={CACHE|LOCALFILE|FILE|PRINTER|SYSOUT|MAIL|ORACLEPORTAL|FTP|WEBDAV|name_of_pluggable_destination}
Table A-36 lists and describes the valid values for the DESTYPE
keyword.
Value | Description |
---|---|
|
Sends the output directly to the Reports Server cache. |
|
Valid only for |
|
Sends the output to the file on the server named in |
|
Sends the output to the printer on the server named in DESNAME. You must have a printer that the OracleAS Reports Services can recognize installed and running. |
|
Valid only for |
|
Sends the output to the mail users specified in
Note: The configuration file |
|
Valid for Sends the output to OracleAS Portal. Relevant keywords include CONTENTAREA*, EXPIREDAYS, ITEMTITLE, OUTPUTFOLDER*, OUTPUTPAGE, PAGEGROUP, REPLACEITEM, SCHEDULE, SITENAME*,STATUSFOLDER*,STATUSPAGE. * maintained for backward compatibility with Oracle9iAS Portal Release 1 and/or Oracle WebDB Release 2.2. |
|
Valid for |
|
Valid for |
name_of_pluggable_destination |
If you have created your own pluggable destination via the Oracle Reports Destination API, this is what you use to call the destination you created. |
1
For more information about this pluggable destination, see the Oracle Reports Plugin Exchange on OTN (http://otn.oracle.com/products/reports/pluginxchange/content.html )2 For more information about this pluggable destination, see the Oracle Reports Plugin Exchange on OTN ( http://otn.oracle.com/products/reports/pluginxchange/content.html ) |
Taken from the Initial Value property of the DESTYPE
parameter (the Initial Value was defined in Reports Builder at design time).
DESTYPE
values of SCREEN
and PREVIEW
are no longer valid because the Reports Runtime (rwrun
) user interface is obsolete. In Reports Builder (rwbuilder
), you can still set the DESTYPE
system parameter to SCREEN
or PREVIEW
to format a report to display screen fonts or printer (preview) fonts in the Reports Builder user interface.
DESTYPE
=printer
: On Windows, the hardware-based left margin is ignored, by default. The printing origin starts from the top left corner (0,0) of the physical paper and not the printable area. This is to facilitate the design of printer hardware-based margin independent reports. Printing reports without hardware-based left margins on Windows You must ensure that your report's layout contains enough margin spacing such that your data falls within the printable area. Margin fields in the Page Setup dialog have been disabled to ensure consistency with OracleAS Reports Services. To revert to the old behavior of including the hardware margin, set the REPORTS_ADD_HWMARGIN
environment variable to YES
.
DESTYPE=ORACLEPORTAL:
The ORACLEPORTAL
destination cannot be used with distribution. Instead, you can use DESTYPE=WEBDAV
for advanced XML based distribution to OracleAS Portal.
The DESTYPE=ORACLEPORTAL
destination cannot be used with the rwrun
executable as it causes Reports Server to stop responding. Use this destination only with rwservlet
, rwclient
, or rwcgi
.
Before you push Oracle Reports output to Oracle9iAS Portal Release 1 ensure that you have created the following:
Additionally, you need to edit the Reports Server configuration file as follows:
destype=oraclePortal
element.
<destination destype="oraclePortal" class="oracle.reports.server.DesOraclePortal"> <!--property name="portalUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_ PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/--> </destination>
portalUserid
property with your OracleAS Portal connection information if you do not want to push an Oracle Reports output to the default Oracle9iAS Portal Release 1 instance.
Running the request is very similar to any other out-of-the-box destinations. For example:
http://your_server:port/reports/rwservlet? report=test.rdf&userid=scott/tiger@repportal&authid=pushportal/trial&destype =oracleportal&desformat=PDF&pagegroup=PORTAL_REPORTS&outputpage=reports_ output&itemtitle=pushtoportal&statuspage=result
DESTYPE=FTP
: Running the request is very similar to any other out-of-the-box destinations. You need to specify the complete FTP URL location along with the file name. If the FTP server needs an authentication, that also needs to be part of the URL as shown in the following example:
http://your_
server:port
/reports/rwservlet?report=rep.jsp&destype=FTP&desname=ftp://user:
pwd@ftpServer/dir/myreport.pdf&desformat=pdf
In the above example, the DESTYPE
is FTP
and the DESNAME
value is a complete FTP URL location along with the report name myreport.pdf
.
To use a proxy server, edit the destination
element (configured for FTP out-of-the-box) in the Reports Server configuration file:
<destination destype="ftp" class="oracle.reports.plugin.destination.ftp.DesFTP"> <!--property name="proxy" value="proxyinfo.xml"/--> </destination>
To specify the proxy information, edit the proxyinfo.xml
file available in the default location (ORACLE_HOME
\reports\conf
). Uncomment the previous property entry and specify the complete path to the proxyinfo.xml
file as the value.
For example, if your ORACLE_HOME
is located in D:\9iAS
, then the default location for proxyinfo.xml
can be specified as:
<destination destype="ftp" class="oracle.reports.plugin.destination.ftp.DesFTP"> <property name="proxy" value="D:\\9iAS\\reports\\conf\\proxyinfo.xml"/>
</destination>
DESTYPE=WEBDAV
: Running the request is very similar to any other out-of-the-box destinations. You need to specify the complete WEBDAV URL location along with the file name. If the WEBDAV server needs an authentication, that also needs to be part of the URL as shown in the following example:
http://your_ server:port/reports/rwservlet?report=rep.jsp&destype=WebDAV&desname=http://u ser:pwd@webdavServer/myreport.pdf&desformat=pdf
In the above example, the DESTYPE
is WEBDAV
and the DESNAME
value is a complete WEBDAV URL location along with the report name myreport.pdf
.
To use a proxy server, edit the destination
element (configured for WEBDAV out-of-the-box) in the Reports Server configuration file:
<destination destype="WebDav" class="oracle.reports.plugin.destination.webdav.DesWebDAV"> <!--property name="proxy" value="proxyinfo.xml"/--> </destination>
To specify the proxy information, edit the proxyinfo.xml
file available in the default location (ORACLE_HOME
\reports\conf
). Uncomment the property entry above and specify the complete path to the proxyinfo.xml
file as the value.
For example, if your ORACLE_HOME
is located in D:\9iAS
, then the default location for proxyinfo.xml
can be specified as:
<destination destype="WebDav" class="oracle.reports.plugin.destination.webdav.DesWebDAV"> <property name="proxy" value="D:\\9iAS\\reports\\conf\\proxyinfo.xml"/>
</destination>
Table A-37 indicates which commands can use the DISTRIBUTE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use DISTRIBUTE
to enable or disable distributing the report output to multiple destinations, as specified by the distribution list defined in the report distribution definition (defined in Reports Builder at design time) or a distribution XML file.
DISTRIBUTE={YES|NO}
YES
Distribute the report to the distribution list.
NO
Ignore the distribution list and output the report as specified by the DESNAME, DESTYPE, and DESFORMAT parameters. This is fundamentally a debug mode to allow running a report set up for distribution without actually executing the distribution.
NO
The DISTRIBUTE
keyword works in close association with the DESTINATION keyword. DISTRIBUTE
must have a value of YES
for the DESTINATION
keyword to take effect. If both these keywords are specified, DESTYPE, DESNAME, and DESFORMAT are ignored if they are also specified.
Note: For more information about creating advanced distributions, see Creating Advanced Distributions. |
Table A-38 indicates which commands can use the DTYPE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
yes |
no |
no |
no |
Use DTYPE
to specify the format to which to convert the reports or libraries.
DTYPE={PLDFILE|PLLFILE|RDFFILE|REPFILE|REXFILE|TDFFILE|XMLFILE|JSPFILE|REGISTER}
The following values apply:
PLDFILE
The converted PL/SQL libraries will be stored in files in ASCII format.
PLLFILE
The converted PL/SQL libraries will be stored in files containing source code and P-code (compiled PL/SQL).
RDFFILE
The converted report(s) will be stored in one or more report definition files (files with the .rdf
extension).
REPFILE
The converted report(s) will be stored in one or more binary runfiles (files with the .rep
extension).
REXFILE
The converted report(s) will be stored in one or more text files (files with the .rex
extension).
TDFFILE
The report will be converted to a template file (files with the .tdf
extension).
XMLFILE
The converted report(s) will be stored in an XML file (files with the .xml
extension).
JSPFILE
The converted report(s) will be stored in a JSP file (files with the .jsp
extension).
REGISTER
A script file is created to load each report specified by SOURCE
into OracleAS Portal with the RWWWVREG.REGISTER_REPORT
function. Each load function is populated with the necessary information to register the report in OracleAS Portal. By running the resulting script file in SQL*Plus against the Oracle Application Server DB Provider, you can batch register multiple reports in OracleAS Portal.
REPFILE
rep
file using rwconverter
, the source report's PL/SQL is automatically compiled. If there are compile errors, an error message is displayed and the .rep
file is not created. To avoid this problem, make sure you compile the source report's PL/SQL using File > Administration > Compile Report in Reports Builder, before you try to create a .rep
file.
Table A-39 indicates which commands can use the DUNIT
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
yes |
no |
no |
no |
Use DUNIT
to specify the destination unit of measurement to which the report should be converted. If specified, DUNIT
must differ from the SOURCE report's unit of measurement. If unspecified, the SOURCE report's unit of measurement is used.
DUNIT={CENTIMETER|CHARACTER|INCH|POINT}
CENTIMETER
The converted reports will initially use centimeters as the unit of measurement
CHARACTER
The converted reports will initially use characters as the unit of measurement.
INCH
The converted reports will initially use inches as the unit of measurement.
POINT
The converted reports will initially use points as the unit of measurement
Null
(the report's unit of measurement is used).
Table A-40 indicates which command can use the ENGINERESPONSETIMEOUT
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
no |
no |
no |
yes |
yes |
no |
Use ENGINERESPONSETIMEOUT
to specify the maximum amount of time (in minutes) for an engine to update the status of the job while running a report in your environment. If it takes longer than this amount of time to update the job status for some reason (e.g., due to the engine hanging or a long blocking SQL query), then Reports Server terminates the job.
This parameter overrides the engineResponseTimeOut
attribute of the engine
element in the Reports Server configuration file. Refer to engine for further information about the engine element.
ENGINERESPONSETIMEOUT=
number
number
A number of minutes (e.g., 5).
None
Table A-41 indicates which command can use the EXPIRATION
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
no |
no |
no |
yes |
yes |
no |
Use EXPIRATION
to define how long report output can exist in cache before it is deleted.
See Reusing Report Output from Cache for more information on duplicate job detection.
EXPIRATION=
time_string
time_string
Is in one of two formats:
n
{
unit
}
, for a number with an optional unit. The unit can be minute(s), hour(s), or day(s). The default unit is minute(s) if no unit is specified.
{
Mon DD
,
YYYY
}
hh
:
mi
:
ss
am|pm {
timezone
}
, for a date/time format. Date information is optional. If it isn't specified, today is assumed. Time zone is also optional. If it isn't specified, the Reports Server's timezone is used. The date/time is always in a US locale. This format is the same as defined in the Java DateFormat.MEDIUM
type.
None
Table A-42 indicates which commands can use the EXPIREDAYS
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
yes |
yes |
no |
Use EXPIREDAYS
to specify the number of days after which the Oracle Reports output pushed to Oracle9iAS Portal Release 1 should be expired.
EXPIREDAYS={PERMANENT|1 day|2 days|3 days|7 days|14 days|31 days|60 days|90 days|120 days}
None
* maintained for backward compatibility with Oracle9iAS Portal Release 1 and/or Oracle WebDB Release 2.2.
Table A-43 indicates which commands can use the EXPRESS_SERVER
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
yes |
yes |
no |
Use EXPRESS_SERVER
to specify the Express Server to which you want to connect.
EXPRESS_SERVER="server=
server
/domain=
domain
/user=
userid
/password=
passwd
"
EXPRESS_SERVER="server=
server
/domain=
domain
/user=
userid
/password=
passwd
/ramuser=
ramuserid
/rampassword=
rampasswd
/ramexpressid=
ramexpid
/ramserverscript=
ramsscript
/rammasterdb=
ramdb
/ramconnecttype=
ramconn
"
A valid connect string enclosed in double quotes (") where:
The server value contains four parameters that correspond to settings that are made in the Oracle Express Connection Editor and stored in connection (XCF) files. All four parameters are required and can be specified in any order. Table A-45 describes the parameters and their settings:
None
EXPRESS_SERVER="server=ncacn_ip_tcp:olap2-pc/sl=0/ st=1/ct=0/sv=1/domain=tools//reports"
Table A-46 indicates which commands can use the FORMSIZE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
yes |
no |
no |
no |
Use FORMSIZE
to specify the size of the Runtime Parameter Form for the converted report in terms of the destination unit of measurement (specified using DUNIT).
FORMSIZE=
width
x
height
width/height
Any valid values in the specified unit of measurement.
None
Table A-47 indicates which commands can use the FROM
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use FROM
to specify the e-mail address of the sender of an e-mail.
FROM=
emailid
emailid
Any valid e-mail address in the form someone@foo
.com.
loginid@machine_name
Related keywords include BCC,CC, FROM, REPLYTO, and SUBJECT. Note that DESNAME is used to specify the main recipient(s) of the e-mail.
Table A-48 indicates which commands can use the GETJOBID
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
yes |
yes |
no |
Use GETJOBID
to retrieve the result output of the Reports Server job with job ID n
.
http://yourwebserver/reports/rwservlet/getjobidn[?][server=server_ name][&authid=username/password]
See Syntax.
None
Table A-49 indicates which commands can use the GETSERVERINFO
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
yes |
no |
no |
Use GETSERVERINFO
to display Reports Server information. You can choose the format (HTML or XML) in which the information is returned via &statusformat
.
http://yourwebserver/reports/rwservlet/getserverinfo[?][server=server_ name][&authid=username/password][&statusformat={html|xml}]
See Syntax.
None
Table A-50 indicates which commands can use the HELP
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
yes |
yes |
no |
Use HELP
to display a help topic that lists the keywords you can use with the rwservlet
command. For example:
http://yourwebserver
/reports/rwservlet/help?command=keyword
http://
yourwebserver
/reports/rwservlet/help
or
http://
yourwebserver
/reports/rwservlet/help?
command=keyword
See Syntax.
None
Table A-51 indicates which commands can use the INSTALL
keyword
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
no |
no |
yes |
Use INSTALL
to configure an instance of the Reports Server on Microsoft Windows as a service. This keyword does not work on UNIX platforms.
INSTALL
reports_server_name
reports_server_name
A valid name for the Reports Server instance.
None
AUTOSTART
keyword with INSTALL
, the Reports Server service will be started automatically after installation and whenever the system is restarted.
BATCH=YES
with INSTALL
, then none of the prompts and dialogs that normally display during installation will appear.
Table A-52 indicates which commands can use the ITEMTITLE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use ITEMTITLE
to specify the display name Oracle9iAS Portal Release 1 should use for Oracle Reports output. The name will display in Oracle9iAS Portal Release 1 and link to Oracle Reports output.
ITEMTITLE=
title
title
Any text. Put quotation marks around the value if the value has any character spaces in it or you are specifying the option in the cgicmd.dat
file.
The report file name
* maintained for backward compatibility with Oracle9iAS Portal Release 1 and/or Oracle WebDB Release 2.2.
Table A-53 indicates which commands can use the JOBNAME
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
no |
no |
no |
yes |
yes |
no |
Use JOBNAME
to specify the name for a job to appear in Reports Queue Manager. It is treated as a comment and has nothing to do with running the job. If JOBNAME
is not specified, then Reports Queue Manager shows the report name as the job name.
JOBNAME=
string
Any job name.
None
JOBNAME
can be used when running JSP-based Web reports from the command line.
Table A-54 indicates which commands can use the JOBTYPE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
no |
no |
no |
yes |
yes |
no |
Use JOBTYPE
to specify the type of job to be processed by the server. You can enter any type of job, as long as the Reports Server has an engine to process it.
JOBTYPE=
jobtype
jobtype
A job for which the Reports Server has an engine.
REPORT
Table A-55 indicates which commands can use the JVMOPTIONS
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
yes |
yes |
yes |
no |
no |
yes |
Use JVMOPTIONS
to set options for either Reports Runtime, Reports Builder, Reports Converter, or Reports Server's Java Virtual Machine (JVM). For example, you could use the following command line to start the Reports Server with a 512Mb heap space:
rwserver server= servername jvmoptions=-Xmx512M
You could also use the following command line to start Reports Builder with a 512Mb heap space:
rwbuilder jvmoptions=-Xmx512M
Multiple options can be passed, in which case the options must be enclosed in quotes:
rwserver server= servername jvmoptions="-Xmx256M -Xms=128M" rwbuilder jvmoptions="-Xmx256M -Xms=128M"
JVMOPTIONS={
options in the Reports Runtime, Reports Builder, Reports Converter, or Reports Server's JVM
}
-Xmx256M
Table A-56 indicates which commands can use the KILLJOBID
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
yes |
yes |
no |
Use KILLJOBID
to kill a Reports Server job with the specified job ID n.
http://yourwebserver/reports/rwservlet/killjobidn[?][server=server_ name][&authid=username/password][&statusformat={html|xml|xmldtd}]
See Syntax.
None
SHOWJOBS
to see the current list of jobs. The STATUSFORMAT
can be set to html (default), xml , or xmldtd to return status in that format. The status information is generated in html, xml, or xmldtd (with an internal dtd subset).
STATUSFORMAT
parameter is only valid for rwservlet, not for rwcgi.
Table A-57 indicates which commands can use the LONGCHUNK
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
yes |
yes |
no |
LONGCHUNK
is the size (in kilobytes) of the increments in which Reports Builder retrieves a LONG column value. When retrieving a LONG value, you might want to retrieve it in increments rather than all at once because of memory size restrictions. LONGCHUNK
applies only to Oracle databases.
LONGCHUNK=
n
n
A number from 1 through 9999 (note that thousands are not expressed with any internal punctuation, e.g., a comma or a decimal point). For some operating systems, the upper limit might be lower.
10
LONGCHUNK
can be used when running JSP-based Web reports from the command line.
Table A-58 indicates which commands can use the MIMETYPE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
yes |
yes |
no |
Use MIMETYPE
to override the MIME
type assigned by the Reports Server when it returns output for the Web. In most cases, the default MIME type is correct, but, in cases where it is not, you can override it with this keyword. For example:
mimetype=application/vnd.ms-excel
MIMETYPE=
string
string
A valid MIME type specification.
None
OracleAS Reports Services does not verify the string you enter for MIMETYPE
. You must ensure yourself that the string is correct for the returned report output.
Table A-59 indicates which commands can use the MODE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use MODE
to specify whether to run the report in character mode or bitmap. This enables you to run a character-mode report from Reports Builder.
MODE={BITMAP|CHARACTER|DEFAULT}
The following values apply:
BITMAP
Run the report in bitmap mode.
DEFAULT
Run the report in the mode of the current executable being used.
CHARACTER
On Windows - the Reports Builder ASCII driver will be used to produce editable ASCII output.
DEFAULT
Table A-60 indicates which commands can use the MODULE|REPORT
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
yes |
yes |
no |
Use MODULE
or REPORT
to specify the name of the report to run.
REPORT|MODULE=
runfile
runfile
Any valid runfile (that is, a file with an extension of .rep
,.rdf
,.jsp
, or .xml
).
None
.xml
file extension when specified with the MODULE|REPORT
keyword.
.rep
, then extension .rdf
, then .jsp
, and then no extension, using the file path search order to find the file.
Table A-61 indicates which commands can use the NONBLOCKSQL
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
yes |
yes |
no |
Use NONBLOCKSQL
to specify whether to allow other programs to execute while data is fetched from the database.
NONBLOCKSQL={YES|NO}
YES
Other programs can execute while data is being fetched.
NO
Other programs cannot execute while data is being fetched.
YES
NONBLOCKSQL
can be used when running JSP-based Web reports from the command line.
Table A-62 indicates which commands can use the NOTIFYFAILURE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use NOTIFYFAILURE
to specify the recipient(s) of a notification e-mail should a report request fail. Use this keyword when you configure your Reports Server to use the notification class. For more information, see the notification discussion in Configuring OracleAS Reports Services.
NOTIFYFAILURE=
emailid|(emailid,emailid,...)
emailid
A valid e-mail address in the form someone@foo
.com.
None
NOTIFYFAILURE
template is named failnote.txt, and is located at ORACLE_HOME
\reports\template
.
NOTIFYFAILURE
can be used when running JSP-based Web reports from the command line.
Table A-63 indicates which commands can use the NOTIFYSUCCESS
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use NOTIFYSUCCESS
to specify the recipient(s) of a notification e-mail should a report request succeed. Use this keyword when you configure your Reports Server to use the notification class. For more information, see the notification discussion in Configuring OracleAS Reports Services.
NOTIFYSUCCESS=
emailid|(emailid,emailid,...)
emailid
A valid e-mail address in the form someone@foo
.com.
None
NOTIFYSUCCESS
template is named succnote.txt
, and is located at ORACLE_HOME
\reports\template
.
NOTIFYSUCCESS
can be used when running JSP-based Web reports from the command line.
Table A-64 indicates which commands can use the NUMBERFORMATMASK
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use NUMBERFORMATMASK
to specify how number values display in your delimited report output.
NUMBERFORMATMASK=
mask
Any valid number format mask.
None
DESFORMAT=DELIMITED
or DESFORMAT=DELIMITEDDATA
.
NUMBERFORMATMASK
can be used when running JSP-based Web reports from the command line.
Table A-65 indicates which commands can user the OLAP_CON
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
yes |
yes |
no |
OLAP_CON
specifies the Oracle OLAP (on-line analytical processing) connection string to connect to a database that contains multidimensional Oracle OLAP data.
OLAP_CON=
userid/password/hostname/SID/portnumber
A valid OLAP connection string where:
userid
The user ID for connecting to Oracle OLAP.
password
The password for the user ID.
hostname
The host name for the database.
SID
The system identifier (SID) for connecting to the database.
portnumber
The port number for connecting to the database.
For example:
OLAP_Con="user1/secret1/mypc.us.oracle.com/mySID/9201
Table A-66 indicates which commands can use the ONFAILURE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
yes |
yes |
no |
Use ONFAILURE
to specify whether you want a COMMIT
or ROLLBACK
performed if an error occurs and the report fails to complete.
ONFAILURE={COMMIT|ROLLBACK|NOACTION}
COMMIT
Perform a COMMIT
if the report fails.
ROLLBACK
Perform a ROLLBACK
if the report fails.
NOACTION
Do nothing if the report fails.
ROLLBACK
, if a USERID
is provided.
NOACTION
, if called from an external source (for example, OracleAS Forms Services) with no USERID
provided.
COMMIT
or ROLLBACK
for ONFAILURE
is performed after the report fails. Other COMMIT
s and ROLLBACK
s can occur prior to this one. For more information, see the READONLY command.
ONFAILURE
can be used when running JSP-based Web reports from the command line.
Table A-67 indicates which commands can use the ONSUCCESS
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
yes |
yes |
no |
Use ONSUCCESS
to specify that either a COMMIT
or ROLLBACK
should be performed when a report is finished running.
ONSUCCESS={COMMIT|ROLLBACK|NOACTION}
COMMIT
Perform a COMMIT
when a report is done.
ROLLBACK
Perform a ROLLBACK
when a report is done.
NOACTION
Do nothing when a report is done.
COMMIT
, if a USERID
is provided.
NOACTION
, if called from an external source (for example, OracleAS Forms Services) with no USERID
provided.
COMMIT
or ROLLBACK
for ONSUCCESS
is performed after the after-report trigger fires. Other COMMIT
s and ROLLBACK
s can occur prior to this one. For more information, see the READONLY command.
ONSUCCESS
can be used when running JSP-based Web reports from the command line.
Table A-68 indicates which commands can use the ORIENTATION
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
ORIENTATION
controls the direction in which the pages of the report will print.
ORIENTATION={DEFAULT|LANDSCAPE|PORTRAIT}
DEFAULT
Use the current printer setting for orientation.
LANDSCAPE
Landscape orientation (long side at top and bottom).
PORTRAIT
Portrait orientation (short side at top and bottom).
DEFAULT
ORIENTATION=LANDSCAPE
for a character mode report, then you must ensure that your printer definition file contains a landscape clause.
Table A-69 indicates which commands can use the OUTPUTFOLDER
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use OUTPUTFOLDER
to specify the name of the Oracle WebDB Release 2.2 or OracleAS Portal folder to push Oracle Reports output. This keyword is maintained for backward compatibility with Oracle WebDB Release 2.2 and Oracle9iAS Portal Release 1. Beginning with OracleAS Portal 10g (9.0.4), use OUTPUTPAGE.
OUTPUTFOLDER=
folder
folder
Any valid folder name (internal name) used in Oracle WebDB Release 2.2 or Oracle9iAS Portal Release 1.
Oracle_Reports_Output
* maintained for backward compatibility with Oracle9iAS Portal Release 1 and/or Oracle WebDB Release 2.2.
Table A-70 indicates which commands can use the OUTPUTIMAGEFORMAT
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
yes |
yes |
no |
Use OUTPUTIMAGEFORMAT
to choose the format for images in your report output.
OUTPUTIMAGEFORMAT={PNG|JPEG|JPG|GIF|BMP}
PNG,JPEG,JPG
Supported image formats when DESFORMAT value is PDF, HTML, HTMLCSS, or RTF
GIF
Supported image format when DESFORMAT
value is PDF, HTML, or HTMLCSS
BMP
Supported image formats when DESFORMAT
value is RTF
REPORTS_OUTPUTIMAGEFORMAT
environment variable.
REPORTS_DEFAULT_DISPLAY
environment variable is explicitly set to NO
(default is YES
). In this case, image rendering defaults to GIF for HTML, HTMLCSS, and PDF output, and BMP for RTF output.
The following command lines generate PNG images with HTML output:
rwclient server=my_rep_server report=images.rdf destype=file desformat=html desname=images.html userid=user_id outputimageformat=PNG rwrun report=images.rdf destype=file desformat=html desname=images.html userid=user_id outputimageformat=PNG
Similarly when DESFORMAT=pdf
, images are embedded in PNG format in the generated PDF document.
An error is displayed if an invalid value is specified for the OUTPUTIMAGEFORMAT
. The following command lines generate an error message:
rwclient server=my_rep_server report=images.rdf destype=file desformat=html desname=images.html userid=user_id outputimageformat=ABCD rwrun report=images.rdf destype=file desformat=html desname=images.html userid=user_id outputimageformat=ABCD
The invalid image format ABCD generates the following error message:
REP-35000: The image output format specified is not supported.
Table A-71 indicates which commands can use the OUTPUTPAGE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use OUTPUTPAGE
to specify the name of the Oracle Reports page to push a report output information to. For backward compatibility with earlier versions (Oracle WebDB Release 2.2 and Oracle9iAS Portal Release 1), see OUTPUTFOLDER.
OUTPUTPAGE=
page
page
Any valid page name (internal name) used in Oracle9iAS Portal Release 1.
Oracle_Reports_Output
DESTYPE=ORACLEPORTAL.
* maintained for backward compatibility with Oracle9iAS Portal Release 1 and/or Oracle WebDB Release 2.2.
Table A-72 indicates which commands can use the OVERWRITE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
yes |
no |
no |
no |
Use OVERWRITE
to specify whether to overwrite existing files with the converted files.
OVERWRITE={YES|NO|PROMPT}
YES
Automatically overwrite any existing files of the same name.
NO
Do not to convert reports if there are existing files of the same name and display a warning message
PROMPT
Prompt you before overwriting any existing files.
NO
Table A-73 indicates which commands can use the P_AVAILABILITY
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
yes |
no |
no |
no |
Use P_AVAILABILITY
to specify the name of the availability calendar that determines when the reports specified will be available for processing. This keyword is only used when DTYPE=REGISTER.
P_AVAILABILITY=
calendar_name
calendar_name
Any valid availability calendar name.
None
The availability calendar must exist in OracleAS Portal before running the SQL*PLUS script. If it does not, an invalid package may be created.
Table A-74 indicates which commands can use the P_DESCRIPTION
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
yes |
no |
no |
no |
Use P_DESCRIPTION
to specify the text that provides additional information about the report. This keyword is only used when DTYPE=REGISTER
.
P_DESCRIPTON=
description_text
description_text
Any text string.
None
Table A-75 indicates which commands can use the P_FORMATS
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
yes |
no |
no |
no |
Use P_FORMATS
to specify the allowable destination formats for the specified reports. This keyword is only used when DTYPE=REGISTER
.
P_FORMATS=
destination_format|(destination_format1,destination_format2,...)
destination_format
Any valid destination format (e.g., HTML), or a list of valid destination formats enclosed by parentheses with a comma separating the names (e.g., HTMLCSS,PDF,RTF).
None
Table A-76 indicates which commands can use the P_NAME
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
yes |
no |
no |
no |
Use P_NAME
to specify the report name displayed in OracleAS Portal. This keyword is only used when DTYPE=REGISTER
.
P_NAME=
report_name
report_name
Any report name.
If P_NAME
is not specified, the PL/SQL function is populated with the report definition file name.
P_NAME
is not specified, the PL/SQL function is populated with the report definition file name.
P_NAME
only when you want to use the same report name for each report definition file being registered in OracleAS Portal. This option is typically left blank.
Table A-77 indicates which commands can use the P_OWNER
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
yes |
no |
no |
no |
Use P_OWNER
to specify the OracleAS Portal DB Provider that owns a report's package, which is created when the report definition files are registered. This keyword is only used when DTYPE=REGISTER
.
P_OWNER=
portal_dbprovider
portal_dbprovider
Any valid OracleAS Portal DB Provider name.
The name of the OracleAS Portal DB Provider to which you are connected when you run the SQL*PLUS script file.
Table A-78 indicates the commands that can use the P_PFORMTEMPLATE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
yes |
no |
no |
no |
Use P_PFORMTEMPLATE
to specify the name of the OracleAS Portal template that determines the style of the Runtime Parameter Form. This keyword is only used when DTYPE=REGISTER
.
P_PFORMTEMPLATE=
template_name
template_name
Any valid OracleAS Portal template name.
None
Table A-79 indicates the commands that can use the P_PRINTERS
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
yes |
no |
no |
no |
Use P_PRINTERS
to specify the allowable printers for the specified reports. This keyword is only used when DTYPE=REGISTER
.
P_PRINTERS=
printer_name
printer_name
Any valid printer (e.g., PRT1), or a list of valid printers enclosed by parentheses with a comma separating the names (e.g., (PRT1,PRT2,PRT3)).
None
Access to the printer(s) should already exist in OracleAS Portal before running the SQL*Plus script.
Table A-80 indicates which commands can use the P_PRIVILEGE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
yes |
no |
no |
no |
Use P_PRIVILEGE
to specify the users or roles who have access privileges to run the specified reports. This keyword is only used when DTYPE=REGISTER
.
P_PRIVILEGE=
user_name
user_name
Any user name or role that OracleAS Portal can recognize (e.g., SCOTT), or a list of user names or roles enclosed by parentheses with a comma separating the names (e.g., (SCOTT,JABERS,PMARTIN)).
None
Table A-81 indicates which commands can use the P_SERVERS
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
yes |
no |
no |
no |
Use P_SERVERS
to specify the names of the restricted Reports Servers that can run the report. This keyword is only used when DTYPE=REGISTER
.
P_SERVERS=
tnsname
tnsname
Any valid TNS name of the Reports Server (e.g., repserver), or a list of valid Reports Server TNS names enclosed by parentheses with a comma separating the names (e.g., repserver, acct_server, sales_server).
None
Access to the Reports Server(s) should already exist in OracleAS Portal.
Table A-82 indicates the commands that can use the P_TRIGGERS
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
yes |
no |
no |
no |
Use P_TRIGGER
to specify the PL/SQL function that is executed when parameter values are specified on the command line and when users accept the Runtime Parameter Form. The function must return a boolean value (TRUE or FALSE). For example:
P_TRIGGER=Is begin IF UPPER(DESTYPE) = 'PRINTER' AND EMPNAME = 'SMITH' THEN RETURN(TRUE); ELSE RETURN(FALSE); END IF; end;
This keyword is only used when DTYPE=REGISTER
.
P_TRIGGER=
plsql_function
plsql_function
Any valid PL/SQL function that returns a boolean value.
None
Table A-83 indicates which commands can use the P_TYPES
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
yes |
no |
no |
no |
Use P_TYPES
to specify the allowable destination types for the specified reports. This keyword is only used when DTYPE=REGISTER
.
P_TYPES=
destination_type
destination_type
Any valid destination type (e.g., CACHE
), or a list of valid destination types enclosed by parentheses with a comma separating the names (e.g., CACHE
,MAIL
,PRINTER
).
None
Table A-84 indicates which commands can use the PAGEGROUP
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use PAGEGROUP
to specify the name of the Oracle9iAS Portal Release 1 page group to which report output should be pushed. For backward compatibility with earlier versions, see SITENAME (for Oracle WebDB Release 2.2) and CONTENTAREA (for Oracle9iAS Portal Release 1). The page group must be created in Oracle9iAS Portal Release 1 before you can use this keyword.
PAGEGROUP=
pagegroup
pagegroup
Any valid page group name (internal name) used in Oracle9iAS Portal Release 1.
* maintained for backward compatibility with Oracle9iAS Portal Release 1 and/or Oracle WebDB Release 2.2.
Table A-85 indicates which commands can use the PAGESIZE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
yes |
yes |
yes |
no |
Use PAGESIZE
to set the dimensions of the physical page (that is, the size of the page that the printer outputs). The page must be large enough to contain the report. For example, if a frame in a report expands to a size larger than the page dimensions, then the report is not run.
PAGESIZE=
width x height
Any valid page dimensions of the form: page width x page height, where page width and page height are more than zero. The maximum width and height depends which unit of measurement was set in Reports Builder (Edit > Preferences > General tab). For inches, the maximum width and height is 512 inches. For centimeters, it is 1312 centimeters. For picas, it is 36,864 picas.
For bitmap, 8.5 x 11 inches. For character mode, 80 x 66 characters. If the report was designed for character mode and is being run or converted on bitmap, then the following formula is used to determine page size if none is specified: (default page size * character page size)/default character page size. For example, if the character page size is 80 x 20, then the bit-mapped page size would be:
( (8.5 * 80)/80) x ((11 * 20)/66) = (680/80) x (220/66) = 8.5 x 3.33.
PAGESIZE
keyword, then its value overrides the page dimensions of the report definition.
PAGESIZE
value entered on the Runtime Parameter Form overrides any PAGESIZE
value entered on the command line.
Table A-86 indicates which commands can use the PAGESTREAM
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
PAGESTREAM
enables or disables page streaming (pagination) for the report when formatted as HTML or HTMLCSS output, using the navigation controls set by either of the following:
SRW.SET_PAGE_NAVIGATION_HTML
)
PAGESTREAM={YES|NO}
NO
Table A-87 indicates which commands can use the PARAMFORM
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
yes |
yes |
no |
Use PARAMFORM
to specify whether to display the Runtime Parameter Form when you execute a report via CGI or a servlet. PARAMFORM
is used only to supply parameters to paper layout reports, not Web source reports.
PARAMFORM=YES|NO|HTML
YES
Display the Parameter Form.
NO
Do not display the Parameter Form.
HTML
Display the Parameter Form in HTML format.
NO
PARAMFORM=YES
is incompatible with BATCH=YES
because it is not meaningful to have the Runtime Parameter Form appear in batch mode.
PARAMFORM
keyword.
Table A-88 indicates which commands can use the PARSEQUERY
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
yes |
yes |
no |
Use PARSEQUERY
to parse an rwservlet
query and display the constructed Reports Server command line.
http://yourwebserver/reports/rwservlet/parsequery[?][server=servername][&authid= username/password]
See Syntax.
None
Table A-89 indicates which commands can use the PDFCOMP
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use PDFCOMP
to specify whether PDF output should be compressed.
PDFCOMP=
value
|{YES|NO}
value
Any value 0 though 9. A value of 0 means PDF output will not be compressed. A value of 1 through 9 will compress the PDF output and permit users to control the compression level.
YES
Compresses output at compression level 6.
NO
Compresses output at compression level 0 (no compression).
6
Table A-90 indicates which commands can use the PDFEMBED
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use PDFEMBED
to specify whether Oracle Reports will embed the Type1 PostScript font file(s) specified in the uifont.ali
file into PDF output.
PDFEMBED={YES|NO}
YES
The PDF driver will embed the font(s) specified in the [PDF:Embed]
header of the uifont.ali
file into the PDF output.
NO
The font(s) will not be added to PDF output.
YES
Table A-91 indicates which commands can use the PRINTJOB
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
yes |
no |
no |
no |
no |
Use PRINTJOB
to specify whether the Print Job dialog box should be displayed before running a report.
PRINTJOB={YES|NO}
YES
The Print Job dialog box is displayed before the report is run.
NO
The report is run without displaying the Print Job dialog box.
NO
rwrun
, is called from within another executable, such as rwbuilder
), the Print Job dialog box does not appear, regardless of PRINTJOB
.
DESTYPE=MAIL
, the Print Job dialog box does not appear, regardless of PRINTJOB
.
Table A-92 indicates which commands can use the READONLY
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
yes |
yes |
no |
Use READONLY
to request read consistency across multiple queries in a report. When accessing data from Oracle 9i, read consistency is accomplished by a SET TRANSACTION READ ONLY
statement.
Note:
Refer to Oracle9i SQL documentation (available on the Oracle Technology Network, ( |
READONLY={YES|NO}
YES
Requests read consistency.
NO
Do not provide read consistency.
NO
SET TRANSACTION READ ONLY
must be set up before the data fetch occurs.
READONLY
can be used when running JSP-based Web reports from the command line.
Table A-93 indicates which commands can use the RECURSIVE_LOAD
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
yes |
yes |
yes |
no |
Use RECURSIVE_LOAD
to specify whether to validate external references in program units when running a report. If any of the references become invalid, the program unit is automatically recompiled. Setting RECURSIVE_LOAD
to NO
is useful when running your report against a different database than the one against which its PL/SQL was originally compiled.
RECURSIVE_LOAD={YES|NO}
YES
Validates external references when running a report. If any of the references become invalid, the program unit is recompiled (whether it be in .rdf
or .pll
).
NO
Does not validate external references when running a report. This setting is useful when running a report against a different database than the one against which its PL/SQL was originally compiled.
YES
Table A-94 indicates which commands can use the REPLACEITEM
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use REPLACEITEM
to specify that the current report output being pushed to Oracle9iAS Portal Release 1 should replace an earlier version of the same item stored in the same output target.
REPLACEITEM={YES|NO}
YES
Earlier report output should be replaced.
NO
Do not replace previous version. In this case, a link to the new output will be added to a list of links to previous versions of the same report.
None
* maintained for backward compatibility with Oracle9iAS Portal Release 1 and/or Oracle WebDB Release 2.2.
Table A-95 indicates which commands can use the REPLYTO
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use REPLYTO
to specify the e-mail address to which replies should be sent when the sender wants replies to go to someone other than the sender (specified by the FROM keyword).
REPLYTO=
emailid
emailid
A valid e-mail address in the form of someone@foo
.com.
None
Related keywords include BCC,CC,FROM,REPLYTO, and SUBJECT. Note that DESNAME is used to specify the main recipient(s) of the e-mail.
See MODULE|REPORT.
Table A-96 indicates which commands can use the ROLE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use ROLE
to specify the database role to be checked for the report at runtime. This keyword is useful for giving you the ability to run reports that query database tables to which you would not normally have access privileges.
ROLE=
{rolename[/rolepassword]}
None
ROLE
can be used when running JSP-based Web reports from the command line.
Table A-97 indicates which commands can use the RUNDEBUG
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
yes |
yes |
no |
Use RUNDEBUG
to specify that you want extra runtime checking for logical errors in the report. RUNDEBUG
checks for things that are not errors but might result in undesirable output, and displays these as warnings at runtime, before displaying the report output. Using RUNDEBUG
to run a report in debug mode is not the same as debugging a report using the PL/SQL Interpreter.
RUNDEBUG
checks for the following:
RUNDEBUG={YES|NO}
YES
RUNDEBUG
can be used when running JSP-based Web reports from the command line.
Table A-98 indicates which commands can use the SAVE_RDF
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
yes |
yes |
no |
no |
no |
no |
Use SAVE_RDF
to specify a filename for a combined RDF file and XML customization file. This keyword is useful when you combine an existing RDF file with a Oracle Reports XML customization file using the CUSTOMIZE
keyword, and you wish to save the combination to a new RDF file.
SAVE_RDF=
filename
.rdf
filename
.rdf
Any valid file name.
None
You can use SAVE_RDF
with a JSP file, but only the paper layout part, not the Web source.
Table A-99 indicates which commands can use the SCHEDULE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
no |
no |
no |
yes |
yes |
no |
Use SCHEDULE
to set the day, time, and frequency a report should be run. The default is to run the report once, now. Time values are expressed according to a 24-hour day (i.e., one o'clock is expressed 13:00). To eliminate the need for quoting the scheduling command, use underscores (_) instead of spaces. You can also specify an expiration for a report job after a number of runs or on a particular date/time. For example, use:
SCHEDULE=every_first_fri_of_month_from_15:53_Oct_23,_1999_retry_3_after_1_hour_ expires_on_15:53_Oct_23,_2003 SCHEDULE=last_weekday_before_15_from_15:53_Oct_23,_1999_retry_after_1_hour_ expires_after_100
Or:
SCHEDULE="every first fri of month from 15:53 Oct 23, 1999 retry 3 after 1 hour expires on 15:53 Oct 23, 2003" SCHEDULE="last weekday before 15 from 15:53 Oct 23, 1999 retry after 1 hour expires after 100"
SCHEDULE
=string
where the string is:
[FREQ from] TIME [retry {n} after LEN expires {on|after} time|n]
Table A-100 lists and explains the values used in this string.
None
Table A-101 indicates which commands can use the SERVER
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
no |
no |
no |
yes |
yes |
yes |
Use SERVER
to specify the name of the Reports Server you want to use to run this report.
SERVER=servername
The server name or a TNS service entry name if you're using a 6i compatible server.
The server name specified in the REPORTS_SERVER
environment variable for rwcgi.
rwcgi
, you can set the REPORTS_SERVER
environment variable on your Web server machine and omit the SERVER
keyword to process requests using the default server, or you can include the SERVER
keyword to override the default. For jobs run with rwservlet
or as a JSP, you can omit the SERVER
keyword if you have specified a default server in the servlet configuration file, rwservlet.properties
; or you can include the SERVER
keyword to override the default.
SERVER
can be used when running JSP-based Web reports from the command line.
Table A-102 indicates which commands can use the SHOWAUTH
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
yes |
yes |
no |
Use SHOWAUTH
to display the Reports Server logon page and runs the report .
http://yourwebserver/reports/rwservlet/showauth[?][server=servername][&authid=us ername/password]][&nextpage=run report URL][&authtype={s|d}]
See Syntax.
None
authtype=s
the Reports System User Authentication dialog box is displayed. The Reports Database User Authentication dialog box is displayed when authtype=d
.
Table A-103 indicates which commands can use the SHOWENV
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
yes |
yes |
no |
Use SHOWENV
to display the rwservlet
configuration file (rwservlet.properties
).
http://yourwebserver/reports/rwservlet/showenv[?][server=servername][&authid=use rname/password]
See Syntax.
None
Table A-104 indicates which commands can use the SHOWJOBID
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
yes |
no |
no |
SHOWJOBID
shows the status of the Reports Server job with job ID n.
http://yourwebserver/reports/rwservlet/showjobidn[?][server=server_ name][&authid=username/password][&statusformat={html|xml|xmldtd}]
See Syntax.
None
SHOWJOBS
to see the current list of jobs. The STATUSFORMAT
can be set to html (default), xml , or xmldtd to return status in that format. The status information is generated in html, xml, or xmldtd (with an internal dtd subset).
STATUSFORMAT
parameter is only valid for rwservlet, not for rwcgi.
Table A-105 indicates which commands can use the SHOWJOBS
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
yes |
yes |
no |
Use SHOWJOBS
to display a Web view of Reports Server queue status.
http://yourwebserver/reports/rwservlet/showjobs[n][?][server=server_ name][&authid=username/password][&queuetype=current | past | future][&startrow=start_position_in_job_queue][&count=number_of_jobs_to_ display][&statusformat={html|xml|xmldtd}]
See Syntax
None
STATUSFORMAT
can be set to html (default), xml , or xmldtd to return status in that format. The status information is generated in html, xml, or xmldtd (with an internal dtd subset).
QUEUETYPE,STARTROW,COUNT
, and STATUSFORMAT
parameters are valid only for rwservlet
and not for rwcgi
.
Table A-106 indicates which commands can use the SHOWMAP
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
yes |
yes |
no |
Use SHOWMAP
to display rwservlet
key mappings.
http://yourwebserver/reports/rwservlet/showmap[?][server=servername][&authid=use rname/password]
See Syntax.
None
Table A-107 indicates which commands can use the SHOWMYJOBS
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
yes |
no |
no |
Use SHOWMYJOBS
to display the Reports Server queue status for a particular user.
http://yourwebserver/reports/rwservlet/showmyjobs[?][server=server_ name][&authid=username/password][&statusformat={html|xml|xmldtd}]
See Syntax.
None
STATUSFORMAT
can be set to html (default), xml , or xmldtd to return status in that format. The status information is generated in html, xml, or xmldtd (with an internal dtd subset).
STATUSFORMAT
parameter is only valid for rwservlet, not for rwcgi.
Table A-108 indicates which commands can use the SHUTDOWN
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
no |
no |
yes |
Use SHUTDOWN
to shut down a previously running server. You must also use AUTHID to supply a user name and password.
SHUTDOWN={NORMAL|IMMEDIATE}
NORMAL
or IMMEDIATE
NORMAL
The user of the SHUTDOWN
keyword must be an Oracle Reports Administrative user. If the server has security enabled, it will query the security API to determine the user's role eligibility to execute the shutdown (in other words, the user must be an Oracle Reports Administrative user). If security is not enabled, then the user must nonetheless be an Oracle Reports Administrative user defined for that server.
Table A-109 indicates which commands can use the SITENAME
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use SITENAME
to specify the name of the WebDB site to push a report's output to. This keyword is maintained for backward compatibility with Oracle WebDB Release 2.2; for backward compatibility with Oracle9iAS Portal Release 1, see CONTENTAREA. Beginning with OracleAS Portal Release 2, use PAGEGROUP.
SITENAME=
name
name
Any valid site name used in Oracle WebDB Release 2.2.
* maintained for backward compatibility with Oracle9iAS Portal Release 1 and/or Oracle WebDB Release 2.2.
Table A-110 indicates which commands can use the SOURCE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
yes |
no |
no |
no |
Use SOURCE
to specify the report/library or list of reports/libraries to be converted. The rwconverter
command requires that you specify a source report or library.
SOURCE={
source_name
|(
source_name1
,
source_name2
, ...)}
Any valid report/library name or filename, or a list of valid report/library names or filenames enclosed in parentheses and separated by commas (e.g., (qanda, test, dmast)
).
None
(qanda,test,dmast) OR (qanda, test, dmast)
SOURCE
keyword may be operating system-specific.
DTYPE=REGISTER
, you may only want to list report definition files with common parameters, such as destination types and formats, user access, and availability calendars.
Table A-111 indicates which commands can use the SQLTRACE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
yes |
yes |
no |
Use SQLTRACE
to specify whether to perform SQL tracing on your report without modifying the report definition.
SQLTRACE=[YES|NO]
YES
SQL tracing will be performed on the report.
NO
SQL tracing will not be performed on the report.
NO
Table A-112 indicates which commands can use the SSOCONN
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
yes |
no |
no |
Use SSOCONN
to specify one or more connect strings to use to connect to one or more data sources in a Single Sign-On environment.
SSOCONN=key[/type[/conn_str]][,key[/type[/conn_str]]]
For example:
ssoconn=mykey/OracleDB/userid
The following information describes the variable values expressed in the SSOCONN
syntax:
key
refers to a connection string value stored in the Oracle Internet Directory (OID).
type
is a predefined character string that specifies a Reports data source type. Types provided with your Oracle Application Server installation include OracleDB, JDBCPDS (Java Database Connectivity Pluggable Data Source), and ExpressPDS (Oracle Express Pluggable Data Source).
conn_str
is the name of the connection string parameter that rwservlet will compose to run the report
None
ssoconn=key1/type1/conn_str,key2/type2/conn_str2,key3/type3/conn_str3
SSOCONN
option are also available. Table A-113 provides examples.
SSOCONN
in a command line, you cannot:
SINGLESIGNON
set to NO
in rwservlet.properties
.
Doing any of the above with SSOCONN
in the command line results in an error.
option | Description |
---|---|
ssoconn=mkey |
When only the key name is specified, the default type (Oracle DB) will be used, and the connect parameter is the USERID keyword. |
ssoconn=mkey/PDSApp |
When both key name and application type are specified, the connection parameter is the USERID keyword. |
ssoconn=mkey/PDSApp/P_1 |
When everything is specified, the specified values are used. |
SSOCONN
can be used when running JSP-based Web reports from the command line. If you are using the SSOCONN
keyword with a report run as a JSP, use an ampersand(&) to separate connection strings. For example:
http://...:8888/myjsp/foo.jsp?name1=value1&name2=value2 ...
Note: For more information about Oracle Reports and Single Sign-On (SSO), see Configuring and Administering OracleAS Single Sign-On. |
Table A-114 indicates which commands can use the STATUSFOLDER
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use STATUSFOLDER
to specify the name of the Oracle WebDB Release 2.2 or Oracle9iAS Portal Release 1 folder to push status information into. If this is omitted, a new folder is created called Oracle_Reports_Status
. This keyword is maintained for backward compatibility with Oracle WebDB Release 2.2 and Oracle9iAS Portal Release 1. Beginning with OracleAS Portal Release 2, use STATUSPAGE.
STATUSFOLDER=
folder
folder
Any valid folder name (internal name) used in Oracle WebDB Release 2.2 or Oracle9iAS Portal Release 1.
Oracle_Reports_Status
* maintained for backward compatibility with Oracle9iAS Portal Release 1 and/or Oracle WebDB Release 2.2.
Table A-115 indicates which commands can use the STATUSFORMAT
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
yes |
no |
no |
Use STATUSFORMAT
to specify the format for the Web view of Reports Server queue status.
http://
yourwebserver
/rwservlet/showjobs?server=
server_name
&statusformat={html|xml|xmldtd}
HTML
Specify that the Reports queue status output should be in HTML format.
XML
Specify that it should be in XML format.
XMLDTD
Specify that it should be in XML format with in-line Data Type Definition information.
Use STATUSFORMAT
in conjunction with the SHOWJOBS and SHOWMYJOBS keywords.
Table A-116 indicates which commands can use the STATUSPAGE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use STATUSPAGE
to specify the name of the Oracle9iAS Portal Release 1 page to push job status information into. If this is omitted, a new page is created called Oracle_Reports_Status
. For backward compatibility with earlier versions (Oracle WebDB Release 2.2 and Oracle9iAS Portal Release 1), see STATUSFOLDER.
STATUSPAGE=
page
page
Any valid page name (internal name) used in Oracle9iAS Portal Release 1.
Oracle_Reports_Status
* maintained for backward compatibility with Oracle9iAS Portal Release 1 and/or Oracle WebDB Release 2.2.
Table A-117 indicates which commands can use the STYPE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
yes |
no |
no |
no |
Use STYPE
to specify the format of the report(s) or libraries to be converted.
STYPE={PLDFILE|PLLFILE|RDFFILE|REXFILE|XMLFILE|JSPFILE}
Use any one of the following values:
PLDFILE
Source PL/SQL libraries are stored in files in ASCII format.
PLLFILE
Source PL/SQL libraries are stored in files containing source code and P-code (compiled PL/SQL).
RDFFILE
Source report(s) are stored in one or more report definition files (files with the rdf extension).
REXFILE
Source report(s) are stored in one or more text files (files with the rex extension).
XMLFILE
Source report(s) are stored in one or more XML files.
JSPFILE
Source report(s) are stored in one or more JSP files.
RDFFILE
When DTYPE=REGISTER
, choose RDDFILE,REXFILE,XML
, or JSPFILE
for STYPE
.
Table A-118 indicates which commands can use the SUBJECT
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
no |
no |
yes |
yes |
no |
Use SUBJECT
to specify the subject line of an e-mail.
SUBJECT=
any text
Any text.
None
Table A-119 indicates which commands can use the SUPPRESSLAYOUT
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
yes |
yes |
no |
Use SUPPRESSLAYOUT
to specify whether to suppress the formatting of the paper layout at runtime. The keyword allows users to control whether the paper layout in a report is executed at runtime. The most common use of this keyword is to increase the performance of JSP reports. Since a JSP report may have a paper layout and reference objects in it via an <rw:include
> tag, Oracle Reports formats the paper layout before running the JSP section of the report. To improve the performance of single source JSP reports that store both paper and Web layouts but do not reference paper layout objects, set SUPPRESSLAYOUT=YES
on the command line.
SUPPRESSLAYOUT=[YES|NO]
YES
Paper layout objects will not be formatted at runtime
NO
Paper layout objects will be formatted at runtime.
NO
Table A-120 indicates which commands can be used with the TOLERANCE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
no |
no |
no |
yes |
yes |
no |
Use TOLERANCE
to set the maximum acceptable time (in minutes) for reusing a report's cached output when a duplicate job is detected. Setting the time tolerance on a report reduces the processing time when duplicate jobs are found.
See Reusing Report Output from Cache for more information on duplicate job detection.
TOLERANCE=
time_string
time_string
Can be in one of two formats:
n
{
unit
}
, for a number with an optional unit. The unit can be minute(s), hour(s), or day(s). The default unit is minute(s) if no unit is specified.
{
Mon DD
,
YYYY
}
hh
:
mi
:
ss
am|pm {
timezone
}
, for a date/time format. Date information is optional. If it isn't specified, today is assumed. Time zone is also optional. If it isn't specified, the Reports Server's timezone is used. The date/time is always in a US locale. This format is the same as defined in the Java DateFormat.MEDIUM type.
None
TOLERANCE
is not specified, then OracleAS Reports Services reruns the report even if a duplicate report is found in the cache.
TOLERANCE
is not specified or is set to zero.
Table A-121 indicates which commands can use the TRACEFILE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
no |
no |
no |
TRACEFILE
is the name of the file in which trace information is logged.
Note: See Report Trace for additional information about how tracing works with Oracle Reports. |
TRACEFILE=
tracefile
Any valid file name.
None
server_name
.conf
(see Configuring OracleAS Reports Services). Tracing for the Reports Servlet is configured in the servlet configuration file, rwservlet.properties
(see Configuring OracleAS Reports Services). Tracing for individual jobs is specified from the runtime command line, via the TRACEOPTS
command line option.
TRACEMODE
setting.
rdf
file. You cannot specify logging when running a .rep file.
TRACEOPTS=TRACELOG
or TRACEOPTS=TRACEERR
as well as TRACEFILE
, all of the trace information will be placed in the most recently specified file. For example, in the following case, all of the specified trace information would be placed in err.log
because it is the last file specified in the RWRUN
command.
RWRUN MODULE=order_entry USERID=scott/tiger TRACEFILE=trace.log LOGFILE=mylog.log ERRFILE=err.log
Table A-122 indicates which commands can use the TRACEMODE
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
yes |
yes |
no |
TRACEMODE
specifies whether to append new trace information to existing information in the file specified by TRACEFILE
, or overwrite the entire file.
TRACEMODE={TRACE_APPEND|TRACE_REPLACE}
TRACE_APPEND
TRACE
keywords. But for server security, in a server environment you can use only TRACEOPTS
. This is to prevent files from being written to the server.
server_name
.conf
. Tracing for the Reports Servlet is configured in the servlet configuration file, rwservlet.properties
. Tracing for individual jobs is specified from the runtime command line, via the TRACE
command line arguments. See Report Trace for additional information about how tracing works with Oracle Reports.
rep
file.
Table A-123 indicates which commands can use the TRACEOPTS
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
no |
yes |
yes |
yes |
TRACEOPTS
indicates the tracing information that you want to be logged in the trace file when you run the report.
TRACEOPTS={TRACE_ALL|TRACE_APP|TRACE_BRK|TRACE_DBG|TRACE_DST|TRACE_ERR|TRACE_EXC|TRACE_INF|TRACE_LOG|TRACE_PLS|TRACE_PRF|TRACE_SQL|TRACE_STA|TRACE_TMS|TRACE_WRN}
The following values apply:
TRACE_ALL
Log all possible trace information in the trace file.
TRACE_APP
Log trace information on all the report objects in the trace file.
TRACE_BRK
List all breakpoints in the trace file.
TRACE_DBG
Log debug information.
TRACE_DST
List distribution lists in the trace file. You can use this information to determine which section was sent to which destination.
TRACE_ERR
List error messages and warnings in the trace file.
TRACE_EXC
List Reports Server exceptions.
TRACE_INF
Dumps any information not covered by the other options into the trace file.
TRACE_LOG
Duplicate log information in your trace file. If you have specified a log element, in addition to a trace element, in your server configuration file, this value will cause information that is sent to the log file to also be sent to the trace file.
TRACE_PLS
Log trace information on all the PL/SQL objects in the trace file.
TRACE_PRF
Log performance statistics in the trace file.
TRACE_SQL
Log trace information on all the SQL in the trace file.
TRACE_STA
Provide server and engine state information, such as initialize, ready, run, and shut-down.
TRACE_TMS
Enter a timestamp for each entry in the trace file.
TRACE_WRN
List server warning messages.
TRACE_ALL
TRACE
keywords. But for server security, in a server environment you can use only TRACEOPTS
. This is to prevent files from being written to the server.
server_name
.conf
. Tracing for the Reports Servlet is configured in the servlet configuration file, rwservlet.properties
. Tracing for individual jobs is specified from the runtime command line, via the TRACExxx
command line arguments. See Report Trace for additional information about how tracing works with Oracle Reports.
TRACE_OPTS=(TRACE_APP, TRACE_PRF)
means you want both TRACE_APP
and TRACE_PRF
applied.
rdf
file. You cannot specify logging when running a .rep file.
TRACEOPTS
can be used when running JSP-based Web reports from the command line.
Table A-124 indicates which commands can use the UNINSTALL
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
no |
no |
no |
yes |
Use UNINSTALL
to remove an instance of the Reports Server from Microsoft Windows. This process removes the Reports Server service from the system. This keyword is ignored on UNIX.
UNINSTALL
reports_server_name
reports_server_name
The name of an existing Reports Server instance
None
If you use BATCH=YES
with INSTALL
, then none of the prompts and dialogs that normally display during the removal process will appear.
Table A-121 indicates which commands can use the UPGRADE_PLSQL
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
no |
yes |
no |
no |
no |
Use UPGRADE_PLSQL
to specify whether to upgrade any PL/SQL code in the report to the latest version required by Oracle Reports Developer.
UPGRADE_PLSQL=[YES|NO]
YES
Table A-126 indicates which commands can use the URLPARAMETER
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
no |
no |
no |
yes |
yes |
no |
Use URLPARAMETER
to specify the URL that is to be fetched with the URL engine.
URLPARAMETER=http://webserver_name/pagename.html
Any valid URL.
None
This keyword is relevant when the jobType parameter of the job element in the Reports Server configuration file is rwurl
, and a URL engine is in place.
Table A-127 indicates which commands can use the USERID
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
yes |
yes |
yes |
yes |
yes |
yes |
no |
Use USERID
only if you're not using Single Sign-On. Use USERID
to specify your Oracle user name and password, with an optional database name for accessing a remote database. If the password is omitted, then a database logon form opens automatically before the user is allowed to run the report.
If you want users to log on to the database, then omit the password portion of the USERID
keyword from the report request. If you want users to log on every time they run report requests, then use the Oracle Reports key mapping file, cgicmd.dat
, to specify the runtime command, and include the %D option in the relevant key mapping entry.
Note:
For information on using the |
userid=
username[/password
][@database]
username
Username assigned by the database administrator.
password
Password for the username.
database
The name of the database you are accessing.
None
USERID
can be used when running JSP-based Web reports from the command line.
Table A-128 indicates which commands can use the WEBSERVER_DEBUG
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
yes |
no |
no |
no |
no |
Use WEBSERVER_DEBUG
for JSP debugging. It creates the stderr.log
and stdout.log
files under the docroot
/
port#
directory, and leaves temporary JSP files under docroot
/
port#
/
default
and log files under docroot
/
port#
/log
for your inspection.
WEBSERVER_DEBUG={YES|NO}
YES
Create debugging files.
NO
Do not create debugging files.
NO
Table A-129 indicates which commands can use the WEBSERVER_DOCROOT
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
yes |
no |
no |
no |
no |
Use WEBSERVER_DOCROOT
to set the Reports Builder document root directory. All files you reference in your JSP, such as images, HTML, and the like, should be relative to this directory. By setting the document root to your working directory, you avoid having to copy these files around.
WEBSERVER_DOCROOT=
REPORTS_TMP/docroot
For example:
WEBSERVER_DOCROOT=c:/temp/docroot
The directory to the document root folder in your Oracle Reports temporary folder.
None
Table A-130 indicates which commands can use the WEBSERVER_PORT
keyword.
rwclient | rwrun | rwbuilder | rwconverter | rwservlet | rwcgi | rwserver |
---|---|---|---|---|---|---|
no |
no |
yes |
no |
no |
no |
no |
Use WEBSERVER_PORT
to specify the port number an internal Web server listens to. You can specify a port number (e.g., 3002) or a range of port numbers (e.g., 3100-3200). If a single port number is specified, Oracle Reports tries to start the internal Web server listening on that port. If that port is in use, it tries to get the next available port. If a range of port numbers is specified, Oracle Reports tries to look for a free port in that range.
WEBSERVER_PORT=port num
port num
Any valid port number or range of port numbers.
Port = 3000
Range of ports = 3000-3010.
1
Oracle Application Server instance
2
Port where the Reports servlet is running
3
Secured server only
4
Web server running the CGI scripts
5
Web server listener port
6
Web server installed on the Windows operating system
7
Web server installed on any UNIX operating system
8
Secured server only
|
Copyright © 2003 Oracle Corporation. All Rights Reserved. |
|