DBMaker 5.4.5 T4 Version

• • support JDBC type 4
  • feature enhancement and bug fix
    • support aggregate function FIRST, LAST, STDDEV_POP, STDDEV_SAMP,
      VAR_POP, VAR_SAMP, BIT_AND, BIT_OR, BIT_XOR
    • support for using the “limit” clause in a SELECT statement with a subquery
      in the projection
    • support for using a subquery in a “CASE WHEN” statement
    • support subquery with order by syntax
    • support DBMaker DB replication with file object when RP_BKFOM=1
    • reserve for an additional “SYSADM” connection specifically for
      “dmsql” and “jtool” when the user license has been exceeded
    • fix the issue with the “not exists” subquery that may produce
      incorrect results when referencing an outer query
    • fix the typo in the “ORDINAL_POSITION” field in the “SHOWINDEX” procedure
    • fix the issue where using “insert or replace into” and creating a trigger
      may result in unpredictable outcomes
    • fix the issue where using “SQLSetPos” or “SQLGetData” returns error 5307
      after calling “SQLFetch”
    • fix select row_number on view which has order by alias will cause ERROR (6523)
    • fix the issue where using a “LEFT OUTER JOIN” with “ORDER BY” and “LIMIT”
      may produce incorrect results
  • support web application framework in github
    • fix the bug in the django-dbmaker Driver
    • support for laravel-dbmaker with PHP 8

• • support and fix DCI with ISCOBOL
    • support DCI_TABLESPACE_IDX to create index in another tablespace
    • support insert default when column default attribute is SYSTEM
    • support XFD COMMENT DCI_NULL_ON_SPACE_CHAR
    • fix unexpected FS=46 (no current record) when reading a multi-record
    • fix start/read/delete/rewrite should return error ERR_DISABLE_INDEX when index
      is disabled
  • dmSQL
    • support EXPORT INTO data-file FROM (select statement)
    • support EXPORT description_file option DISPLAY_NAME
  • JDBC and JTOOL GUI enhancement and fix

• • fix the issue where the JDBC “pstmt.clearparameters()” method throws an exception
  • fix the bug in JDBA related to handling “TIMESTAMP” data
  • fix the issue where repeatedly turning the lock graph on and off
    causes the JDBA Tool to shut down

DBMaker 5.4.4

• Support django-dbmaker driver
• feature enhancement and fix
  • support DB_LGSTARTDB to log start db progress in DMSTAT.LOG
  • support disable/rebuild index syntax for disable/enable index
  • support clob or nclob data with like operator
  • support schedule end time to unlimit
  • support LIMIT with subquery and update set col = (select … limit) syntax
  • support full outer join
  • support order/group by blob column by only compare the first 256 bytes blob data
  • support client config DB_SQLEN to set max sql statement length 2-16 as mega bytes
  • support rollover add param for do not copy file
  • add DB_INSPGCMP keyword’s default -1 to reduce deadlock caused by insert/update record with lock by compressing page with incontinuous space
  • change create table fillfactor’s default from 100 to 80
  • remove SQL Procedure create procedure from file’s file size limit
  • fix wrong lock escalation when deleting many records
  • fix alter table may get internal error when other connection are doing DDL
  • fix dmserver may get out of memory when many connection connect/disconnect to UTF8 DB
  • fix update table that has inline blob may return 20904 error
  • fix Schedule Task cause core dump with EXEC and license issue
  • fix create trigger when condition with and 1=1 get 6105 error
  • fix async table replication not allow different user/password
  • fix wrong data when alter table with bigserial column
  • fix cannot use window function with aggregate/group by or subquery clause
  • fix cannot know which column with ERR_INS_NULL_ON_NONULL_COL error
  • fix backup server does not backup journal when setting bkful <= 70
  • fix clob column define with default udf will get wrong default value
  • fix dmsql32 cannot type in win11
  • fix not exists subquery with outer reference may get wrong result
  • fix distributor daemon abonormal exit when cannot open ATRP.LOG
  • fix cannot update table with SQL Server Linked Server
  • fix crash when select projection has subquery and outer reference
  • fix dmservic.exe may crash with Application Error 1000 Event
  • fix error occurs with trigger executing insert in column with data type CLOB and Long Varchar
  • fix when multi-connection select/update blob, it’s possible to hang in select blob data
  • fix dmrestoretb tool not work when table name include schema -mantis1269
  • fix sqlsp compare smallint and integer have problem
• support and fix DCI with ISCOBOL
  • support DCI_TABLE_FILLFACTOR to set fillfactor for create table
  • support $XFD COMMENT DCI_NOT_NULL to define a column NOT NULL
  • support $XFD COMMENT DCI_NULL_ON_ZERO_NUMBER for a column
  • support BIGSERIAL with $XFD COMMENT DCI SERIAL 1 and PIC 9(19)
  • support CALL DCI_SETENV with DCI_COMMIT_COUNT
  • fix ISDCI dcic cannot get correct runtime connection ID
  • fix cannot connect if getenv with DCI_CONNECTION_ID before open table
  • fix execute program with visual cobol2019 failed by xfd wrong version number
  • fix get wrong result when open same table with different XFD and table schema
• JDBC and JTOOL GUI enhancement and fix
  • JDBC support prepareStatement(String sql, int autoGeneratedKeys)
  • fix JDBC with DB_LCDEC=1 wrong behavior
  • fix JDBC issues with kafka project
  • fix JDBC errors occurs using multiple threads in JAVA Program
  • JTOOL look and feel
  • fix various minor bugs