SQLCHN Variable - BBj
For this topic's original documentation, see SQLCHN Variable - Open SQL Channels.
BBj-Specific Information
By default, BBj SQL channel numbers can be any integer from
1 through Integer.MAX_VALUE
(2147483647), but values above 32767 have the potential to confuse legacy
applications that depend on accurate 16-bit integers in the SQLCHN variable.
In BBj 14 and higher, the LEGACY_SQLCHN_LIMIT!COMPAT setting
can be set to TRUE to limit SQLOPEN channel
numbers to values of 32767 or less. This eliminates any possibility of
inadvertently using SQL channel numbers that cannot be accurately reported
in the SQLCHN variable. For example:
READY
>PRINT STBL("!COMPAT","LEGACY_SQLCHN_LIMIT")
LEGACY_SQLCHN_LIMIT=FALSE
>PRINT Integer.MAX_VALUE
2147483647
>SQLOPEN (Integer.MAX_VALUE)"ChileCompany"
>PRINT HTA(SQLCHN)
FFFF
>SQLCLOSE (Integer.MAX_VALUE)
>SQLOPEN (Integer.MAX_VALUE)"ChileCompany"
!ERROR=14 (SQL Channel number can't
be > 32767)
>