Page Comparison

...

The FeedType_ prefix allows you to address a feedtype individually.

As an example: You , you are extracting records of three feedtypes: SMFEXTRACT, ENTITYEXTRACT, WRHSTRADEEXTRACT.

...

Parameter

Example of Value

Comments

FeedType{_}CustomWhere

Code Block

language	xml

<taskParameter>
    <name>SMFEXTRACT_CustomWhere</name>
    <dataType>S</dataType>
    <value>securitydbo.security_master.security_alias ='15' and rownum < 10</value>
</taskParameter>

CustomWhere CM parameter allows to insert additional code into the WHERE part of the SQL query of an extract.

FeedType{_}ExtractNamePatternEx

Code Block

language	xml

<taskParameter>
    <name>SMFEXTRACT_ExtractNamePatternEx</name>
    <dataType>S</dataType>
    <value>tst_@FeedType_my.xml</value>
</taskParameter>

Customizes output file name according to the pattern specified.
List of valid expressions:

@CorrelationID replaced by initial CorrID (must be always specified, required parameter)

Info

title	Note

If the process is launched via PACE Event Scheduler, its correlation Id is built as a combination of the tag 1177 value given in the PACE event's stream parameters and 'yyyymmddThhmmss' timestamp of the start of the event.

@DateTimeStamp – date-time stamp in format YYYYMMDDHHMISS
@DateStamp – date stamp in format YYYYMMDD
@RecordCount – count of extracted records
@EntityList – passed entity list filter
@EntityID – passed entity id filter
@FeedType – passed feed type
@entityselectiontype – passed value of "entityselectiontype" task parameter
@entityselectiontype2 – passed value of "entityselectiontype2" task parameter
@entityselectionvalue – passed value of "entityselectionvalue" task parameter
@entityselectionvalue2 – passed value of "entityselectionvalue2" task parameter

...

Versions Compared

Old Version 2

New Version 3

Key