> ## 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.

# InsertRecordsRequest.Options

> InsertRecordsRequest.Options — Kinetica Java API

<div className="kinetica-javadoc">
  <div className="header">
    <div className="sub-title"><span className="package-label-in-type">Package</span> <a href="/content/api/java/com/gpudb/protocol/package-summary">com.gpudb.protocol</a></div>
    <h1 title="Class InsertRecordsRequest.Options" className="title">Class InsertRecordsRequest.Options</h1>
  </div>

  <div className="inheritance" title="Inheritance Tree">
    <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" className="external-link">java.lang.Object</a>
    <div className="inheritance">com.gpudb.protocol.InsertRecordsRequest.Options</div>
  </div>

  <div className="section class-description" id="class-description">
    <div className="dl notes">
      <div className="dt">Enclosing class:</div>
      <div className="dd"><code><a href="/content/api/java/com/gpudb/protocol/InsertRecordsRequest" title="class in com.gpudb.protocol">InsertRecordsRequest</a>\<<a href="/content/api/java/com/gpudb/protocol/InsertRecordsRequest" title="type parameter in InsertRecordsRequest">T</a>></code></div>
    </div>

    <hr />

    <div className="type-signature"><span className="modifiers">public static final class </span><span className="element-name type-name-label">InsertRecordsRequest.Options</span> <span className="extends-implements">extends <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" className="external-link">Object</a></span></div>

    <div className="block">
      A set of string constants for the <a href="/content/api/java/com/gpudb/protocol/InsertRecordsRequest" title="class in com.gpudb.protocol"><code>InsertRecordsRequest</code></a> parameter <a href="/content/api/java/com/gpudb/protocol/InsertRecordsRequest#getOptions()"><code>options</code></a>.
      <p> Optional parameters.</p>
    </div>
  </div>

  <div className="section summary">
    <ul className="summary-list">
      <li>
        <div className="section field-summary" id="field-summary">
          <h2>Field Summary</h2>
          <div className="caption"><span>Fields</span></div>

          <div className="summary-table three-column-summary">
            <div className="table-header col-first">Modifier and Type</div>
            <div className="table-header col-second">Field</div>
            <div className="table-header col-last">Description</div>
            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#ALLOW_PARTIAL_BATCH" className="member-name-link">ALLOW\_PARTIAL\_BATCH</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">If set to <a href="#TRUE"><code>TRUE</code></a>, all correct records will be inserted and incorrect records will be rejected and reported.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#DRY_RUN" className="member-name-link">DRY\_RUN</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">If set to <a href="#TRUE"><code>TRUE</code></a>, no data will be saved and any errors will be returned.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#ENABLE_INPLACE_UPDATES" className="member-name-link">ENABLE\_INPLACE\_UPDATES</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Applies only when upserting (when <a href="#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="#TRUE"><code>TRUE</code></a>).</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#FALSE" className="member-name-link">FALSE</a></code></div>
            <div className="col-last odd-row-color"> </div>
            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#IGNORE_EXISTING_PK" className="member-name-link">IGNORE\_EXISTING\_PK</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Specifies the record collision error-suppression policy for inserting into a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>, only used when not in upsert mode (upsert mode is disabled when <a href="#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="#FALSE"><code>FALSE</code></a>).</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#PK_CONFLICT_PREDICATE_HIGHER" className="member-name-link">PK\_CONFLICT\_PREDICATE\_HIGHER</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">The record with higher value for the column resolves the primary-key insert conflict.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#PK_CONFLICT_PREDICATE_LOWER" className="member-name-link">PK\_CONFLICT\_PREDICATE\_LOWER</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">The record with lower value for the column resolves the primary-key insert conflict.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#REQUEST_SCHEMA_STR" className="member-name-link">REQUEST\_SCHEMA\_STR</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Type schema of <a href="/content/api/java/com/gpudb/protocol/InsertRecordsRequest#getData()"><code>data</code></a> (when <code>listEncoding</code> is <code>BINARY</code>), in \[\["{"{"}column\_name{"}"}","{"{"}column\_type{"}"}"]] format.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#RETURN_INDIVIDUAL_ERRORS" className="member-name-link">RETURN\_INDIVIDUAL\_ERRORS</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">If set to <a href="#TRUE"><code>TRUE</code></a>, success will always be returned, and any errors found will be included in the info map.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#RETURN_RECORD_IDS" className="member-name-link">RETURN\_RECORD\_IDS</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">If <a href="#TRUE"><code>TRUE</code></a> then return the internal record id along for each inserted record.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#TRANSFORMATIONS" className="member-name-link">TRANSFORMATIONS</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Comma-separated expressions, one per target table column.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#TRUE" className="member-name-link">TRUE</a></code></div>
            <div className="col-last odd-row-color"> </div>
            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#TRUNCATE_STRINGS" className="member-name-link">TRUNCATE\_STRINGS</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">If set to <a href="#TRUE"><code>TRUE</code></a>, any strings which are too long for their target charN string columns will be truncated to fit.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#UPDATE_ON_EXISTING_PK" className="member-name-link">UPDATE\_ON\_EXISTING\_PK</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Specifies the record collision policy for inserting into a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>.</div>
            </div>
          </div>
        </div>
      </li>

      <li>
        <div className="section method-summary" id="method-summary">
          <h2>Method Summary</h2>

          <div className="inherited-list">
            <h3 id="methods-inherited-from-class-java.lang.Object">Methods inherited from class java.lang.<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" className="external-link">Object</a></h3>
            <code><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#clone()" title="class or interface in java.lang" className="external-link">clone</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#equals(java.lang.Object)" title="class or interface in java.lang" className="external-link">equals</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#finalize()" title="class or interface in java.lang" className="external-link">finalize</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#getClass()" title="class or interface in java.lang" className="external-link">getClass</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#hashCode()" title="class or interface in java.lang" className="external-link">hashCode</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#notify()" title="class or interface in java.lang" className="external-link">notify</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#notifyAll()" title="class or interface in java.lang" className="external-link">notifyAll</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#toString()" title="class or interface in java.lang" className="external-link">toString</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#wait()" title="class or interface in java.lang" className="external-link">wait</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#wait(long)" title="class or interface in java.lang" className="external-link">wait</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#wait(long,int)" title="class or interface in java.lang" className="external-link">wait</a></code>
          </div>
        </div>
      </li>
    </ul>
  </div>

  <div className="section details">
    <ul className="details-list">
      <li>
        <div className="section field-details" id="field-detail">
          <h2>Field Details</h2>

          <ul className="member-list">
            <li>
              <div className="section detail" id="UPDATE_ON_EXISTING_PK">
                <h3>UPDATE\_ON\_EXISTING\_PK</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">UPDATE\_ON\_EXISTING\_PK</span></div>

                <div className="block">
                  Specifies the record collision policy for inserting into a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>. If set to <a href="#TRUE"><code>TRUE</code></a>, any existing table record with primary key values that match those of a record being inserted will be replaced by that new record (the new data will be "upserted"). If set to <a href="#FALSE"><code>FALSE</code></a>, any existing table record with primary key values that match those of a record being inserted will remain unchanged, while the new record will be rejected and the error handled as determined by <a href="#IGNORE_EXISTING_PK"><code>IGNORE\_EXISTING\_PK</code></a>, <a href="#ALLOW_PARTIAL_BATCH"><code>ALLOW\_PARTIAL\_BATCH</code></a>, and <a href="#RETURN_INDIVIDUAL_ERRORS"><code>RETURN\_INDIVIDUAL\_ERRORS</code></a>. If the specified table does not have a primary key, then this option has no effect. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a>: Upsert new records when primary keys match existing records. </li>
                    <li><a href="#FALSE"><code>FALSE</code></a>: Reject new records when primary keys match existing records. </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsRequest.Options.UPDATE_ON_EXISTING_PK">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="TRUE">
                <h3>TRUE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">TRUE</span></div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsRequest.Options.TRUE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="FALSE">
                <h3>FALSE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">FALSE</span></div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsRequest.Options.FALSE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="ENABLE_INPLACE_UPDATES">
                <h3>ENABLE\_INPLACE\_UPDATES</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">ENABLE\_INPLACE\_UPDATES</span></div>

                <div className="block">
                  Applies only when upserting (when <a href="#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="#TRUE"><code>TRUE</code></a>). If set to <a href="#TRUE"><code>TRUE</code></a>, an existing record matched by primary key is modified in place. If set to <a href="#FALSE"><code>FALSE</code></a>, it is 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:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#TRUE"><code>TRUE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsRequest.Options.ENABLE_INPLACE_UPDATES">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="IGNORE_EXISTING_PK">
                <h3>IGNORE\_EXISTING\_PK</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">IGNORE\_EXISTING\_PK</span></div>

                <div className="block">
                  Specifies the record collision error-suppression policy for inserting into a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>, only used when not in upsert mode (upsert mode is disabled when <a href="#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="#FALSE"><code>FALSE</code></a>). If set to <a href="#TRUE"><code>TRUE</code></a>, any record being inserted that is rejected for having primary key values that match those of an existing table record will be ignored with no error generated. If <a href="#FALSE"><code>FALSE</code></a>, the rejection of any record for having primary key values matching an existing record will result in an error being reported, as determined by <a href="#ALLOW_PARTIAL_BATCH"><code>ALLOW\_PARTIAL\_BATCH</code></a> and <a href="#RETURN_INDIVIDUAL_ERRORS"><code>RETURN\_INDIVIDUAL\_ERRORS</code></a>. If the specified table does not have a primary key or if upsert mode is in effect (<a href="#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="#TRUE"><code>TRUE</code></a>), then this option has no effect. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a>: Ignore new records whose primary key values collide with those of existing records. </li>
                    <li><a href="#FALSE"><code>FALSE</code></a>: Treat as errors any new records whose primary key values collide with those of existing records. </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsRequest.Options.IGNORE_EXISTING_PK">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="PK_CONFLICT_PREDICATE_HIGHER">
                <h3>PK\_CONFLICT\_PREDICATE\_HIGHER</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">PK\_CONFLICT\_PREDICATE\_HIGHER</span></div>
                <div className="block">The record with higher value for the column resolves the primary-key insert conflict. The default value is ''.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsRequest.Options.PK_CONFLICT_PREDICATE_HIGHER">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="PK_CONFLICT_PREDICATE_LOWER">
                <h3>PK\_CONFLICT\_PREDICATE\_LOWER</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">PK\_CONFLICT\_PREDICATE\_LOWER</span></div>
                <div className="block">The record with lower value for the column resolves the primary-key insert conflict. The default value is ''.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsRequest.Options.PK_CONFLICT_PREDICATE_LOWER">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="RETURN_RECORD_IDS">
                <h3>RETURN\_RECORD\_IDS</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">RETURN\_RECORD\_IDS</span></div>

                <div className="block">
                  If <a href="#TRUE"><code>TRUE</code></a> then return the internal record id along for each inserted record. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsRequest.Options.RETURN_RECORD_IDS">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="TRUNCATE_STRINGS">
                <h3>TRUNCATE\_STRINGS</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">TRUNCATE\_STRINGS</span></div>

                <div className="block">
                  If set to <a href="#TRUE"><code>TRUE</code></a>, any strings which are too long for their target charN string columns will be truncated to fit. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsRequest.Options.TRUNCATE_STRINGS">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="RETURN_INDIVIDUAL_ERRORS">
                <h3>RETURN\_INDIVIDUAL\_ERRORS</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">RETURN\_INDIVIDUAL\_ERRORS</span></div>

                <div className="block">
                  If set to <a href="#TRUE"><code>TRUE</code></a>, success will always be returned, and any errors found will be included in the info map. The "bad\_record\_indices" entry is a comma-separated list of bad records (0-based). If so, there will also be an "error\_N" entry for each record with an error, where N is the index (0-based). Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsRequest.Options.RETURN_INDIVIDUAL_ERRORS">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="ALLOW_PARTIAL_BATCH">
                <h3>ALLOW\_PARTIAL\_BATCH</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">ALLOW\_PARTIAL\_BATCH</span></div>

                <div className="block">
                  If set to <a href="#TRUE"><code>TRUE</code></a>, all correct records will be inserted and incorrect records will be rejected and reported. Otherwise, the entire batch will be rejected if any records are incorrect. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsRequest.Options.ALLOW_PARTIAL_BATCH">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="DRY_RUN">
                <h3>DRY\_RUN</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">DRY\_RUN</span></div>

                <div className="block">
                  If set to <a href="#TRUE"><code>TRUE</code></a>, no data will be saved and any errors will be returned. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsRequest.Options.DRY_RUN">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="REQUEST_SCHEMA_STR">
                <h3>REQUEST\_SCHEMA\_STR</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">REQUEST\_SCHEMA\_STR</span></div>
                <div className="block">Type schema of <a href="/content/api/java/com/gpudb/protocol/InsertRecordsRequest#getData()"><code>data</code></a> (when <code>listEncoding</code> is <code>BINARY</code>), in \[\["{"{"}column\_name{"}"}","{"{"}column\_type{"}"}"]] format. When non-empty and different from the table's schema, the server remaps the incoming records to the table's full schema. Columns present in the table but absent from this schema are filled using their default values, NULL (if nullable), or an error is returned. If empty, records must match the table's full schema. The default value is ''.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsRequest.Options.REQUEST_SCHEMA_STR">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="TRANSFORMATIONS">
                <h3>TRANSFORMATIONS</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">TRANSFORMATIONS</span></div>
                <div className="block">Comma-separated expressions, one per target table column. Each expression is evaluated per record. Empty entries (two consecutive commas) mean no transformation for that column -- the value is resolved from the input record, table default, NULL, or an error. Expressions may reference input columns by name or by position ($1 for the first input column, $2 for the second, etc.). The default value is ''.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsRequest.Options.TRANSFORMATIONS">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>
          </ul>
        </div>
      </li>
    </ul>
  </div>
</div>