Xactly Connect DCL and XSQL Reference Guide

Incent Upload Orders

Incent Upload Orders Summary The incent upload orders command allows developers to load sales transactions into Incent. Sales transactions generally represent a sales event (Example: customer account ABC123 bought 10 widgets from […]

Incent Create Batches

Incent Create Batches Summary Use the incent create batches command to register new sales order batches within Incent (xactly.xc_user_batch). Sales order batches allow Incent to group individual sales orders into common […]

Incent Credential

Incent Credential Summary The incent credential command registers the Incent credentials to use when running any subsequent Incent commands. Syntax incent credential (Username='<username>’, Password='<password>’); incent credential test; Parameters Parameter Description Username='<username>’ […]

Incent Calculate

Incent Calculate Summary The incent calculate command runs compensation calculations within Incent. Syntax incent calculate [credits | incentives] (BatchNames=<list_of_batch_names_to_calculate>); Parameters Parameter Description [credits | incentives] Specifies whether to calculate through to […]

Incent Validate Orders

Incent Validate Orders The INCENT VALIDATE ORDERS command runs standard data validations against all rows and batches in the staging.order_item and staging.order_item_assignment tables. Use the command to validate staged orders before calling INCENT UPLOAD […]

Suspend Schedule

Suspend Schedule Summary The SUSPEND SCHEDULE command indefinitely prevents future invocations of the specified schedule. Syntax suspend schedule [if exists] <schedule_name>; Parameters Parameter Description [if exists] (Optional) Suppresses an XSQL error […]

Show Variables

Show Variables Summary The SHOW VARIABLES command returns a result set listing all variables defined in the environment. Syntax show variables; Parameters None. Details The result set includes metadata for […]

Show Steps

Show Steps Summary The SHOW STEPS command returns a result set listing metadata for all step objects defined in the Connect environment. Syntax show steps;  Parameters None. Details Use the SELECT command to […]

Show Step

Show Step Summary The SHOW STEP command returns a result set containing metadata for the specified step.   Syntax show step <step_name> [labels]; Parameters Parameter Description <step_name> The name of the step. […]

Show Schemas

Show Schemas Summary The SHOW SCHEMAS command returns a result set showing the schemas available in the Connect environment. Syntax show schemas; Parameters None. Details The Connect environment includes four schemas […]