A script-enabled browser is required for this page to function properly.

P_JDBCPDS command line keyword

P_JDBCPDS specifies the JDBC pluggable data source (PDS) connection string to connect to a database for running a report containing a JDBC query.

The executables that can use this keyword are:

rwbuilder yes
rwrun yes
rwclient yes
rwcgi yes
rwserver yes
rwservlet yes
rwconverter no

Syntax

P_JDBCPDS=userid/password@database

Values

Description

userid

The user ID for connecting to the JDBC pluggable data source.

password The password for the user ID.
database The database connection information, specific to the particular data source, as detailed in the section titled "Sample Connection Information" in chapter "Configuring and Using the JDBC PDS" in the Oracle Application Server Reports Services Publishing Reports to the Web manual.

Example

P_JDBCPDS=sybuser/sybpwd@server1.mydomain.com:1300

Usage notes

P_JDBCPDS is the default keyword name for connecting to a JDBC PDS. You can change this name in Reports Builder when defining the JDBC query in the Report Wizard. For more information on defining your JDBC query in Reports Builder, see the section titled "Defining and Running a JDBC Query" in chapter "Configuring and Using the JDBC PDS" in the Oracle Application Server Reports Services Publishing Reports to the Web manual.

See also

Command line keywords

Using the command line

Running a report from the command line