Limitations of using Lua functions in column map expressions and procedures

Column map expressions and procedures do not support certain data types and Lua functions.

Unsupported data types

The following data types are not supported in column map expressions and procedures:
  • BINARY/VARBINARY
  • XML
  • CLOB/BLOB, DBCLOB
  • ROWID

Numeric data processed in double-precision format

Column map expressions and procedures process numeric data in double-precision format. Use the optim.source.getcolumnasdouble() function to get data from columns that have the following data types. A runtime error is generated if you use optim.source.getcolumnvalue() to get data from columns that have the following data types.
  • BIGINT
  • DECIMAL
  • DOUBLE
  • FLOAT
  • DECIMAL FLOAT
  • NUMBER

Encoding

Optim™ for z/OS® uses native data encoding in internal processing of column map expressions and procedures. This encoding reflects the CCSID of the Optim DB2® plan. Currently an Optim DB2 plan may only be bound with EBCDIC encoding.

Unsupported functions

The following categories of functions are not supported in column map expressions and procedures.
  • Functions for loading and building modules in the Lua package library:
    • module
    • require
    • package.cpath
    • package.loaded
    • package.loaders
    • package.loadlib
    • package.path
    • package.preload
    • package.seeall
  • string.dump()
Parent topic: Working with column map expressions and procedures using Lua functions