Templates

Linkar Framework for .NET and Core

These templates will be used for the SendCommand function for the operations delivery.

This topic contains the following sections:

Conversion Template
Delete Template
Dictionaries Template
Execute Template
Format Template
GetTable Template
GetVersion Template
LkProperties Template
LkSchemas Template
New Template
Read Template
RunSubroutine Template
Select Template
Update Template

Conversion Template

Example

XML

Copy

<COMMAND NAME="CONVERSION">
  <TYPE>ICONV</TYPE>
  <CODE></CODE>
  <EXPRESSIONS></EXPRESSIONS>
  <CUSTOM_VARS></CUSTOM_VARS>
  <OUTPUT_FORMAT>MV</OUTPUT_FORMAT>
</COMMAND>

JSON

Copy

{ "NAME" : "CONVERSION", "COMMAND" :
        {
                "TYPE" : "ICONV" ,
                "CODE" : "" ,
                "EXPRESSIONS" : "" ,
                "CUSTOM_VARS" : "" ,
                "OUTPUT_FORMAT" : "MV"
        }
}

Delete Template

Template for NOT recovery deleted item ID

XML

Copy

<COMMAND NAME="DELETE">
  <OPTIMISTIC_LOCK>False</OPTIMISTIC_LOCK>
  <RECOVER_RECORD_ID_TYPE>NONE</RECOVER_RECORD_ID_TYPE>
  <CUSTOM_VARS></CUSTOM_VARS>
  <INPUT_FORMAT>MV</INPUT_FORMAT>
  <OUTPUT_FORMAT>MV</OUTPUT_FORMAT>
  <FILE_NAME></FILE_NAME>
  <RECORD_IDS>
    <ID><ID>
  </RECORD_IDS>
  <ORIGINAL_RECORD_LIST>
    <ORIGINAL_RECORD>
      <![CDATA[ ... ]]>or XML Tag
    </ORIGINAL_RECORD>
  </ORIGINAL_RECORD_LIST>
</COMMAND>

JSON

Copy

{ "NAME" : "DELETE", "COMMAND" :
        {
                "OPTIMISTIC_LOCK" : "False" ,
                "RECOVER_RECORD_ID_TYPE" : "NONE" ,
                "CUSTOM_VARS" : "" ,
                "INPUT_FORMAT" : "MV" ,
                "OUTPUT_FORMAT" : "MV" ,
                "FILE_NAME" : "" ,
                "RECORD_IDS" :
                [
                        { "ID" : "" }
                ] ,
                "ORIGINAL_RECORD_LIST" :
                [
                        { "ORIGINAL_RECORD" : "" }
                ]
        }
}

Template for recovery deleted item ID type Linkar

XML

Copy

<COMMAND NAME="DELETE">
  <OPTIMISTIC_LOCK>False</OPTIMISTIC_LOCK>
  <RECOVER_RECORD_ID_TYPE>Linkar</RECOVER_RECORD_ID_TYPE>
  <RECOVER_RECORD_ID_PREFIX></RECOVER_RECORD_ID_PREFIX>
  <RECOVER_RECORD_ID_SEPARATOR></RECOVER_RECORD_ID_SEPARATOR>
  <CUSTOM_VARS></CUSTOM_VARS>
  <INPUT_FORMAT>MV</INPUT_FORMAT>
  <OUTPUT_FORMAT>MV</OUTPUT_FORMAT>
  <FILE_NAME></FILE_NAME>
  <RECORD_IDS>
    <ID></ID>
  </RECORD_IDS>
  <ORIGINAL_RECORD_LIST>
    <ORIGINAL_RECORD><![CDATA[ ... ]]> or XML Tag</ORIGINAL_RECORD>
  </ORIGINAL_RECORD_LIST>
</COMMAND>

JSON

Copy

{ "NAME" : "DELETE", "COMMAND" : 
        {
                "OPTIMISTIC_LOCK" : "False" ,
                "RECOVER_RECORD_ID_TYPE" : "Linkar" ,
                "RECOVER_RECORD_ID_PREFIX" : "" ,
                "RECOVER_RECORD_ID_SEPARATOR" : "" ,
                "CUSTOM_VARS" : "" ,
                "INPUT_FORMAT" : "MV" ,
                "OUTPUT_FORMAT" : "MV" ,
                "FILE_NAME" : "" ,
                "RECORD_IDS" : 
                [ 
                                { "ID" : "" }
                ] ,
                "ORIGINAL_RECORD_LIST" : 
                [ 
                                { "ORIGINAL_RECORD" : "" }
                ] 
        }
}

Template for recovery deleted item ID type Custom

XML

Copy

