PG_CONNECT dbObjIdent, accessIdent_Int, handleIdent_Int, pgSizeIdent_Int, whereIdent_Str, orderByIdent_Str, rowsCountIdent_Int, retCodeIdent_Int [TRANS transHandle_Int] [MODE mode_Int] [ORAHINT hintIdent_Str] |
dbObjIdent | in | Reference to an object of the Database table type. |
accessIdent_Int | in | Value identifier: required access to the table (_DB_READ, _DB_MODIFY). |
handleIdent_Int | out | Identifier for an unique number (handle) of the connection to the table. |
pgSizeIdent_Int | in | Identifier to determine maximal page size. |
whereIdent_Str | in | Identifier of the Text type. Condition to select from the table. |
orderByIdent_Str | in | Identifier of the Text type. Sorting in the final selection. |
rowsCountIdent_Int | out | Identifier of the Int type. The number of rows in the selection. |
retCodeIdent_Int | out | Return code identifier. |
transHandle_Int | in | Identifier for a unique number (handle) for the connection to the database. |
mode_Int | in | Identifier of Int type - 0/1. |
hintIdent_Str | in | Expression of the String type that defines Oracle SQL hint. It is used as an instruction for the performance optimizer of SQL command. The value is used without the opening and terminating characters /*+ <orahint> */. The example is mentioned here. Note: In this situation, Oracle SQL hint is used for ESL action PG_READ, because in ESL action SQL_CONNECT SELECT expression is compounded for next called ESL action PG_READ. |
whereIdent_Str
. This text (a value of the identifier whereIdent_Str
) is used in the clause WHERE in the SQL command. orderByIdent_Str
. The value of the identifier is used in the clause ORDER BY in the SQL command.