Previous Next

Performs an SQL query directly against the RDBMS, bypassing the USoft Rules Engine.

Use this command only if you have special reasons to bypass the USoft Rules Engine. Otherwise, prefer pc:SqlStatement.


    statement="rdbms-query" >

The required rdbms and connectstr identify the database connection through which you want to access the data.

The required user and pwd identify the username/password combination needed to access the database table(s) that you want to query.

The required statement is the query statement. Its syntax must be supported by the RDBMS platform that you are using.

On Oracle, database is optional and may be used to identify the table owner if this owner is distinct from owner.

On SQL Server, database is required and identifies the database in the SQL Server instance where the table(s) reside.



   connectstr="  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = L3100100247.usoft.com)(PORT = 1521))

Return value

The return value of the Example could look like this:

  <Record MAX_AGE="" />
  <Record MAX_AGE="65" />
  <Record MAX_AGE="65" />
  <Record MAX_AGE="80" />


See also