<COMMAND NAME="DELETE">
  <OPTIMISTIC_LOCK>False</OPTIMISTIC_LOCK>
  <RECOVER_RECORD_ID_TYPE>CUSTOM</RECOVER_RECORD_ID_TYPE>
  <CUSTOM_VARS></CUSTOM_VARS>
  <INPUT_FORMAT>MV</INPUT_FORMAT>
  <OUTPUT_FORMAT>MV</OUTPUT_FORMAT>
  <FILE_NAME></FILE_NAME>
  <RECORD_IDS>
    <ID></ID>
  </RECORD_IDS>
  <ORIGINAL_RECORD_LIST>
    <ORIGINAL_RECORD><![CDATA[ ... ]]> or XML Tag</ORIGINAL_RECORD>
  </ORIGINAL_RECORD_LIST>
</COMMAND>

JSON

Copy

{ "NAME" : "DELETE", "COMMAND" : 
        {
                "OPTIMISTIC_LOCK" : "False" ,
                "RECOVER_RECORD_ID_TYPE" : "CUSTOM" ,
                "CUSTOM_VARS" : "" ,
                "INPUT_FORMAT" : "MV" ,
                "OUTPUT_FORMAT" : "MV" ,
                "FILE_NAME" : "" ,
                "RECORD_IDS" : 
                [ 
                        { "ID" : "" }
                ] ,
                "ORIGINAL_RECORD_LIST" : 
                [ 
                        { "ORIGINAL_RECORD" : "" }
                ] 
        }
}

Dictionaries Template

XML

Copy

<COMMAND NAME="DICTIONARIES">
  <FILE_NAME></FILE_NAME>
  <CUSTOM_VARS></CUSTOM_VARS>
  <OUTPUT_FORMAT>MV</OUTPUT_FORMAT>
</COMMAND>

JSON

Copy

{ "NAME" : "DICTIONARIES", "COMMAND" : 
        { 
                "FILE_NAME" : "" ,
                "CUSTOM_VARS" : "" ,
                "OUTPUT_FORMAT" : "MV"
        }
}

Execute Template

XML

Copy

<COMMAND NAME="EXECUTE">
  <STATEMENT></STATEMENT>
  <CUSTOM_VARS></CUSTOM_VARS>
  <OUTPUT_FORMAT>MV</OUTPUT_FORMAT>
</COMMAND>

JSON

Copy

{ "NAME" : "EXECUTE", "COMMAND" : 
        { 
                "STATEMENT" : "" ,
                "CUSTOM_VARS" : "" ,
                "OUTPUT_FORMAT" : "MV"
        }
}

Format Template

XML

Copy

<COMMAND NAME="FORMAT">
  <FORMAT_SPEC></FORMAT_SPEC>
  <EXPRESSIONS></EXPRESSIONS>
  <CUSTOM_VARS></CUSTOM_VARS>
  <OUTPUT_FORMAT>MV</OUTPUT_FORMAT>
</COMMAND>

JSON

Copy

{ "NAME" : "FORMAT", "COMMAND" : 
        {
                "FORMAT_SPEC" : "" ,
                "EXPRESSIONS" : "" ,
                "CUSTOM_VARS" : "" ,
                "OUTPUT_FORMAT" : "MV"
        }
}

GetTable Template

Template for Schema type LKSCHEMAS

XML

Copy

<COMMAND NAME="GETTABLE" SCHEMATYPE="LKSCHEMAS">
  <USEPROPERTYNAMES>False</USEPROPERTYNAMES>
  <ROWPROPERTIES>False</ROWPROPERTIES>
  <ONLYVISIBLES>False</ONLYVISIBLES>
  <ROWHEADERS>MAINLABEL</ROWHEADERS>
  <REPEATVALUES>False</REPEATVALUES>
  <APPLYCONVERSION>False</APPLYCONVERSION>    
  <APPLYFORMAT>False</APPLYFORMAT>
  <CALCULATED>False</CALCULATED>    
  <PAGINATION>False</PAGINATION>
  <PAGE_NUMBER>1</PAGE_NUMBER>
  <RECORDS_FOR_PAGE>10</RECORDS_FOR_PAGE>
  <CUSTOM_VARS></CUSTOM_VARS>
  <FILE_NAME></FILE_NAME>
  <SELECT_CLAUSE></SELECT_CLAUSE>
  <SORT_CLAUSE></SORT_CLAUSE>
  <DICT_CLAUSE></DICT_CLAUSE>
</COMMAND>

JSON

Copy

{ "NAME" : "GETTABLE", "SCHEMATYPE" : "LKSCHEMAS", "COMMAND" :
        { 
                "USEPROPERTYNAMES" : "False" ,
                "ROWPROPERTIES" : "False" ,
                "ONLYVISIBLES" : "False" ,
                "ROWHEADERS" : "MAINLABEL" ,
                "REPEATVALUES" : "False" ,
                "APPLYCONVERSION" : "False" ,
                "APPLYFORMAT" : "False" ,
                "CALCULATED" : "False" ,                
                "PAGINATION" : "False" ,
                "PAGE_NUMBER" : "1" ,
                "RECORDS_FOR_PAGE" : "10" ,
                "CUSTOM_VARS" : "" ,
                "FILE_NAME" : "" ,
                "SELECT_CLAUSE" : "" ,
                "SORT_CLAUSE" : "", 
                "DICT_CLAUSE" : ""
        }
}

