- acquire software
   - install software
   - connect to software
   - test and identify new features
   *- file issues to implement new features
already downloaded and not installed yet
database running:
	sa | [password]
	10.168.11.57:5000
here is a quick list of changes.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 DATATYPES
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     bigtime            A bigtime value includes the hour, minute, second, and fraction of a second. The fraction is stored to 6 decimal places.
    bigdatetime        A bigdatetime value includes the year, month, day, hour, minute, second, and fraction of a second to 6 decimal places.
 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 FUNCTIONS
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 New
    db_attr         Returns the durability, dml_logging, and template settings for the specified database.
    object_attr         Reports the table’s current logging mode, depending on the session-specific, table-wide, and database-wide settings.
     cache_usage         Returns cache usage for the cache to which the specified object is bound, as the percentage of the cache which is currently in use by all objects bound to that cache.
    current_bigdatetime     Returns a bigdatetime value representing the current date and time with microsecond precision.
     current_bigtime     Returns a bigtime value representing the current time with microsecond precision.
Changed
    datepart         Produces the specified datepart argument of the specified date as an integer.
     datename         Produces the specified datepart as a character string.
    datediff         Calculates the number of date parts between two specified dates or times.
    dateadd         Adds an interval to a specified date or time.
 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 SYSTEM STORED PROCEDURES
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 New
    sp_deletesmobj         Deletes backup objects from the TSM.
    sp_querysmobj         Retrieves a list of backup objects from the TSM.
Changed
    sp_addsegment         Updated to manage space in in-memory databases.
     sp_addthreshold     Updated to manage space in in-memory databases.
    sp_bindcache         You cannot bind objects or databases to in-memory storage caches, and you cannot bind an in-memory database or objects in an in-memory database to any cache.
     sp_cacheconfig         Creates, extends the size of, or drops, an in-memory storage cache.
    sp_cachestrategy     The prefetch and MRU parameters do not apply to tables and indexes in in-memory databases.
    sp_dbextend         Automatic database expansion is currently not supported for in-memory databases.
     sp_deviceattr         The directio and dsync device attributes do not apply to in-memory devices.
    sp_downgrade         Supports downgrading an Adaptive Server containing in-memory or relaxed-durability databases, or databases using templates or minimal logging.
     sp_diskdefault         You cannot use sp_diskdefault to specify in-memory devices as a default devices.
    sp_dropdevice         Drops an in-memory device created from an in-memory storage cache.
    sp_dropsegment         Updated to manage space in in-memory databases.
     sp_dropthreshold     Updated to manage space in in-memory databases.
    sp_extendsegment     Updated to manage space in in-memory databases.
    sp_help         Reports on properties, such as minimal logging attribute, for a table.
     sp_helpcache         Displays properties of the in-memory storage cache, the in-memory database created on it, and details of free space on this cache.
    sp_helpdb         Reports on database properties, such as durability, DML logging level, in-memory or not, use, if any, of a template database, or as a template database.
     sp_helpdevice         Reports the in-memory device properties created from an in-memory storage cache.
    sp_modifythreshold     Updated to manage space in in-memory databases.
    sp_plan_dbccdb         Sets up dbccdb for checkstorage execution in an in-memory database.
     sp_poolconfig         Large I/O buffer pools are not supported in an in-memory database.
    sp_post_xpload         Supports cross-platform operations for in-memory databases.
    sp_tempdb         Supports user-created temporary database groups, login or application bindings to temporary database groups and for in-memory databases.
     sp_unbindcache
    sp_unbindcache_all     You cannot unbind objects in or the in-memory database itself from the host in-memory storage cache.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 COMMANDS
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 New
    transfer table     
        Initiates an incremental table transfer.
        A new grant with grant option supports transfer table. It grants a specified user permission to transfer a specified table.
         grant transfer table on table_name to user with grant option
