SAP SYBASE SQL ANYWHERE
SAP SQL Anywhere 17
Matrix of available components (DB, Interfaces, UltraLite, MobiLink, SQL Remote, Tools of Directors) for each platform: Windows, Linux, Apple OS X, IBM AIX, HP-UX, Google Android and Consolidated Database: Oracle, Microsoft, SAP HANA , ASE, IQ, IBM DB2, MySQL … click here
SQL Anywhere Cockpit: una interfaz basada en web para ver la disponibilidad, la capacidad y el rendimiento de su servidor. SQL Anywhere Profiler: herramienta de desarrollo que reúne todos los diversos datos de rendimiento y ajuste que el servidor tiene disponibles para facilitar el ajuste y la solución de problemas de su aplicación y base de datos.
Increased password protection: The default DBA user name and password (DBA/sql) will no longer be used by dbinit and CREATE DATABASE statement, and the default minimum password length has been changed to 6 from 3. The DBA username and password must be provided when creating new database. In addition, a new option has been added to allow the user to specify the minimum password length. Database isolation: Support has been added for enabling database isolation for a database server. When database isolation is turned on, each database behaves as though it is the only database running on the database server.
Alter/drop procs: Previously, attempting to alter, replace, or drop a procedure that was being executed would result in an error. Now, the alter, replace, or drop succeeds. Current executions use the procedure definition from when the procedure started executing. New calls to the procedure after an alter, replace, or drop, use the new definition. Online rebuild: Online rebuild – You can now rebuild a production database while the database is running, which reduces downtime. Point-in-time recovery: You can now restore a database to a specified time stamp or to an offset in the transaction log. Dynamically start/stop TCP-IP/HTTP: Support added for starting and stopping connection listeners while the database server is running (database upgrade or rebuild required) – ie. you can now start and stop HTTP, HTTPS, TCP/IP, and shared memory connection listeners without having to restart the database server.
PIVOT/UNPIVOT: You can now pivot and unpivot table data using two clauses, PIVOT and UNPIVOT, in the FROM clause of a query to create pivoted- or unpivoted-derived tables. Pivoting rotates column data into rows and aggregates data in a meaningful way for your business needs. Unpivot is a similar operation, but rotates row data into columns. Unpivoting is useful for normalizing un-normalized data, such as several columns of similar data that must be joined with other data. DECLARE VARIABLE LIKE: You can use the %TYPE and %ROWTYPE attributes to define the data type(s) based on the data type of other objects. When creating schema objects such as columns, use the %TYPE attribute to set the data type of the object you are creating or altering, to the data type of a column in a table or view. Use the %ROWTYPE attribute to set the data types to the composite data type for a row in a table or view. When creating variables, you can also use the %TYPE and %ROWTYPE attributes to set the data type to the data type of temporary objects such as variables and cursors. FETCH INTO: The SELECT statement now includes the INTO VARIABLE clause to support specifying row variables and the INTO TABLE clause to support explicitly creating a new table. The FETCH statement now allows you to specify a row variable in the INTO clause.