Template for Schema type SQLMODE

XML

Copy

<COMMAND NAME="GETTABLE" SCHEMATYPE="SQLMODE">                
  <ONLYVISIBLES>False</ONLYVISIBLES>                
  <APPLYCONVERSION>False</APPLYCONVERSION>                
  <APPLYFORMAT>False</APPLYFORMAT>                
  <CALCULATED>False</CALCULATED>                
  <PAGINATION>False</PAGINATION>                
  <PAGE_NUMBER>1</PAGE_NUMBER>                
  <RECORDS_FOR_PAGE>10</RECORDS_FOR_PAGE>                
  <CUSTOM_VARS></CUSTOM_VARS>                
  <FILE_NAME></FILE_NAME>                
  <SELECT_CLAUSE></SELECT_CLAUSE>                
  <SORT_CLAUSE></SORT_CLAUSE>                
  <DICT_CLAUSE></DICT_CLAUSE>                
</COMMAND>

JSON

Copy

{ "NAME" : "GETTABLE", "SCHEMATYPE" : "SQLMODE", "COMMAND" :
        { 
                "ONLYVISIBLES" : "False" ,
                "APPLYCONVERSION" : "False" ,
                "APPLYFORMAT" : "False" ,
                "CALCULATED" : "False" ,                                
                "PAGINATION" : "False" ,
                "PAGE_NUMBER" : "1" ,
                "RECORDS_FOR_PAGE" : "10" ,
                "CUSTOM_VARS" : "" ,
                "FILE_NAME" : "" ,
                "SELECT_CLAUSE" : "" ,
                "SORT_CLAUSE" : "", 
                "DICT_CLAUSE" : ""
        }
}

Template for Schema type DICTIONARIES

XML

Copy

<COMMAND NAME="GETTABLE" SCHEMATYPE="DICTIONARIES">
  <ROWHEADERS>MAINLABEL</ROWHEADERS>
  <REPEATVALUES>False</REPEATVALUES>
  <APPLYCONVERSION>False</APPLYCONVERSION>
  <APPLYFORMAT>False</APPLYFORMAT>
  <CALCULATED>False</CALCULATED>              
  <PAGINATION>False</PAGINATION>
  <PAGE_NUMBER>1</PAGE_NUMBER>
  <RECORDS_FOR_PAGE>10</RECORDS_FOR_PAGE>
  <CUSTOM_VARS></CUSTOM_VARS>
  <FILE_NAME></FILE_NAME>
  <SELECT_CLAUSE></SELECT_CLAUSE>
  <SORT_CLAUSE></SORT_CLAUSE>
  <DICT_CLAUSE></DICT_CLAUSE>
</COMMAND>

JSON

Copy

{ "NAME" : "GETTABLE", "SCHEMATYPE" : "DICTIONARIES", "COMMAND" :
        { 
                "ROWHEADERS" : "MAINLABEL" ,
                "REPEATVALUES" : "False" ,
                "APPLYCONVERSION" : "False" ,
                "APPLYFORMAT" : "False" ,
                "CALCULATED" : "False" ,                                
                "PAGINATION" : "False" ,
                "PAGE_NUMBER" : "1" ,
                "RECORDS_FOR_PAGE" : "10" ,
                "CUSTOM_VARS" : "" ,
                "FILE_NAME" : "" ,
                "SELECT_CLAUSE" : "" ,
                "SORT_CLAUSE" : "", 
                "DICT_CLAUSE" : ""
        }
}

Template for Schema type NONE

XML

Copy

<COMMAND NAME="GETTABLE" SCHEMATYPE="NONE">
  <ROWHEADERS>MAINLABEL</ROWHEADERS>
  <REPEATVALUES>False</REPEATVALUES>
  <APPLYCONVERSION>False</APPLYCONVERSION>
  <APPLYFORMAT>False</APPLYFORMAT>
  <CALCULATED>False</CALCULATED>              
  <PAGINATION>False</PAGINATION>
  <PAGE_NUMBER>1</PAGE_NUMBER>
  <RECORDS_FOR_PAGE>10</RECORDS_FOR_PAGE>
  <CUSTOM_VARS></CUSTOM_VARS>
  <FILE_NAME></FILE_NAME>
  <SELECT_CLAUSE></SELECT_CLAUSE>
  <SORT_CLAUSE></SORT_CLAUSE>
  <DICT_CLAUSE></DICT_CLAUSE>
</COMMAND>

JSON

Copy

