Table of Contents

Property ImportCastClob

Namespace
YndigoBlue.Velocity.Data.Teradata
Assembly
YndigoBlue.Velocity.dll

ImportCastClob

Gets or sets whether CLOB columns are converted to VARCHAR before import operations.

public bool ImportCastClob { get; set; }

Property Value

bool

Remarks

When enabled (default), CLOBs are automatically cast to VARCHAR during import. This provides a significant performance improvement because Teradata can process fixed-width data much faster than variable-length LOBs.

Trade-off:

  • Enabled (True - Default): Much faster imports (often 2-10x faster), but CLOB data is truncated to VarCharCastSize characters (default 32,000). If your CLOBs contain documents or large text, only the first 32,000 characters are imported. The rest is lost.
  • Disabled (False): Slower imports, but full CLOB data is preserved (up to 2GB). Use when data integrity for large text fields is critical and import speed is secondary.

Recommendation: Keep enabled for performance unless you have large CLOBs that must be fully imported.