Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)FrançaisItaliano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

ABL Data Types Addenda

Dump and load large objects

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Introduction
    • Data types
    • Data type terminology
  • INT64 data type
    • Display Format
    • Related ABL functions
    • INT64 in arithmetic and comparison operations
      • Subtract DATETIME values
      • Mixed INTEGER and INT64 expressions
    • Pass INT64 variables as parameters
    • Determine when to use INT64 versus INTEGER
    • How to specify not to use INT64
  • Large object data types
    • Binary large objects
      • What you can do with BLOB values
      • Restrictions
    • Character large objects
      • What you can do with CLOB values
      • Restrictions
      • CLOB code pages
    • LONGCHAR data type
      • What you can do with LONGCHAR values
      • Restrictions
      • LONGCHAR code pages
  • Use large objects in ABL
    • Copy large objects
      • Convert code pages for CLOB and LONGCHAR values
    • Delete large objects
    • Dump and load large objects
      • Dump large objects
      • Dump all data except large objects
      • Load large objects
    • UNDO subtransactions that contain large object fields
    • Pass LONGCHAR variables as parameters
    • Modify BLOB data
    • Use BLOB values and image files
    • Use BLOB values and word processor files
    • Create a CLOB from a file
  • DATETIME and DATETIME-TZ data types
    • DATETIME data type
    • DATETIME-TZ data type
    • Summary of features
    • Related ABL functions
    • SESSION handle attributes for DATETIME and DATETIME-TZ data types
      • Precedence of default time zone sources for ABL time date functions
    • DATETIME and DATETIME-TZ literals
    • Compare date and datetime values
    • Display formats
      • Display DATETIME data based on display format
      • Display DATETIME-TZ data based on display format
    • DATETIME and DATETIME-TZ limits
    • Datetime arithmetic
      • Add and subtract basic datetime values
      • Add and subtract days plus milliseconds with a datetime value
      • Add, subtract, and obtain specific time intervals
    • Pass DATETIME and DATETIME-TZ as parameters
    • Dump and load DATETIME and DATETIME-TZ fields
  • Arrays
    • Arrays as parameters
    • Pass indeterminate arrays as parameters
    • Deep copy arrays
Table of Contents

Dump and load large objects

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: December 3, 2025
  • 1 minute read
    • OpenEdge
    • Version 13.0
    • Documentation

Use the EXPORT and IMPORT statements to copy BLOB and CLOB data to and from disk.

Note: You can also use the Data Administration tool to IMPORT and EXPORT large objects and to specify a directory for large object files.
Contents
  • Dump large objects
  • Dump all data except large objects
  • Load large objects
TitleResults for “How to create a CRG?”Also Available inAlert