Skip to main content
Version: Staging

SpdrRouteCancel

V8 Message Definiton

Records inserted into this table will result in the cancellation of all active/cancelable orders for the indicated SpiderRock routing code

METADATA

AttributeValue
Topic3985-parent-orders
MLink TokenSystemData
ProductSRTrade
accessTypeSELECT,INSERT,DELETE

Table Definition

FieldTypeKeyDefault ValueComment
routingCodeVARCHAR(65)PRI''SR routing code
sysEnvironmentenum - SysEnvironment'None'original source sys environment Stable Current etc
runStatusenum - RunStatus'None'original source run status ProdBeta
cxlReasonVARCHAR(16)''
altCancelIdVARCHAR(24)''usually client FIX clOrdId of the inbound OrderCancel request
engineNameVARCHAR(32)''set by the engine handling event should be blank on arrival
modifiedByVARCHAR(24)''user who last modified this record
modifiedInenum - SysEnvironment'None'
timestampDATETIME(6)'1900-01-01 00:00:00.000000'timestamp of last modification

PRIMARY KEY DEFINITION (Unique)

FieldSequence
routingCode1

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRTrade`.`MsgSRRouteCancel` (
`routingCode` VARCHAR(65) NOT NULL DEFAULT '' COMMENT 'SR routing code',
`sysEnvironment` ENUM('None','Neptune','Pluto','V7_Stable','V7_Latest','Saturn','Venus','Mars','SysTest','V7_Current') NOT NULL DEFAULT 'None' COMMENT 'original (source) sys environment [Stable, Current, etc]',
`runStatus` ENUM('None','Prod','Beta','UAT','SysTest') NOT NULL DEFAULT 'None' COMMENT 'original (source) run status [Prod,Beta]',
`cxlReason` VARCHAR(16) NOT NULL DEFAULT '',
`altCancelId` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'usually client FIX clOrdId of the inbound OrderCancel request',
`engineName` VARCHAR(32) NOT NULL DEFAULT '' COMMENT 'set by the engine handling event (should be blank on arrival)',
`modifiedBy` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'user who last modified this record',
`modifiedIn` ENUM('None','Neptune','Pluto','V7_Stable','V7_Latest','Saturn','Venus','Mars','SysTest','V7_Current') NOT NULL DEFAULT 'None',
`timestamp` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000' COMMENT 'timestamp of last modification',
PRIMARY KEY USING HASH (`routingCode`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='Records inserted into this table will result in the cancellation of all active/cancelable orders for the indicated SpiderRock routing code';

SELECT TABLE EXAMPLE QUERY

SELECT
`routingCode`,
`sysEnvironment`,
`runStatus`,
`cxlReason`,
`altCancelId`,
`engineName`,
`timestamp`
FROM `SRTrade`.`MsgSRRouteCancel`
WHERE
/* Replace with a VARCHAR(65) */
`routingCode` = 'Example_routingCode';

INSERT TABLE EXAMPLE QUERY

INSERT INTO `SRTrade`.`MsgSRRouteCancel`(
/* Replace with a VARCHAR(65) */
`routingCode`,
/* Replace with a ENUM('None','Neptune','Pluto','V7_Stable','V7_Latest','Saturn','Venus','Mars','SysTest','V7_Current') */
`sysEnvironment`,
/* Replace with a ENUM('None','Prod','Beta','UAT','SysTest') */
`runStatus`,
/* Replace with a VARCHAR(16) */
`cxlReason`,
/* Replace with a VARCHAR(24) */
`altCancelId`,
/* Replace with a VARCHAR(32) */
`engineName`,
/* Replace with a DATETIME(6) */
`timestamp`
)
VALUES(
'Example_routingCode',
'None',
'None',
'Example_cxlReason',
'Example_altCancelId',
'Example_engineName',
'2022-01-01 12:34:56.000000'
);

DELETE TABLE EXAMPLE QUERY

DELETE FROM `SRTrade`.`MsgSRRouteCancel` 
WHERE
/* Replace with a VARCHAR(65) */
`routingCode` = 'Example_routingCode';

Doc Columns Query

SELECT * FROM SRTrade.doccolumns WHERE TABLE_NAME='SpdrRouteCancel' ORDER BY ordinal_position ASC;