| Discoverer launched in command line : Parameters ? [message #320750] |
Fri, 16 May 2008 03:24  |
jb084
Messages: 14
Registered: April 2008
|
Junior Member |
|
|
Hello,
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  |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
From the documentation:
/parameter
This command enables you to set a specified parameter to a specified value.
Information Details
Syntax:
/parameter <parameter name> <parameter value>
Modifiers:
None
Restrictions:
If the end user does not specify a value for a parameter in a workbook then Discoverer uses a default value.
Example:
dis51usr.exe /parameter year 2001
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
