> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# kinetica.RawUpdateRecordsRequest.Options

> kinetica.RawUpdateRecordsRequest.Options — Kinetica C# API

<div className="kinetica-doxygen">
  <div className="contents">
    <p>A set of string constants for the parameter <a className="el" href="/content/api/cs/classkinetica_1_1RawUpdateRecordsRequest#a15fd5b67d823507b3c42b133bd629e47" title="Optional parameters.">RawUpdateRecordsRequest.options</a>. <a href="#details">More...</a></p>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader"> Static Public Attributes</h2>
        </td>
      </tr>

      <tr className="memitem:a14c6420bb0b6665848117ce5bb4b151d" id="r_a14c6420bb0b6665848117ce5bb4b151d">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a14c6420bb0b6665848117ce5bb4b151d">GLOBAL\_EXPRESSION</a> = "global\_expression"</td>
      </tr>

      <tr className="memdesc:a14c6420bb0b6665848117ce5bb4b151d">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">An optional global expression to reduce the search space of the predicates listed in <a className="el" href="/content/api/cs/classkinetica_1_1RawUpdateRecordsRequest#a0d2643602bd15d0081e3d3d0681b6fb3" title="A list of the actual predicates, one for each update; format should follow the guidelines here.">RawUpdateRecordsRequest.expressions</a>. <br /></td>
      </tr>

      <tr className="separator:a14c6420bb0b6665848117ce5bb4b151d">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ababd189ce43fa4aa67275b777629e1d4" id="r_ababd189ce43fa4aa67275b777629e1d4">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ababd189ce43fa4aa67275b777629e1d4">BYPASS\_SAFETY\_CHECKS</a> = "bypass\_safety\_checks"</td>
      </tr>

      <tr className="memdesc:ababd189ce43fa4aa67275b777629e1d4">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">When set to <a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a>, all predicates are available for primary key updates. <br /></td>
      </tr>

      <tr className="separator:ababd189ce43fa4aa67275b777629e1d4">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a8fa93efc7fedf3178946f638fb466e40" id="r_a8fa93efc7fedf3178946f638fb466e40">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a> = "true"</td>
      </tr>

      <tr className="memdesc:a8fa93efc7fedf3178946f638fb466e40">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">A boolean constant for the <a className="el" href="/content/api/cs/structkinetica_1_1RawUpdateRecordsRequest_1_1Options" title="A set of string constants for the parameter RawUpdateRecordsRequest.options.">RawUpdateRecordsRequest.Options</a> options. <br /></td>
      </tr>

      <tr className="separator:a8fa93efc7fedf3178946f638fb466e40">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ac178361ea9bcb4aa3d61801e591069ac" id="r_ac178361ea9bcb4aa3d61801e591069ac">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ac178361ea9bcb4aa3d61801e591069ac">FALSE</a> = "false"</td>
      </tr>

      <tr className="memdesc:ac178361ea9bcb4aa3d61801e591069ac">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">A boolean constant for the <a className="el" href="/content/api/cs/structkinetica_1_1RawUpdateRecordsRequest_1_1Options" title="A set of string constants for the parameter RawUpdateRecordsRequest.options.">RawUpdateRecordsRequest.Options</a> options. <br /></td>
      </tr>

      <tr className="separator:ac178361ea9bcb4aa3d61801e591069ac">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a448b45f4dc63559562fcc97959baae3b" id="r_a448b45f4dc63559562fcc97959baae3b">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a448b45f4dc63559562fcc97959baae3b">UPDATE\_ON\_EXISTING\_PK</a> = "update\_on\_existing\_pk"</td>
      </tr>

      <tr className="memdesc:a448b45f4dc63559562fcc97959baae3b">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Specifies the record collision policy for updating a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>. <br /></td>
      </tr>

      <tr className="separator:a448b45f4dc63559562fcc97959baae3b">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ad59dbb200a3cfc51f6e515bbd3cbfe40" id="r_ad59dbb200a3cfc51f6e515bbd3cbfe40">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ad59dbb200a3cfc51f6e515bbd3cbfe40">IGNORE\_EXISTING\_PK</a> = "ignore\_existing\_pk"</td>
      </tr>

      <tr className="memdesc:ad59dbb200a3cfc51f6e515bbd3cbfe40">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Specifies the record collision error-suppression policy for updating a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>, only used when primary key record collisions are rejected (<a className="el" href="#a448b45f4dc63559562fcc97959baae3b">UPDATE\_ON\_EXISTING\_PK</a> is <a className="el" href="#ac178361ea9bcb4aa3d61801e591069ac">FALSE</a>). <br /></td>
      </tr>

      <tr className="separator:ad59dbb200a3cfc51f6e515bbd3cbfe40">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a7c760fa5ac11adefd826a2631fffa785" id="r_a7c760fa5ac11adefd826a2631fffa785">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a7c760fa5ac11adefd826a2631fffa785">UPDATE\_PARTITION</a> = "update\_partition"</td>
      </tr>

      <tr className="memdesc:a7c760fa5ac11adefd826a2631fffa785">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Force qualifying records to be deleted and reinserted so their partition membership will be reevaluated. <br /></td>
      </tr>

      <tr className="separator:a7c760fa5ac11adefd826a2631fffa785">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a6506e140a10e8c32e43d8644bac07511" id="r_a6506e140a10e8c32e43d8644bac07511">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a6506e140a10e8c32e43d8644bac07511">ENABLE\_INPLACE\_UPDATES</a> = "enable\_inplace\_updates"</td>
      </tr>

      <tr className="memdesc:a6506e140a10e8c32e43d8644bac07511">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If set to <a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a>, qualifying records are modified in place. <br /></td>
      </tr>

      <tr className="separator:a6506e140a10e8c32e43d8644bac07511">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a00b4d609b19b5510c2806ea1991192ec" id="r_a00b4d609b19b5510c2806ea1991192ec">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a00b4d609b19b5510c2806ea1991192ec">TRUNCATE\_STRINGS</a> = "truncate\_strings"</td>
      </tr>

      <tr className="memdesc:a00b4d609b19b5510c2806ea1991192ec">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If set to <a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a>, any strings which are too long for their charN string fields will be truncated to fit. <br /></td>
      </tr>

      <tr className="separator:a00b4d609b19b5510c2806ea1991192ec">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a40a822ca3599debf8d19560c890db460" id="r_a40a822ca3599debf8d19560c890db460">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a40a822ca3599debf8d19560c890db460">USE\_EXPRESSIONS\_IN\_NEW\_VALUES\_MAPS</a> = "use\_expressions\_in\_new\_values\_maps"</td>
      </tr>

      <tr className="memdesc:a40a822ca3599debf8d19560c890db460">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">When set to <a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a>, all new values in <a className="el" href="/content/api/cs/classkinetica_1_1RawUpdateRecordsRequest#ab7ce445e712227aff5b88e0d05c0a012" title="List of new values for the matching records.">RawUpdateRecordsRequest.new\_values\_maps</a> are considered as expression values. <br /></td>
      </tr>

      <tr className="separator:a40a822ca3599debf8d19560c890db460">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a6b9058740868174a1a375bbda91acfd5" id="r_a6b9058740868174a1a375bbda91acfd5">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a6b9058740868174a1a375bbda91acfd5">RECORD\_ID</a> = "record\_id"</td>
      </tr>

      <tr className="memdesc:a6b9058740868174a1a375bbda91acfd5">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">ID of a single record to be updated (returned in the call to <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica#a292bd8df0c03cdf634e72208973515b3">Kinetica.insertRecordsRaw</a> or <a className="el" href="">Kinetica.getRecordsFromCollection</a>). <br /></td>
      </tr>

      <tr className="separator:a6b9058740868174a1a375bbda91acfd5">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>
    </table>

    <h2 className="groupheader">Detailed Description</h2>

    <div className="textblock">
      <p>A set of string constants for the parameter <a className="el" href="/content/api/cs/classkinetica_1_1RawUpdateRecordsRequest#a15fd5b67d823507b3c42b133bd629e47" title="Optional parameters.">RawUpdateRecordsRequest.options</a>. </p>
      <p>Optional parameters.</p>
      <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source#l00081">81</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source">UpdateRecords.cs</a>.</p>
    </div>

    <h2 className="groupheader">Member Data Documentation</h2>
    <h2 className="memtitle"><span className="permalink"><a href="#ababd189ce43fa4aa67275b777629e1d4">◆ </a></span>BYPASS\_SAFETY\_CHECKS</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.RawUpdateRecordsRequest.Options.BYPASS\_SAFETY\_CHECKS = "bypass\_safety\_checks"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>When set to <a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a>, all predicates are available for primary key updates. </p>
        <p>Keep in mind that it is possible to destroy data in this case, since a single predicate may match multiple objects (potentially all of records of a table), and then updating all of those records to have the same primary key will, due to the primary key uniqueness constraints, effectively delete all but one of those updated records. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a> </li>
          <li> <a className="el" href="#ac178361ea9bcb4aa3d61801e591069ac">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#ac178361ea9bcb4aa3d61801e591069ac">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source#l00114">114</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source">UpdateRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a6506e140a10e8c32e43d8644bac07511">◆ </a></span>ENABLE\_INPLACE\_UPDATES</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.RawUpdateRecordsRequest.Options.ENABLE\_INPLACE\_UPDATES = "enable\_inplace\_updates"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>If set to <a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a>, qualifying records are modified in place. </p>
        <p>If set to <a className="el" href="#ac178361ea9bcb4aa3d61801e591069ac">FALSE</a>, they are updated by deleting the existing record and inserting a replacement (delete and insert), which prevents the change from being reflected in dependent materialized views until they are refreshed. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a> </li>
          <li> <a className="el" href="#ac178361ea9bcb4aa3d61801e591069ac">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source#l00271">271</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source">UpdateRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ac178361ea9bcb4aa3d61801e591069ac">◆ </a></span>FALSE</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.RawUpdateRecordsRequest.Options.FALSE = "false"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>A boolean constant for the <a className="el" href="/content/api/cs/structkinetica_1_1RawUpdateRecordsRequest_1_1Options" title="A set of string constants for the parameter RawUpdateRecordsRequest.options.">RawUpdateRecordsRequest.Options</a> options. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source#l00122">122</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source">UpdateRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a14c6420bb0b6665848117ce5bb4b151d">◆ </a></span>GLOBAL\_EXPRESSION</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.RawUpdateRecordsRequest.Options.GLOBAL\_EXPRESSION = "global\_expression"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>An optional global expression to reduce the search space of the predicates listed in <a className="el" href="/content/api/cs/classkinetica_1_1RawUpdateRecordsRequest#a0d2643602bd15d0081e3d3d0681b6fb3" title="A list of the actual predicates, one for each update; format should follow the guidelines here.">RawUpdateRecordsRequest.expressions</a>. </p>
        <p>The default value is ''.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source#l00087">87</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source">UpdateRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ad59dbb200a3cfc51f6e515bbd3cbfe40">◆ </a></span>IGNORE\_EXISTING\_PK</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.RawUpdateRecordsRequest.Options.IGNORE\_EXISTING\_PK = "ignore\_existing\_pk"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Specifies the record collision error-suppression policy for updating a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>, only used when primary key record collisions are rejected (<a className="el" href="#a448b45f4dc63559562fcc97959baae3b">UPDATE\_ON\_EXISTING\_PK</a> is <a className="el" href="#ac178361ea9bcb4aa3d61801e591069ac">FALSE</a>). </p>
        <p>If set to <a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a>, any record update that is rejected for resulting in a primary key collision with an existing table record will be ignored with no error generated. If <a className="el" href="#ac178361ea9bcb4aa3d61801e591069ac">FALSE</a>, the rejection of any update for resulting in a primary key collision will cause an error to be reported. If the specified table does not have a primary key or if <a className="el" href="#a448b45f4dc63559562fcc97959baae3b">UPDATE\_ON\_EXISTING\_PK</a> is <a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a>, then this option has no effect. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a>: Ignore updates that result in primary key collisions with existing records. </li>
          <li> <a className="el" href="#ac178361ea9bcb4aa3d61801e591069ac">FALSE</a>: Treat as errors any updates that result in primary key collisions with existing records. </li>
        </ul>

        <p>The default value is <a className="el" href="#ac178361ea9bcb4aa3d61801e591069ac">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source#l00225">225</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source">UpdateRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a6b9058740868174a1a375bbda91acfd5">◆ </a></span>RECORD\_ID</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.RawUpdateRecordsRequest.Options.RECORD\_ID = "record\_id"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>ID of a single record to be updated (returned in the call to <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica#a292bd8df0c03cdf634e72208973515b3">Kinetica.insertRecordsRaw</a> or <a className="el" href="">Kinetica.getRecordsFromCollection</a>). </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source#l00330">330</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source">UpdateRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a8fa93efc7fedf3178946f638fb466e40">◆ </a></span>TRUE</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.RawUpdateRecordsRequest.Options.TRUE = "true"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>A boolean constant for the <a className="el" href="/content/api/cs/structkinetica_1_1RawUpdateRecordsRequest_1_1Options" title="A set of string constants for the parameter RawUpdateRecordsRequest.options.">RawUpdateRecordsRequest.Options</a> options. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source#l00118">118</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source">UpdateRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a00b4d609b19b5510c2806ea1991192ec">◆ </a></span>TRUNCATE\_STRINGS</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.RawUpdateRecordsRequest.Options.TRUNCATE\_STRINGS = "truncate\_strings"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>If set to <a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a>, any strings which are too long for their charN string fields will be truncated to fit. </p>
        <p>Supported values:</p>

        <ul>
          <li> <a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a> </li>
          <li> <a className="el" href="#ac178361ea9bcb4aa3d61801e591069ac">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#ac178361ea9bcb4aa3d61801e591069ac">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source#l00293">293</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source">UpdateRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a448b45f4dc63559562fcc97959baae3b">◆ </a></span>UPDATE\_ON\_EXISTING\_PK</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.RawUpdateRecordsRequest.Options.UPDATE\_ON\_EXISTING\_PK = "update\_on\_existing\_pk"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Specifies the record collision policy for updating a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>. </p>
        <p>There are two ways that a record collision can occur.</p>
        <p>The first is an "update collision", which happens when the update changes the value of the updated record's primary key, and that new primary key already exists as the primary key of another record in the table.</p>
        <p>The second is an "insert collision", which occurs when a given filter in <a className="el" href="/content/api/cs/classkinetica_1_1RawUpdateRecordsRequest#a0d2643602bd15d0081e3d3d0681b6fb3" title="A list of the actual predicates, one for each update; format should follow the guidelines here.">RawUpdateRecordsRequest.expressions</a> finds no records to update, and the alternate insert record given in <a className="el" href="/content/api/cs/classkinetica_1_1RawUpdateRecordsRequest#a298b02095ef7f723beab204d7c480a94" title="An optional list of new binary-avro encoded records to insert, one for each update.">RawUpdateRecordsRequest.records\_to\_insert</a> (or <a className="el" href="/content/api/cs/classkinetica_1_1RawUpdateRecordsRequest#a70dd78dd99635a09a43fd4fc37f7d944" title="An optional list of JSON encoded objects to insert, one for each update, to be added if the particula...">RawUpdateRecordsRequest.records\_to\_insert\_str</a>) contains a primary key matching that of an existing record in the table.</p>
        <p>If <a className="el" href="#a448b45f4dc63559562fcc97959baae3b">UPDATE\_ON\_EXISTING\_PK</a> is set to <a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a>, "update collisions" will result in the existing record collided into being removed and the record updated with values specified in <a className="el" href="/content/api/cs/classkinetica_1_1RawUpdateRecordsRequest#ab7ce445e712227aff5b88e0d05c0a012" title="List of new values for the matching records.">RawUpdateRecordsRequest.new\_values\_maps</a> taking its place; "insert collisions" will result in the collided-into record being updated with the values in <a className="el" href="/content/api/cs/classkinetica_1_1RawUpdateRecordsRequest#a298b02095ef7f723beab204d7c480a94" title="An optional list of new binary-avro encoded records to insert, one for each update.">RawUpdateRecordsRequest.records\_to\_insert</a> / <a className="el" href="/content/api/cs/classkinetica_1_1RawUpdateRecordsRequest#a70dd78dd99635a09a43fd4fc37f7d944" title="An optional list of JSON encoded objects to insert, one for each update, to be added if the particula...">RawUpdateRecordsRequest.records\_to\_insert\_str</a> (if given).</p>
        <p>If set to <a className="el" href="#ac178361ea9bcb4aa3d61801e591069ac">FALSE</a>, the existing collided-into record will remain unchanged, while the update will be rejected and the error handled as determined by <a className="el" href="#ad59dbb200a3cfc51f6e515bbd3cbfe40">IGNORE\_EXISTING\_PK</a>. If the specified table does not have a primary key, then this option has no effect. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a>: Overwrite the collided-into record when updating a record's primary key or inserting an alternate record causes a primary key collision between the record being updated/inserted and another existing record in the table </li>
          <li> <a className="el" href="#ac178361ea9bcb4aa3d61801e591069ac">FALSE</a>: Reject updates which cause primary key collisions between the record being updated/inserted and an existing record in the table </li>
        </ul>

        <p>The default value is <a className="el" href="#ac178361ea9bcb4aa3d61801e591069ac">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source#l00183">183</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source">UpdateRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a7c760fa5ac11adefd826a2631fffa785">◆ </a></span>UPDATE\_PARTITION</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.RawUpdateRecordsRequest.Options.UPDATE\_PARTITION = "update\_partition"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Force qualifying records to be deleted and reinserted so their partition membership will be reevaluated. </p>
        <p>Supported values:</p>

        <ul>
          <li> <a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a> </li>
          <li> <a className="el" href="#ac178361ea9bcb4aa3d61801e591069ac">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#ac178361ea9bcb4aa3d61801e591069ac">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source#l00245">245</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source">UpdateRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a40a822ca3599debf8d19560c890db460">◆ </a></span>USE\_EXPRESSIONS\_IN\_NEW\_VALUES\_MAPS</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.RawUpdateRecordsRequest.Options.USE\_EXPRESSIONS\_IN\_NEW\_VALUES\_MAPS = "use\_expressions\_in\_new\_values\_maps"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>When set to <a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a>, all new values in <a className="el" href="/content/api/cs/classkinetica_1_1RawUpdateRecordsRequest#ab7ce445e712227aff5b88e0d05c0a012" title="List of new values for the matching records.">RawUpdateRecordsRequest.new\_values\_maps</a> are considered as expression values. </p>
        <p>When set to <a className="el" href="#ac178361ea9bcb4aa3d61801e591069ac">FALSE</a>, all new values in <a className="el" href="/content/api/cs/classkinetica_1_1RawUpdateRecordsRequest#ab7ce445e712227aff5b88e0d05c0a012" title="List of new values for the matching records.">RawUpdateRecordsRequest.new\_values\_maps</a> are considered as constants. NOTE: When <a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a>, string constants will need to be quoted to avoid being evaluated as expressions. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a8fa93efc7fedf3178946f638fb466e40">TRUE</a> </li>
          <li> <a className="el" href="#ac178361ea9bcb4aa3d61801e591069ac">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#ac178361ea9bcb4aa3d61801e591069ac">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source#l00322">322</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source">UpdateRecords.cs</a>.</p>
      </div>
    </div>

    <hr />

    The documentation for this struct was generated from the following files:

    <ul>
      <li>\_build/public-os\_ubuntu24.04-arch\_amd64-cc\_gcc\_13.3.0/install/Kinetica/Protocol/<a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2UpdateRecords_8cs_source">UpdateRecords.cs</a></li>
      <li>Kinetica/Protocol/<a className="el" href="/content/api/cs/Kinetica_2Protocol_2UpdateRecords_8cs_source">UpdateRecords.cs</a></li>
    </ul>
  </div>
</div>