{ "NAME" : "GETTABLE", "SCHEMATYPE" : "NONE", "COMMAND" :
        { 
                "ROWHEADERS" : "MAINLABEL" ,
                "REPEATVALUES" : "False" ,
                "APPLYCONVERSION" : "False" ,
                "APPLYFORMAT" : "False" ,
                "CALCULATED" : "False" ,                                
                "PAGINATION" : "False" ,
                "PAGE_NUMBER" : "1" ,
                "RECORDS_FOR_PAGE" : "10" ,
                "CUSTOM_VARS" : "" ,
                "FILE_NAME" : "" ,
                "SELECT_CLAUSE" : "" ,
                "SORT_CLAUSE" : "", 
                "DICT_CLAUSE" : ""
        }
}

GetVersion Template

XML

Copy

<COMMAND NAME="GETVERSION">
  <CUSTOM_VARS></CUSTOM_VARS>
  <OUTPUT_FORMAT>MV</OUTPUT_FORMAT>
</COMMAND>

JSON

Copy

{ "NAME" : "GETVERSION", "COMMAND" : 
        { 
                "CUSTOM_VARS" : "" ,
                "OUTPUT_FORMAT" : "MV"
        }
}

LkProperties Template

Template for Schema type LKSCHEMAS

XML

Copy

<COMMAND NAME="LKPROPERTIES" SCHEMATYPE="LKSCHEMAS">
  <USEPROPERTYNAMES>False</USEPROPERTYNAMES>
  <ROWPROPERTIES>False</ROWPROPERTIES>
  <ONLYVISIBLES>False</ONLYVISIBLES>
  <ROWHEADERS>MAINLABEL</ROWHEADERS>
  <PAGINATION>False</PAGINATION>
  <PAGE_NUMBER>1</PAGE_NUMBER>
  <RECORDS_FOR_PAGE>10</RECORDS_FOR_PAGE>
  <CUSTOM_VARS></CUSTOM_VARS>
  <OUTPUT_FORMAT>TABLE</OUTPUT_FORMAT>
  <FILE_NAME></FILE_NAME>
</COMMAND>

JSON

Copy

{ "NAME" : "LKPROPERTIES",  "SCHEMATYPE" : "LKSCHEMAS", "COMMAND" :
        { 
                "USEPROPERTYNAMES" : "False" ,
                "ROWPROPERTIES" : "False" ,
                "ONLYVISIBLES" : "False" ,
                "ROWHEADERS" : "MAINLABEL" ,
                "PAGINATION" : "False" ,
                "PAGE_NUMBER" : "1" ,
                "RECORDS_FOR_PAGE" : "10" ,
                "CUSTOM_VARS" : "" ,
                "OUTPUT_FORMAT" : "TABLE" ,                
                "FILE_NAME" : "" 
        }
}

Template for Schema type SQLMODE

XML

Copy

<COMMAND NAME="LKPROPERTIES" SCHEMATYPE="SQLMODE">
  <ONLYVISIBLES>False</ONLYVISIBLES>
  <PAGINATION>False</PAGINATION>
  <PAGE_NUMBER>1</PAGE_NUMBER>
  <RECORDS_FOR_PAGE>10</RECORDS_FOR_PAGE>
  <CUSTOM_VARS></CUSTOM_VARS>
  <OUTPUT_FORMAT>TABLE</OUTPUT_FORMAT>
  <FILE_NAME></FILE_NAME>
</COMMAND>

JSON

Copy

{ "NAME" : "LKPROPERTIES", "SCHEMATYPE" : "SQLMODE", "COMMAND" :
        { 
                "ONLYVISIBLES" : "False" ,
                "PAGINATION" : "False" ,
                "PAGE_NUMBER" : "1" ,
                "RECORDS_FOR_PAGE" : "10" ,
                "CUSTOM_VARS" : "" ,
                "OUTPUT_FORMAT" : "TABLE" ,                                
                "FILE_NAME" : "" 
        }
}

Template for Schema type DICTIONARIES

XML

Copy

<COMMAND NAME="LKPROPERTIES" SCHEMATYPE="DICTIONARIES">
  <ROWHEADERS>MAINLABEL</ROWHEADERS>
  <PAGINATION>False</PAGINATION>
  <PAGE_NUMBER>1</PAGE_NUMBER>
  <RECORDS_FOR_PAGE>10</RECORDS_FOR_PAGE>
  <CUSTOM_VARS></CUSTOM_VARS>
  <OUTPUT_FORMAT>TABLE</OUTPUT_FORMAT>
  <FILE_NAME></FILE_NAME>
</COMMAND>

JSON

Copy

{ "NAME" : "LKPROPERTIES",  "SCHEMATYPE" : "DICTIONARIES", "COMMAND" :
        { 
                "ROWHEADERS" : "MAINLABEL" ,
                "PAGINATION" : "False" ,
                "PAGE_NUMBER" : "1" ,
                "RECORDS_FOR_PAGE" : "10" ,
                "CUSTOM_VARS" : "" ,
                "OUTPUT_FORMAT" : "TABLE" ,
                "FILE_NAME" : "" 
        }
}

