Home » Developer & Programmer » Reports & Discoverer » Discoverer launched in command line : Parameters ? (Discoverer Desktop)
Discoverer launched in command line : Parameters ? [message #320750] Fri, 16 May 2008 03:24 Go to next message
Messages: 14
Registered: April 2008
Junior Member

I launch Discoverer in command line, with this line:
start I:\oracle\BIToolsHome_1\bin\dis51usr.exe /CONNECT $2/$3 /OPENDB "$1" /SHEET all

$1 meaning the query
$2 meaning the user
$3 meaning the password

I'd like to be able to add some arguments, that could be used in the query (in a the "where" section of the query for example). For example, if i had a query with a condition on the year, I'd like to be able to launch my query directly with the condition "year" fixed at 2008. The command line would be close to this :
start I:\oracle\BIToolsHome_1\bin\dis51usr.exe /CONNECT $2/$3 /OPENDB "$1" /SHEET all /PARAMS "2008"

Is it possible ?
Thanks for your help

[Updated on: Fri, 16 May 2008 03:28]

Report message to a moderator

Re: Discoverer launched in command line : Parameters ? [message #321145 is a reply to message #320750] Mon, 19 May 2008 04:20 Go to previous message
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
From the documentation:

This command enables you to set a specified parameter to a specified value.

Information Details
/parameter <parameter name> <parameter value>

If the end user does not specify a value for a parameter in a workbook then Discoverer uses a default value.
dis51usr.exe /parameter year 2001

Previous Topic: How to dynamic set the ole container source in Report Builder
Next Topic: selectiuon date
Goto Forum:

Current Time: Wed Jul 26 12:22:30 CDT 2017

Total time taken to generate the page: 0.10674 seconds