Invoke Step

Summary

The INVOKE STEP command executes a step object on the Connect server.

Syntax

invoke [synchronous] step <step_name>;

Parameters

Parameter
Description
[synchronous] When specified, causes the INVOKE STEP command to run completely before returning control to the caller. Otherwise,the step returns immediately but continues to run asynchronously in the background on the Connect server. When running commands from a SQL client, such as isql, be aware that the Connect server may run longer asynchronous steps in the background even though Connect returned control to isql.
<step_name> The name of the step.

Details

By default, steps invoked on the Connect server run asynchronously. For example, you invoke a step interactively from an ODBC client, Connect returns control immediately to the client. Even though Connect returns control to the caller, longer running steps continue to run on the Connect server until completed. Use SHOW INVOCATIONS to determine the processing status of an invoked step.

 

When the step object runs, it creates an invocation. Use SHOW INVOCATION DETAILS and SHOW INVOCATIONS to view the processing status history for both running and completed step invocations.

Examples

// Run the step asynchronously
invoke step s_set_var_period_name;
// Connect returns control to the caller only after the step completes 
invoke synchronous step s_delete_error_tables;

Related Commands

ALTER STEP

CREATE STEP

DROP STEP

INVOKE PIPELINE

SHOW INVOCATION DETAILS

SHOW INVOCATIONS

SHOW STEP

SHOW STEPS