LkSchemas Template

Template for Schema type LKSCHEMAS

XML

Copy

<COMMAND NAME="LKSCHEMAS" SCHEMATYPE="LKSCHEMAS">
  <ROWPROPERTIES>False</ROWPROPERTIES>
  <ONLYVISIBLES>False</ONLYVISIBLES>
  <ROWHEADERS>MAINLABEL</ROWHEADERS>
  <PAGINATION>False</PAGINATION>
  <PAGE_NUMBER>1</PAGE_NUMBER>
  <RECORDS_FOR_PAGE>10</RECORDS_FOR_PAGE>
  <CUSTOM_VARS></CUSTOM_VARS>
  <OUTPUT_FORMAT>TABLE</OUTPUT_FORMAT>
</COMMAND>

JSON

Copy

{ "NAME" : "LKSCHEMAS", "SCHEMATYPE" : "LKSCHEMAS" , "COMMAND" :
        { 
                "ROWPROPERTIES" : "False" ,
                "ONLYVISIBLES" : "False" ,
                "ROWHEADERS" : "MAINLABEL" ,
                "PAGINATION" : "False" ,
                "PAGE_NUMBER" : "1" ,
                "RECORDS_FOR_PAGE" : "10" ,
                "CUSTOM_VARS" : "" ,
                "OUTPUT_FORMAT" : "TABLE"
        }
}

Template for Schema type SQLMODE

XML

Copy

<COMMAND NAME="LKSCHEMAS" SCHEMATYPE="SQLMODE">
  <ONLYVISIBLES>False</ONLYVISIBLES>
  <PAGINATION>False</PAGINATION>
  <PAGE_NUMBER>1</PAGE_NUMBER>
  <RECORDS_FOR_PAGE>10</RECORDS_FOR_PAGE>
  <CUSTOM_VARS></CUSTOM_VARS>
  <OUTPUT_FORMAT>TABLE</OUTPUT_FORMAT>
</COMMAND>

JSON

Copy

{ "NAME" : "LKSCHEMAS", "SCHEMATYPE" : "SQLMODE", "COMMAND" :
        { 
                "ONLYVISIBLES" : "False" ,
                "PAGINATION" : "False" ,
                "PAGE_NUMBER" : "1" ,
                "RECORDS_FOR_PAGE" : "10" ,
                "CUSTOM_VARS" : "" ,
                "OUTPUT_FORMAT" : "TABLE"
        }
}

Template for Schema type DICTIONARIES

XML

Copy

<COMMAND NAME="LKSCHEMAS" SCHEMATYPE="DICTIONARIES">
  <ROWHEADERS>MAINLABEL</ROWHEADERS>
  <PAGINATION>False</PAGINATION>
  <PAGE_NUMBER>1</PAGE_NUMBER>
  <RECORDS_FOR_PAGE>10</RECORDS_FOR_PAGE>
  <CUSTOM_VARS></CUSTOM_VARS>
  <OUTPUT_FORMAT>TABLE</OUTPUT_FORMAT>
</COMMAND>

JSON

Copy

{ "NAME" : "LKSCHEMAS",  "SCHEMATYPE": "DICTIONARIES", "COMMAND" :
        { 
                "ROWHEADERS" : "MAINLABEL" ,
                "PAGINATION" : "False" ,
                "PAGE_NUMBER" : "1" ,
                "RECORDS_FOR_PAGE" : "10" ,
                "CUSTOM_VARS" : "" ,
                "OUTPUT_FORMAT" : "TABLE"
        }
}

New Template

Template for NOT auto item ID generation

XML

Copy

<COMMAND NAME="NEW">
  <READ_AFTER>False</READ_AFTER>
  <CALCULATED>False</CALCULATED>
  <DICTIONARIES>False</DICTIONARIES>
  <CONVERSION>False</CONVERSION>
  <FORMAT_SPEC>False</FORMAT_SPEC>
  <ORIGINAL_RECORDS>False</ORIGINAL_RECORDS>
  <NEW_RECORD_ID_TYPE>Linkar</NEW_RECORD_ID_TYPE>
  <NEW_RECORD_ID_FORMAT_SPEC></NEW_RECORD_ID_FORMAT_SPEC>
  <NEW_RECORD_ID_PREFIX></NEW_RECORD_ID_PREFIX>
  <NEW_RECORD_ID_SEPARATOR></NEW_RECORD_ID_SEPARATOR>
  <CUSTOM_VARS></CUSTOM_VARS>
  <INPUT_FORMAT>MV</INPUT_FORMAT>
  <OUTPUT_FORMAT>MV</OUTPUT_FORMAT>
  <FILE_NAME></FILE_NAME>
  <RECORD_IDS>
    <ID></ID>
  </RECORD_IDS>
  <RECORD_LIST>
    <RECORD><![CDATA[ ... ]]> or XML Tag</RECORD>
  </RECORD_LIST>
