Reference Guide Changes

Changes to the reference guides.

Reference: Building Blocks, Tables, and Procedures

Issue Section Description
CR #693311 Differences from Other SQL Dialects > Altering Tables
This statement is incorrect and should be removed:
  • You can use  MODIFY  to change the maximum length of a character column, as well as converting from one data type to another.
These alteration statements are incorrect and should be removed:
  • In addition to changes for entity and referential integrity, the following types of alterations are allowed: 
    ADD column data-type
MODIFY column data-type
CR #721423 Physical Limitations > Dbspace size The DBspace size entry should state:

Maximum 2000 dbfiles per dbspace.

Creating dbspaces on NAS (Network Attached Storage) devices is not recommended.
CR #700883 System Procedures > System Stored Procedures > sp_iqspaceused Procedure

The example procedure dbo.myspace should be:

 create or replace procedure dbo.myspace()   
begin   
     declare mt unsigned bigint;   
     declare mu unsigned bigint;   
     declare tt unsigned bigint;   
     declare tu unsigned bigint;   
     declare gt unsigned bigint;   
     declare gu unsigned bigint;   
     declare lt unsigned bigint;   
     declare lu unsigned bigint; 
     declare tt_t unsigned bigint;
     declare mt_t unsigned bigint;
     declare gt_t unsigned bigint;
     declare lt_t unsigned bigint;     
     call sp_iqspaceused(mt,mu,tt,tu,gt,gu,lt,lu);       
     if (tt = 0) then
        set tt_t = 0;
     else
        set tt_t = tu*100/tt;
     end if;
     if (mt = 0) then
        set mt_t = 0;
     else
        set mt_t = mu*100/mt;
     end if;
     if (gt = 0) then
        set gt_t = 0;
     else
        set gt_t = gu*100/gt;
     end if;
     if (lt = 0) then
        set lt_t = 0;
     else
        set lt_t = lu*100/lt;
     end if;
  select cast(mt/1024 as unsigned bigint) as mainMB,
         cast(mu/1024 as unsigned bigint) as mainusedMB, mt_t as mainPerCent,
         cast(tt/1024 as unsigned bigint) as tempMB,
         cast(tu/1024 as unsigned bigint) as tempusedMB, tt_t as tempPerCent,
         cast(gt/1024 as unsigned bigint) as shTempTotalKB,
         cast(gu/1024 as unsigned bigint) as shTempTotalKBUsed, gt_t as globalshtempPerCent,
         cast(lt/1024 as unsigned bigint) as shTempLocalMB,
         cast(lu/1024 as unsigned bigint) as shTempLocalKBUsed, lt_t as localshtempPerCent;
end
CR #710657 SQL Functions > Alphabetical List of Functions > ROUND Function [Numeric]

The ROUND function documentation is missing information on the ROUND_TO_EVEN database option:

When ROUND_TO_EVEN database option is set ON, the ROUND function rounds data from a Sybase IQ table half to the nearest even number to the integer-expression, matching the behavior of SQL Anywhere table data. When the option is set to OFF, the ROUND function rounds Sybase IQ data half away from zero.

In the following examples, the ROUND_TO_EVEN settings affect the value returned.

  • ROUND (convert (double, 123.45001), 1)

    Setting ROUND_TO_EVEN ON or OFF would return 123.5 because the value 0.05001 is more than half of 0.1.

  • ROUND (convert (double, 123.450000), 1)

    Setting ROUND_TO_EVEN ON returns 123.4 and setting ROUND_TO_EVEN OFF returns 123.5 because the value 0.0500 is half of 0.1.
CR #671727 File Locations and Installation Settings > Environment Variables

The IQ_USE_DIRECTIO Environment Variable is missing from the documentation:

The IQ_USE_DIRECTIO environment variable defaults to the setting 0. To enable direct I/O on a supported platform, set IQ_USE_DIRECTIO to 1. Multiplex databases do not support direct I/O.

IQ_USE_DIRECTIO = value

Optional on Sun Solaris UFS, Linux, Linux IBM, AIX, and Windows file systems only. In Linux, direct I/O is supported in kernel versions 2.6.x.

Not used on HP-UX and HP-UXi platforms.

IQ_USE_DIRECTIO has no effect on Sun Solaris and Windows.
CR #736337 System Tables and View > System Views> Alphabetical List of System Views > SYSTAB system view

The server_type row is missing this value:

  • 2 – IQ table

Reference: Statements and Options

Issue Section Description
CR #740981 ALTER Table Statement, CREATE Table Statement Added the following constraint to the MOVE TO description in the Usage section:
A BIT data type column cannot be explicitly placed in a dbspace. The following is not supported for BIT data types: 
ALTER TABLE t2 alter c1_bit MOVE TO iq_main;
Parent topic: Documentation Changes