Version 4.2.6 for Mainframes
 —  Database Management System Interfaces  —

NSB - Incompatibilities and Constraints

This section lists the known incompatibilities and constraints when using Natural SQL Gateway to access data from from an SQL database system.

This section covers the following topic:


Data Type DECIMAL or NUMERIC

Most SQL database systems support packed decimal numbers with a maximal precision of 31 digits and a scale (fractional part of the number) of up to 31 digits. The scale has to be positive and not greater than the precision. Natural allows only a precision of 29 digits and the scale could not be greater than 7.

Top of page

LOBs

NSB does not support large database objects.

Top of page

Stored Procedures

Natural SQL Gateway does not support stored procedures.

Top of page

Static Execution

Natural SQL Gateway does not support static execution of Natural programs.

Top of page