</COMMAND>

JSON

Copy

{ "NAME" : "NEW", "COMMAND" : 
        {
                "READ_AFTER" : "False" ,
                "CALCULATED" : "False" ,
                "DICTIONARIES" : "False" ,
                "CONVERSION" : "False" ,
                "FORMAT_SPEC" : "False" ,
                "ORIGINAL_RECORDS" : "False" ,
                "NEW_RECORD_ID_TYPE" : "NONE" ,
                "CUSTOM_VARS" : "" ,
                "INPUT_FORMAT" : "MV" ,
                "OUTPUT_FORMAT" : "MV" ,
                "FILE_NAME" : "" ,
                "RECORD_IDS" : 
                [ 
                        { "ID" : "" }
                ] ,
                "RECORD_LIST" : 
                [ 
                        { "RECORD" : "" }
                ] 
        }
}

Template for generation of item ID type Linkar

XML

Copy

<COMMAND NAME="NEW">
  <READ_AFTER>False</READ_AFTER>
  <CALCULATED>False</CALCULATED>
  <DICTIONARIES>False</DICTIONARIES>
  <CONVERSION>False</CONVERSION>
  <FORMAT_SPEC>False</FORMAT_SPEC>
  <ORIGINAL_RECORDS>False</ORIGINAL_RECORDS>
  <NEW_RECORD_ID_TYPE>Linkar</NEW_RECORD_ID_TYPE>
  <NEW_RECORD_ID_FORMAT_SPEC></NEW_RECORD_ID_FORMAT_SPEC>
  <NEW_RECORD_ID_PREFIX></NEW_RECORD_ID_PREFIX>
  <NEW_RECORD_ID_SEPARATOR></NEW_RECORD_ID_SEPARATOR>
  <CUSTOM_VARS></CUSTOM_VARS>
  <INPUT_FORMAT>MV</INPUT_FORMAT>
  <OUTPUT_FORMAT>MV</OUTPUT_FORMAT>
  <FILE_NAME></FILE_NAME>
  <RECORD_IDS>
    <ID></ID>
  </RECORD_IDS>
  <RECORD_LIST>
    <RECORD><![CDATA[ ... ]]> or XML Tag</RECORD>
  </RECORD_LIST>
</COMMAND>

JSON

Copy

{ "NAME" : "NEW", "COMMAND" : 
        {
                "READ_AFTER" : "False" ,
                "CALCULATED" : "False" ,
                "DICTIONARIES" : "False" ,
                "CONVERSION" : "False" ,
                "FORMAT_SPEC" : "False" ,
                "ORIGINAL_RECORDS" : "False" ,
                "NEW_RECORD_ID_TYPE" : "Linkar" ,
                "NEW_RECORD_ID_FORMAT_SPEC" : "" ,
                "NEW_RECORD_ID_PREFIX" : "" ,
                "NEW_RECORD_ID_SEPARATOR" : "" ,
                "CUSTOM_VARS" : "" ,
                "INPUT_FORMAT" : "MV" ,
                "OUTPUT_FORMAT" : "MV" ,
                "FILE_NAME" : "" ,
                "RECORD_IDS" : 
                [ 
                        { "ID" : "" }
                ] ,
                "RECORD_LIST" : 
                [ 
                        { "RECORD" : "" }
                ] 
        }
}

Template for item ID generation type Custom

XML

Copy

<COMMAND NAME="NEW">
  <READ_AFTER>False</READ_AFTER>
  <CALCULATED>False</CALCULATED>
  <DICTIONARIES>False</DICTIONARIES>
  <CONVERSION>False</CONVERSION>
  <FORMAT_SPEC>False</FORMAT_SPEC>
  <ORIGINAL_RECORDS>False</ORIGINAL_RECORDS>
  <NEW_RECORD_ID_TYPE>CUSTOM</NEW_RECORD_ID_TYPE>
  <CUSTOM_VARS></CUSTOM_VARS>
  <INPUT_FORMAT>MV</INPUT_FORMAT>
  <OUTPUT_FORMAT>MV</OUTPUT_FORMAT>
  <FILE_NAME></FILE_NAME>
  <RECORD_IDS>
    <ID></ID>
  </RECORD_IDS>
  <RECORD_LIST>
    <RECORD><![CDATA[ ... ]]> or XML Tag</RECORD>
  </RECORD_LIST>
</COMMAND>

JSON

Copy