Changed
    alter database     
        Syntax added to support changing the durability of a database, the level of DML logging, a database’s template.
     alter table     
        Syntax added to support changing a table’s logging mode for insert, update, and delete (DML) operations.
        Syntax added to support transfer table:
        set transfer table [on | off]
 
    create database     
        Syntax added to create in-memory and relaxed-durability databases with durability set to full, no_recovery, or at_shutdown.
        Syntax added to specify DML logging level and template database, if any.
     create table     
        Syntax added to specify DML logging level for tables in in-memory databases.
        Syntax added to support transfer table:
        with transfer table [on | off]
    disk init
         Syntax added to create in-memory data devices for in-memory databases.
    dump database     
        Syntax added to support the Tivoli Storage Manager (TSM). The keyword syb_tsm invokes the Sybase interface with the TSM API (libsyb_tsm).
         database_name to "syb_tsm::object_name"
    dump database ... compression=
        Syntax added to support faster, less CPU-intensive compression levels 100 and 101.
    dump transaction     
         Syntax added to support TSM. The keyword syb_tsm invokes the Sybase interface with the TSM API (libsyb_tsm).
        database_name to "syb_tsm::object_name"
    dump transaction ... compression=
         Syntax added to support faster, less CPU-intensive compression levels 100 and 101.
    load database     
        Syntax added to support TSM. The keyword syb_tsm invokes the Sybase interface with the TSM API (libsyb_tsm).
         database_name from "syb_tsm::
        [[-S source_server_name]
        [-D source_database_name]::]object_name" 
    load transaction     
        Syntax added to support TSM. The keyword syb_tsm invokes the Sybase interface with the TSM API (libsyb_tsm).
         database_name from "syb_tsm::
        [[-S source_server_name]
        [-D source_database_name]::]object_name" 
    select into
        Syntax added to specify the DML logging level for tables created by selecting into in-memory or relaxed-durability databases.
     set     
        Adds:
        * dml_logging parameter for specifying the amount of logging for a session.
        * deferred_name_resolution for activating deferred name resolution at the connection level.
         * builtin_date_strings number
            Values are:
            o 0 - if a string is given as an argument to a chronological system function, the server interprets it as a datetime value regardless of its apparent precision. This is the default.
             o 1 - makes the server interpret the argument string as bigdatetime. This affects the result of chronological system functions.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 CONFIGURATION PARAMETERS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 create procedure: deferred name resolution
    Allows you to create procedures using deferred name resolution. Values are:
        * 0 – disables deferred name resolution. This is the default.
        * 1 – enables deferred name resolution.
 builtin date strings
    Values are:
        * 0 – causes string literals given to a chronological builtin function as an argument to be interpreted as a datetime type.
        * 1 – causes string literals given to a chronological builtin function as an argumen
 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 SYSTEM TABLES
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 New
    spt_TableTransfer
        Stores the results from table transfers.
Changed
    sysdevices
        Lists the in-memory storage cache under the name and phyname columns. In-memory devices do not include a full path to the disk device, instead, they store the name of the cache on which the in-memory device has been created.
     sysdatabases
        Adds the durability column, which indicates the durability level of the database. The durability column has the int datatype. Its values are:
        * 1- full
        * 5- at_shutdown
         * 6- no_recovery
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
here is a quick list of changes.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 DATATYPES
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     bigtime            A bigtime value includes the hour, minute, second, and fraction of a second. The fraction is stored to 6 decimal places.
    bigdatetime        A bigdatetime value includes the year, month, day, hour, minute, second, and fraction of a second to 6 decimal places.
 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 FUNCTIONS
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 New
    db_attr         Returns the durability, dml_logging, and template settings for the specified database.
    object_attr         Reports the table’s current logging mode, depending on the session-specific, table-wide, and database-wide settings.
     cache_usage         Returns cache usage for the cache to which the specified object is bound, as the percentage of the cache which is currently in use by all objects bound to that cache.
    current_bigdatetime     Returns a bigdatetime value representing the current date and time with microsecond precision.
     current_bigtime     Returns a bigtime value representing the current time with microsecond precision.
Changed
    datepart         Produces the specified datepart argument of the specified date as an integer.
     datename         Produces the specified datepart as a character string.
    datediff         Calculates the number of date parts between two specified dates or times.
    dateadd         Adds an interval to a specified date or time.
 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 SYSTEM STORED PROCEDURES
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 New
    sp_deletesmobj         Deletes backup objects from the TSM.
    sp_querysmobj         Retrieves a list of backup objects from the TSM.
Changed
    sp_addsegment         Updated to manage space in in-memory databases.
     sp_addthreshold     Updated to manage space in in-memory databases.
    sp_bindcache         You cannot bind objects or databases to in-memory storage caches, and you cannot bind an in-memory database or objects in an in-memory database to any cache.
     sp_cacheconfig         Creates, extends the size of, or drops, an in-memory storage cache.
    sp_cachestrategy     The prefetch and MRU parameters do not apply to tables and indexes in in-memory databases.
    sp_dbextend         Automatic database expansion is currently not supported for in-memory databases.
     sp_deviceattr         The directio and dsync device attributes do not apply to in-memory devices.
    sp_downgrade         Supports downgrading an Adaptive Server containing in-memory or relaxed-durability databases, or databases using templates or minimal logging.
     sp_diskdefault         You cannot use sp_diskdefault to specify in-memory devices as a default devices.
    sp_dropdevice         Drops an in-memory device created from an in-memory storage cache.
    sp_dropsegment         Updated to manage space in in-memory databases.
     sp_dropthreshold     Updated to manage space in in-memory databases.
    sp_extendsegment     Updated to manage space in in-memory databases.
    sp_help         Reports on properties, such as minimal logging attribute, for a table.
     sp_helpcache         Displays properties of the in-memory storage cache, the in-memory database created on it, and details of free space on this cache.
    sp_helpdb         Reports on database properties, such as durability, DML logging level, in-memory or not, use, if any, of a template database, or as a template database.
     sp_helpdevice         Reports the in-memory device properties created from an in-memory storage cache.
    sp_modifythreshold     Updated to manage space in in-memory databases.
    sp_plan_dbccdb         Sets up dbccdb for checkstorage execution in an in-memory database.
     sp_poolconfig         Large I/O buffer pools are not supported in an in-memory database.
    sp_post_xpload         Supports cross-platform operations for in-memory databases.
    sp_tempdb         Supports user-created temporary database groups, login or application bindings to temporary database groups and for in-memory databases.
     sp_unbindcache
    sp_unbindcache_all     You cannot unbind objects in or the in-memory database itself from the host in-memory storage cache.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 COMMANDS
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 New
    transfer table     
        Initiates an incremental table transfer.
        A new grant with grant option supports transfer table. It grants a specified user permission to transfer a specified table.
         grant transfer table on table_name to user with grant option
