|
Transoft
U/SQL Adapters 4.10
Version 4.10 of Transoft U/SQL Adapters is a major release, which includes
the following new features and bug fixes:
New Features
USQL is now compatible with ACU Vision 5 files. Implement ACUMaxFiles directive Note 1: Due to the licensing requirements of the ACUCOBOL file handler, the single tier version of U/SQL for ACUCobol on Windows must be installed on a machine that has a C:\temp directory. Note 2: Due to a change in the ACU API, U/SQL 4.10 for ACUCOBOL on Windows must be used with ACUCOBOL 6.2, it is not compatible with earlier versions of ACUCOBOL.
USQL is now compiled with MF Server Express by default. Libraries are enclosed for a relink with Object COBOL if required. USQL for MF Server Express 64 bit is now available on AIX 5.2.
Allow setting space fill key per index - put S in Index type. Allow BBREUSE INI directive.
Allocate enough space for huge UFDs.
Allow 30 character fields including in keys.
Allow 30 character fields including in keys.
Implement EJE link to MS Access.
Increase maximum number of databases.
Up to 64 data items may be used within queries and still have the syllogistic comparison checks applied (i.e. if A=B and B=C then the fact that A=C is known to the query optimiser)If more than 64 data items are used, they simply won't be added to the syllogistic comparison checks. Not-grouped columns may not be used in HAVING clauses - USQL used to produce no data. UNIX installation: use gunzip on Linux as uncompress might not be installed 64 bit versions of USQL for the MF and ACU DSDs can be provided if required. Please speak to your Account Manager about this. Allow record bigger than 32767. Implement TRANSACTION [MODE] ON, TRANSACTION [MODE] OFF and ROLLBACK as SQL commands through SQLPrepare and SQLExecute Log DLL load errors to log file. Implement JDBCNoUDDChange directive. InsertUseVirtualColumn directive to enable update record lengths for variable length records. Add IgnoreMaximumGroupBy directive to allow engine to ignore maximum group-by UniCodeConvert directive - if parameter length is doubled and if every alternate character is a null, remove nulls. mplement RefuseLast directive to force SQLExtendedFetch(stmt,SQL_FETCH_LAST) to return a S1000 error. This is required by the VSAM EXTFH driver which doesn't support SEARCH_LESS_EQUAL.
Allow usage of CRAM and implement then BBCRAM directive to set non-default cram characters Implement Implement DATE(CDAY2)
-
SQLODBC
- Implement Database Type function
- Allow for multiple concurrent connections.
- Put SQL errors on a stack.
- Set different SQLSetStmtOptions for diff database types.
- Implement VAR-STRING data type.
Bugs Fixed in v.4.10.0000
Ensure record number isn't set to 0 on INSERT. Correct INSERT table with recno defined. Correct threading issue when VL files are accessed by several processes simultaneously. Allocate index using MaxKeyLen to avoid overwriting the saved key buffers (UK26313) If key field is BB_ALPHA and KeyFillChar is set then space fill
Use char(254) by default for ? in the select list. Required by queries such as: insert into customer2 select ?, cust_name, cust_region from customer where custcode = ? Implement Make NumericDefaultDouble for any numeric value of >9 digits or with decimal places if the directive is set. Fix errno warning on Linux. Ensure that a JDBC connection is recognised correctly. Fix G&R expression syntax so it has the right column list, and amends the query to use double-quotes if the user has used single-quotes in their syntax. select custcode from customer group by custcode having custcode like "C00%" failed because CUSTCODE is a result column and in the where clause. Rounding errors on AIX - print double values into a string DummyQualifier directive to return "none" as a database qualifier, and then allow the client to change current qualifier to that. UniCode checking, only deal with strings where at least two character-null pairs exist. Re-execute when doing Execute after ExtendedFetch has been run. Unless this is done a select count(*) from customer ends up giving 17 the first time it is executed, then 17,34 the second time, etc. Use a backslash as a default escape character in LIKE.
Remove replacement_exit for UFOS - it exits the server if an error occurs.
Correct Logoff so that Connection is freed when it has been lost in middle of UBL program.
Corrections to VAR-STRING parameter for Oracle ODBC driver.
Contact your Transoft Account Manager for more information
on Transoft U/SQL Adapters and Transoft U/SQL Enterprise Join
Engine or Transoft Customer Services, if you are fully paid-up
on support, to obtain upgrades for Transoft U/SQL Adapters
4.10.
Copyright:
Computer Software Group Limited 2007
|
