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:
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.
NSB does not support large database objects.
Natural SQL Gateway does not support stored procedures.
Natural SQL Gateway does not support static execution of Natural programs.