{ "NAME" : "NEW", "COMMAND" : 
        {
                "READ_AFTER" : "False" ,
                "CALCULATED" : "False" ,
                "DICTIONARIES" : "False" ,
                "CONVERSION" : "False" ,
                "FORMAT_SPEC" : "False" ,
                "ORIGINAL_RECORDS" : "False" ,
                "NEW_RECORD_ID_TYPE" : "CUSTOM" ,
                "CUSTOM_VARS" : "" ,
                "INPUT_FORMAT" : "MV" ,
                "OUTPUT_FORMAT" : "MV" ,
                "FILE_NAME" : "" ,
                "RECORD_IDS" : 
                [ 
                        { "ID" : "" }
                ] ,
                "RECORD_LIST" : 
                [ 
                        { "RECORD" : "" }
                ] 
        }
}

Template for item ID generation type Random

XML

Copy

<COMMAND NAME="NEW">
  <READ_AFTER>False</READ_AFTER>
  <CALCULATED>False</CALCULATED>
  <DICTIONARIES>False</DICTIONARIES>
  <CONVERSION>False</CONVERSION>
  <FORMAT_SPEC>False</FORMAT_SPEC>
  <ORIGINAL_RECORDS>False</ORIGINAL_RECORDS>
  <NEW_RECORD_ID_TYPE>RANDOM</NEW_RECORD_ID_TYPE>
  <NEW_RECORD_ID_LENGTH>0</NEW_RECORD_ID_LENGTH>
  <NEW_RECORD_ID_NUMERIC>False</NEW_RECORD_ID_NUMERIC>
  <CUSTOM_VARS></CUSTOM_VARS>
  <INPUT_FORMAT>MV</INPUT_FORMAT>
  <OUTPUT_FORMAT>MV</OUTPUT_FORMAT>
  <FILE_NAME></FILE_NAME>
  <RECORD_IDS>
    <ID></ID>
  </RECORD_IDS>
  <RECORD_LIST>
    <RECORD><![CDATA[ ... ]]> or XML Tag</RECORD>
  </RECORD_LIST>
</COMMAND>

JSON

Copy

{ "NAME" : "NEW", "COMMAND" : 
        {
                "READ_AFTER" : "False" ,
                "CALCULATED" : "False" ,
                "DICTIONARIES" : "False" ,
                "CONVERSION" : "False" ,
                "FORMAT_SPEC" : "False" ,
                "ORIGINAL_RECORDS" : "False" ,
                "NEW_RECORD_ID_TYPE" : "RANDOM" ,
                "NEW_RECORD_ID_LENGTH" : "0" ,
                "NEW_RECORD_ID_NUMERIC" : "False" ,
                "CUSTOM_VARS" : "" ,
                "INPUT_FORMAT" : "MV" ,
                "OUTPUT_FORMAT" : "MV" ,
                "FILE_NAME" : "" ,
                "RECORD_IDS" : 
                [ 
                        { "ID" : "" }
                ] ,
                "RECORD_LIST" : 
                [ 
                        { "RECORD" : "" }
                ] 
        }
}

Read Template

XML

Copy

<COMMAND NAME="READ">
  <CALCULATED>False</CALCULATED>
  <DICTIONARIES>False</DICTIONARIES>
  <CONVERSION>False</CONVERSION>
  <FORMAT_SPEC>False</FORMAT_SPEC>
  <ORIGINAL_RECORDS>False</ORIGINAL_RECORDS>
  <CUSTOM_VARS></CUSTOM_VARS>
  <OUTPUT_FORMAT>MV</OUTPUT_FORMAT>
  <FILE_NAME></FILE_NAME>
  <RECORD_IDS>
    <ID></ID>
  </RECORD_IDS>
  <RECORD_DICTCLAUSE></RECORD_DICTCLAUSE>
</COMMAND>

JSON

Copy

{ "NAME" : "READ", "COMMAND" : 
        { 
                "CALCULATED" : "False" ,
                "DICTIONARIES" : "False" ,
                "CONVERSION" : "False" ,
                "FORMAT_SPEC" : "False" ,
                "ORIGINAL_RECORDS" : "False" ,
                "CUSTOM_VARS" : "" ,
                "OUTPUT_FORMAT" : "MV" ,
                "FILE_NAME" : "" ,
                "RECORD_IDS" : 
                [ 
                        { "ID" : "" } 
                ] ,
                "RECORD_DICTCLAUSE" : ""
        }
}

RunSubroutine Template

XML

Copy

<COMMAND NAME="SUBROUTINE">
  <SUBROUTINE_NAME>SUB.DEMOLINKAR</SUBROUTINE_NAME>
  <NUMBER_OF_ARGUMENTS>3</NUMBER_OF_ARGUMENTS>
  <ARGUMENTS>
    <ARGUMENT></ARGUMENT>
    <ARGUMENT></ARGUMENT>
    <ARGUMENT></ARGUMENT>
  </ARGUMENTS>
  <CUSTOM_VARS></CUSTOM_VARS>
  <OUTPUT_FORMAT>MV</OUTPUT_FORMAT>
