Back Forward Connect SQL form
Completing the Open tab

About Connect SQL rules

TipAlternative: Starting in V5.3, if your application needs to perform a simple save operation against an external database, it is best practice to use the Connector and Metadata Accelerator to configure access to the rows as an external class. When such external access is configured for an external table, you can use the Obj-Open, Obj-Browse, and other Obj- methods to interact with that table through a class that represents it; you do not need to create SQL connector rules. See About generating connector rules.
However, you can still use the Save tab to enter the SQL statement that saves an instance to the database.

However, you can still use the Open tab to enter a SQL statement that opens a single row in the database and copies its column values as properties onto a clipboard page. To execute the SQL statement on this tab, an activity uses the RDB-Open method.

TipAs a best practice, include only one SQL statement on this tab. If your situation requires multiple statements, place one statement each in separate Connect SQL rules. Your activity can cause the statements to be executed in the desired sequence. STEWS TN 8/22/02 If your situation requires many statements executed in sequence, consider using a stored procedure.

NoteIf the SELECT statement when executed causes no rows to be retrieved, or more than one row to be retrieved, the RDB-Open method produces a fail status, and no properties are added to the step page. TURBT 10/21/02 R-5708?Complete the Browse tab, not the Open tab, if you want to search the database in a way that may result in none, one, or multiple matches.

NoteThe IBM DB2 data type DATE does not directly correspond to any Process Commander property type. Use syntax similar to the following as a workaround: SR-7589 B-14387

SELECT TIMESTAMP(RPT_DATE, '00.00.00') AS ".RPT_DATE"

NoteProperties retrieved by browsing an external database are not tracked for changes by Declare Expression processing.

Field

Description

Open SQL

Follow the guidelines in Data Mapping in SQL. Enter a single SQL statement directly into the text box. Typically this tab contains a SELECT statement, which may include the WHERE and ORDER BY clauses. You can use an EXECUTE statement (or equivalently a CALL statement for Oracle) on this tab. GOLDS 11/15/02

The results of the RDB-Open method are properties and values added to the step page (of the step that contains the RDB-Open method) for the selected row. (If the Step Page column of that step is blank, the system uses the primary page of the activity.)

Error Handler
Flow

SmartPrompt C-1075 Optional. Identify a flow rule that is to be started when this connector rule is started by a flow rule but fails when the Integrator task throws a ConnectorException exception. SARTM 8/21/05 The default flow rule Work-.ConnectionProblem provides one approach for handling such problems. See Handling connector exceptions.

 Test Connectivity  

C-605 After you save this rule, you can click to confirm connectivity to the database. No database operations are performed. See More about Connect SQL rules.

Up About Connect SQL rules