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 […]
Xactly Connect DCL and XSQL Reference Guide
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 […]