</COMMAND>

JSON

Copy

{ "NAME" : "SUBROUTINE", "COMMAND" : 
        { 
                "SUBROUTINE_NAME" : "SUB.DEMOLINKAR" ,
                "NUMBER_OF_ARGUMENTS" : "3" ,
                "ARGUMENTS" : 
                [
                        { "ARGUMENT" : "" } ,
                        { "ARGUMENT" : "" } ,
                        { "ARGUMENT" : "" } 
                ] ,
                "CUSTOM_VARS" : "" ,
                "OUTPUT_FORMAT" : "MV"
        }
}

Select Template

XML

Copy

<COMMAND NAME="SELECT">
  <CALCULATED>False</CALCULATED>
  <DICTIONARIES>False</DICTIONARIES>
  <CONVERSION>False</CONVERSION>
  <FORMAT_SPEC>False</FORMAT_SPEC>
  <ORIGINAL_RECORDS>False</ORIGINAL_RECORDS>
  <ONLY_RECORD_ID>False</ONLY_RECORD_ID>
  <PAGINATION>True</PAGINATION>
  <PAGE_NUMBER>1</PAGE_NUMBER>
  <RECORDS_FOR_PAGE>10</RECORDS_FOR_PAGE>
  <CUSTOM_VARS></CUSTOM_VARS>
  <OUTPUT_FORMAT>MV</OUTPUT_FORMAT>
  <FILE_NAME></FILE_NAME>
  <SELECT_CLAUSE></SELECT_CLAUSE>
  <SORT_CLAUSE></SORT_CLAUSE>
  <DICT_CLAUSE></DICT_CLAUSE>
  <PRESELECT_CLAUSE></PRESELECT_CLAUSE>
</COMMAND>

JSON

Copy

{ "NAME" : "SELECT", "COMMAND" : 
        { 
                "CALCULATED" : "False" ,
                "DICTIONARIES" : "False" ,
                "CONVERSION" : "False" ,
                "FORMAT_SPEC" : "False" ,
                "ORIGINAL_RECORDS" : "False" ,
                "ONLY_RECORD_ID" : "False" ,
                "PAGINATION" : "False" ,
                "PAGE_NUMBER" : "1" ,
                "RECORDS_FOR_PAGE" : "10" ,
                "CUSTOM_VARS" : "" ,
                "OUTPUT_FORMAT" : "MV" ,
                "FILE_NAME" : "" ,
                "SELECT_CLAUSE" : "" ,
                "SORT_CLAUSE" : "", 
                "DICT_CLAUSE" : "" ,
                "PRESELECT_CLAUSE" : ""
        }
}

Update Template

XML

Copy

<COMMAND NAME="UPDATE">
  <READ_AFTER>False</READ_AFTER>
  <CALCULATED>False</CALCULATED>
  <DICTIONARIES>False</DICTIONARIES>
  <CONVERSION>False</CONVERSION>
  <FORMAT_SPEC>False</FORMAT_SPEC>
  <ORIGINAL_RECORDS>False</ORIGINAL_RECORDS>
  <OPTIMISTIC_LOCK>False</OPTIMISTIC_LOCK>
  <CUSTOM_VARS></CUSTOM_VARS>
  <INPUT_FORMAT>MV</INPUT_FORMAT>
  <OUTPUT_FORMAT>MV</OUTPUT_FORMAT>
  <FILE_NAME></FILE_NAME>
  <RECORD_IDS>
    <ID></ID>
  </RECORD_IDS>
  <RECORD_LIST>
    <RECORD><![CDATA[ ... ]]> or XML Tag</RECORD>
  </RECORD_LIST>
  <ORIGINAL_RECORD_LIST>
    <ORIGINAL_RECORD><![CDATA[ ... ]]> or XML Tag</ORIGINAL_RECORD>
  </ORIGINAL_RECORD_LIST>
</COMMAND>

JSON

Copy

{ "NAME" : "UPDATE", "COMMAND" : 
        {
                "READ_AFTER" : "False" ,
                "CALCULATED" : "False" ,
                "DICTIONARIES" : "False" ,
                "CONVERSION" : "False" ,
                "FORMAT_SPEC" : "False" ,
                "ORIGINAL_RECORDS" : "False" ,
                "OPTIMISTIC_LOCK" : "False" ,
                "CUSTOM_VARS" : "" ,
                "INPUT_FORMAT" : "MV" ,
                "OUTPUT_FORMAT" : "MV" ,
                "FILE_NAME" : "" ,
                "RECORD_IDS" : 
                [ 
                        { "ID" : "" }
                ] ,
                "RECORD_LIST" : 
                [ 
                        { "RECORD" : "" }
                ] ,
                "ORIGINAL_RECORD_LIST" : 
                [ 
                        { "ORIGINAL_RECORD" : "" }
                ] 
        }
}