- TIBCO BusinessEvents®
- RDBMS
- Database

# Database.createQuery()

## Signature

`String createQuery(String jdbcURI, String cursorName, String resultConceptURI, String sql, int pageSize, Object requestObj)`

## Domain

ACTION, CONDITION, BUI

## Description

Opens a database cursor for the given sql query.

## Parameters

Name | Type | Description
--- | --- | ---
`jdbcURI` | `String` | The JDBC URI of the resource to be used for getting connection.
`cursorName` | `String` | The name of the cursor to be opened
`resultTypeURI` | `String` | a user can retrieve the column values by specifying column names as key
`sql` | `String` | The sql query string, it can be a prepared statement query or a simple statement query.
`pageSize` | `int` | The number of concepts/records to be fetched from the database for each page
`requestObj` | `Object` | array of arguments

## Returns

Type | Description
--- | ---
`String` | The cursor name of the cursor opened

## Cautions

none