DBMaker 5.4.7 Version

• Feature Enhancement and Bug Fixes
  • Support SQL function
  • Support SQL stored procedure with INOUT argument
  • Support SQL stored procedure with transaction
  • Support TRUNCATE TABLE SQL command
  • Support Alter table Modify table constraint and drop constraint
  • Support GREATEST and LEAST functions
  • Support DBFILE_SIZE and FORMAT_BYTES functions
  • Support TO_DATE,DATETOSTR,TIMETOSTR,TIMESTAMPTOSTR functions from addon to default
  • Support FKCHK=2 to support self-reference FK/PK checking.
  • Enhance performance for select count(*) for left outer join with only left table’s filter
  • Enhance performance for IN SUBQUERY without outer reference
  • Fix cannot rename offline DB to same name with a online DB
  • Fix the issue of not being able to delete system temporary files (DBNAMEno.TMP), adjust the behavior for the system temporary file generation rule from global to per connection:
    • Remove DB_TPFIL keyword: user cannot define temp file name
    • Change DB_ITTDIR default from DB_DBDIR to DB_TMPDIR
    • Change system temporary filename format from DBDIR/DBNAMEno.TMP to ITTDIR/DBNAME_connectionid_no.TMP
    • The max number of ITT file for a connection is 128
    • The max file size of ITT file is 4G
    • Manually delete the system termporary files for connection that no longer exists
      using the following command:
      CALL SETSYSTEMOPTION(‘CRITT’, ‘0’)
• Support and fix DCI with ISCOBOL
  • support for DCI_GETENV with DCI_EXEC_SQL sql_command
  • Fix hundred of second of timestamp not intercepted by COBOL program
  • Fix file status from FD with Decimal column
• JDBC and JTOOL GUI enhancement and fix
  • Support jdbc driver with more Connection.prepareStatement signatures
  • Support jdbc driver 4 connection string for DB_TMOFM
  • Fix jdbc driver dbmaker.sql.JdbcOdbcXAResource for GlassFish with DBMaker
  • Fix jdbc type 4 with NullPointer while reading Time column with ResultSet.getObject
  • Fix jdbc type 4 with setLong + registerOutParameter NUMERIC
  • Add a button named “Register/row” to display the selected record
  • Add Auto Complete Improvement
  • Add Truncate table
  • Add Schedule-Task
  • Add TDE Table with column encrypt/decrypt attribute

Starting from DBMaker version 5.4.7 release, support for Windows 32-bit and Linux 32-bit platforms will no longer be provided. This policy will continue for all subsequent releases. If you require continued support for these platforms, please contact the DBMaker Support Team for further assistance.

DBMaker 5.4.6 Version

• feature enhancement and bug fix
  • support Transparent Data Encryption(TDE)
  • support EXCEPT in SELECT syntax
  • support ORDER BY and LIMIT within UNION
  • support where null=null is true after execute CALL SETSYSTEMOPTION(‘ANSI_NULLS’,’0′)
  • support where (col1,col2) in ((val1,val2),(?,?)…) syntax
  • support DB_SCHLGDAY to remove schedule servers’s log, the default is 30 days
  • support syntax to execute the schedule’s task:
    call setsystemoption(‘SCHEDULE_SYNC’,’schedule_name’);
  • support CSVEXPORT() stored procedure to export query’s result to csv file
  • support EXTENDTS() stored procedure to extend tablespace
  • support create/alter tablespace with logical_file=’physical_file’ syntax for setting at server’s site’s dmconfig.ini
  • support update statistics with mode option syntax
  • add more status info
    • add PRODUCT_INFO and BUILD_VERSION at SYSINFO
    • add TDE_DB, TDE_STATUS and TDE_OPEN_AUTO at SYSINFO
    • display IO_SERVER status at SYSUSER
    • add info for suggest rebuild index in DMEVENT.LOG after update statistics
    • add shrink tablespace compressonly’s progress and journal status in DMSHRINK.LOG
    • add check db progress info in DMCHECK.LOG
  • support ALTER VIEW ALL COMPILE and disable auto rebuild view’s behavior
  • change DB_INSPGCMP default from -1 to 1
  • fix when call SETSYSTEMOPTIONW(‘key’,’string’), the string should be saved as ANSI in dmconfig.ini when DB_LCODE=10
  • fix crash with left join and projection has subquery
  • fix multi-connection rebuild SQL stored procedure may cause invalid procedure
  • fix dmserver start two distinct dbname may get warm start error
• support web application framework in github
  • support django-dbmaker driver 2.x to 4.x
  • fix bugs in django-dbmaker Driver
• support and fix DCI with ISCOBOL
  • support $XFD COMMENT DCI BIGINT
  • support $XFD COMMENT DCI DCI_ENCRYPT
  • support insert/rewrite with system default attribute column
  • support DCI_COLUMNS_MAPPING for OPEN I-O or OPEN OUTPUT
  • fix using DCI_BLOB_GET crash at win64
  • fix dci_set_where_constraint did not remove previous filter for READ operation
• dmSQL
  • fix unload table will have problem when table constraint > 1024 bytes
• JDBC and JTOOL GUI enhancement and fix
  • support prepareStatement(String sql,int autoGeneratedKeys)
  • support JDBC TYPE 4 for PreparedStatement batch when there’s no clob/blob parameter
  • fix JDBC TYPE 4 may crash when execute sql command’s length > 64k
  • fix JDBC driver exception using commons-configuration2-2.7
  • fix display chinese characters are garbled in jdbatool when DB_LCODE=10
  • fix import clob data through ODBC in JDataTransfer Tool may get extra ’00’ characters
  • fix JDBATOOL cannot display SQLDEF from SYSTEM.SYSPROCINFO