Changed
    alter database     
        Syntax added to support changing the durability of a database, the level of DML logging, a database’s template.
     alter table     
        Syntax added to support changing a table’s logging mode for insert, update, and delete (DML) operations.
        Syntax added to support transfer table:
        set transfer table [on | off]
 
    create database     
        Syntax added to create in-memory and relaxed-durability databases with durability set to full, no_recovery, or at_shutdown.
        Syntax added to specify DML logging level and template database, if any.
     create table     
        Syntax added to specify DML logging level for tables in in-memory databases.
        Syntax added to support transfer table:
        with transfer table [on | off]
    disk init
         Syntax added to create in-memory data devices for in-memory databases.
    dump database     
        Syntax added to support the Tivoli Storage Manager (TSM). The keyword syb_tsm invokes the Sybase interface with the TSM API (libsyb_tsm).
         database_name to "syb_tsm::object_name"
    dump database ... compression=
        Syntax added to support faster, less CPU-intensive compression levels 100 and 101.
    dump transaction     
         Syntax added to support TSM. The keyword syb_tsm invokes the Sybase interface with the TSM API (libsyb_tsm).
        database_name to "syb_tsm::object_name"
    dump transaction ... compression=
         Syntax added to support faster, less CPU-intensive compression levels 100 and 101.
    load database     
        Syntax added to support TSM. The keyword syb_tsm invokes the Sybase interface with the TSM API (libsyb_tsm).
         database_name from "syb_tsm::
        [[-S source_server_name]
        [-D source_database_name]::]object_name" 
    load transaction     
        Syntax added to support TSM. The keyword syb_tsm invokes the Sybase interface with the TSM API (libsyb_tsm).
         database_name from "syb_tsm::
        [[-S source_server_name]
        [-D source_database_name]::]object_name" 
    select into
        Syntax added to specify the DML logging level for tables created by selecting into in-memory or relaxed-durability databases.
     set     
        Adds:
        * dml_logging parameter for specifying the amount of logging for a session.
        * deferred_name_resolution for activating deferred name resolution at the connection level.
         * builtin_date_strings number
            Values are:
            o 0 - if a string is given as an argument to a chronological system function, the server interprets it as a datetime value regardless of its apparent precision. This is the default.
             o 1 - makes the server interpret the argument string as bigdatetime. This affects the result of chronological system functions.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 CONFIGURATION PARAMETERS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 create procedure: deferred name resolution
    Allows you to create procedures using deferred name resolution. Values are:
        * 0 – disables deferred name resolution. This is the default.
        * 1 – enables deferred name resolution.
 builtin date strings
    Values are:
        * 0 – causes string literals given to a chronological builtin function as an argument to be interpreted as a datetime type.
        * 1 – causes string literals given to a chronological builtin function as an argumen
 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 SYSTEM TABLES
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 New
    spt_TableTransfer
        Stores the results from table transfers.
Changed
    sysdevices
        Lists the in-memory storage cache under the name and phyname columns. In-memory devices do not include a full path to the disk device, instead, they store the name of the cache on which the in-memory device has been created.
     sysdatabases
        Adds the durability column, which indicates the durability level of the database. The durability column has the int datatype. Its values are:
        * 1- full
        * 5- at_shutdown
         * 6- no_recovery
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
did an intial pass through and made some changes. there are some issues with the 2 new datatypes and there is a bug filed for it to niels.
did an intial pass through and made some changes. there are some issues with the 2 new datatypes and there is a bug filed for it to niels.
| Issue #4771 | 
| Closed | 
| Fixed | 
| Resolved | 
| Completion | 
| No due date | 
| No fixed build | 
| No time estimate | 
already downloaded and not installed yet