RDB Connect - Version 5.01

Date: 07/25/2024

Type: Fix
Description: Modified RDBExport to handle custom jars with prefix MSSQL-MYSQL

Date: 09/12/2023

Type: New
Description: Modified RDBExport to handle binary field export to MSSQL Integer and Big Integer values

Date: 08/18/2023

Type: Fix
Description: Modified all GetString* API's to handle NVARCHAR double Byte characters in V7R5 the same way it handles it in V7R2-V7R4

Date: 08/11/2023

Type: New
Description: Added new API RDBGETNVARCHAR to retreive NVARCHAR String from Oracle and MSSQL Servers ONLY

Type: New
Description: Added new API RDBASCNVARCHAR to retreive NVARCHAR String from Oracle and MSSQL Servers ONLY

Type: New
Description: New API RDBSetFloat4 to set FLOAT values for single byte

Type: New
Description: New API RDBSetFloat8 to set FLOAT values for double byte float

Date: 06/29/2023

Type: New
Description: Command 'RDBCRTSQLF' to generate .SQL File script from IBM i and save directly to IFS /prodata directory. This can be generated with or without a Create Table SQL Statement alog with Insert statements for each row.

Date: 04/17/2023

Type: New
Description: New DropBox tool allows you to share files directly from IBM i. You can use command RDBDROPBOX in CLLE or directly from RDB Menu. a quick setup is required to provide the application key and application secret. You can find documentation in the RDB Connect page documents section.

Date: 12/07/2022

Type: Fix
Description: Fixed RDBIMPORT to handle NULL values from remote columns to IBM i correctly with a blank value

Date: 10/26/2022

Type: New
Description: New Command RDBCRTABLE - Create IBM i Table without data on a remote Database.

Type: New
Description: New API RDBRunSQLFile - Execute any .sql file (IFS)

Type: New
Description: New API RdbRunCSVFile - Use a .csv formatted file (IFS) to export records to a remote Database. Use command RDBCRTABLE prior to using this API (Table must exist on your remote DB with the same column definitions).

Date: 06/08/2022

Type: New
Description: New command RDBPFXLSX added to convert PF to XLSX spreadsheets. Java 1.8 is required on IBM i to run this command. API RdbPC2Txt and RdbFtp2Txt can also be used to transfer XLSX Files.

Date: 05/10/2022

Type: Fix
Description: Modified RDBSetDate to work with Java8.

Date: 03/22/2022

Type: New
Description: Added new connection types for Apache IGNITE and ORIENT (NON SQL Database). Some API's are disabled due to the JDBC Driver capabilities.

Date: 03/14/2022

Type: Fix
Description: Fixed duplicate signature on main Service Program. This update will require you to recompile any program that was compiled after 120921 with any RDBConnect API's

Date: 01/10/2022

Type: New
Description: Added new commands to export FILES to IFS in CSV/XLS format.

Type: New
Description: New command added to export File/Mbr to a remote DB similar to RDBIMPORT.

Type: New
Description: New job (RDBPCSERV) added to RDBSBS, this job will handle File transfers to a PC/Server directly from IBM i.

Type: New
Description: RDBEXPLIB - Exports all PF and Members from the specified library to a remote DB.

Type: New
Description: RDBEXPFIL - Export a specific PF/Members to a remote DB

Type: New
Description: RDBLIBCSV - Convert all Files to CSV/XLS by the specified library

Date: 10/14/2021

Type: New
Description: Now you can use RDBRUNSQL to execute statements on a remote database

Date: 08/30/2021

Type: New
Description: New API's to be able to connect to a FTP Server, GET and PUT Files/Folders. See documentation details.

RDB Connect - Version 5.0

Date: 06/22/2021

Type: New
Description: New API added RDBSETCLOB - Set a CLOB field on a remote DB. This API will allow up to 15728640 characters.

Date: 03/15/2021

Type: Fix
Description: Improved selection criteria with Tables.

Date: 01/18/2021

Type: Fix
Description: Fixed Catalog & Schema fields to allow up to 50 characters when adding/updating a connection

Date: 01/13/2021

Type: New
Description: Added new option to IMPORT VARCHAR(MAX) and ORACLE CLOBS in RDBIMPORT. This is limitted to 25000 Characters to allow extra space for other columns due to IBMi's limitations of 37266 per record.

Date: 10/28/2020

Type: New
Description: Increased IP/Host Address field from 50 to 200 characters when adding/updating a connection.

Date: 09/23/2020

Type: New
Description: New command RDBDRIVERS added to quickly update RDB JDBC drivers if needed. You must restart RDBConnect for the change/s to take effect.

Date: 07/21/2020

Type: New
Description: Added new feature to test your remote DB Connection port when creating a connection. Use command RDBCFG F6=Add a connection.

Date: 06/29/2020

Type: New
Description: New function 23 from RDBCFG to view SubSystem RDBSBS jobs running. Works on V7R1 and above.

Date: 10/30/2019

Type: Fix
Description: Fixed RDBGetBLOB API when using latest java 1.8 ver 221

Date: 09/26/2019

Type: New
Description: New API RDBexeccl - this is a wrapper program to call RDBexec from a CL program.

Date: 04/03/2019

Type: Fix
Description: Modified RDB 5 to display warning for stored procedure details when DB Type is MSSQL or MSSQL2

Date: 02/21/2019

Type: New
Description: New feature will allow you to run RDBconnect under a different java version from the system's default version. Update dtaara rdbjvmpath with the path to the JDK.

Date: 01/04/2019

Type: Fix
Description: Modified RDBConnect job to use RDBQPRINT file for errors that were sent to IBM's default print file QPRINT. RDBConnect will clear the PF member every time it starts.

Date: 12/07/2018

Type: New
Description: New API RDBAddBatch added to improve performance when inserting/updating multiple rows. RDBPREPSTMT must be used prior to this API.

Type: New
Description: New API RDBEXECBatch added to improve performance when inserting/updating multiple rows. RDBPREPSTMT and RDBADDBATCH must be used prior to this API.

Date: 10/02/2018

Type: New
Description: Modified RDB Tracelog to allow all info logs or errors only.

Date: 09/11/2018

Type: New
Description: Added two new JDBC drivers for MSSQL (JTDS_1.3.8) and MSSQL2 (SQLJDBC4_JAVA7) If still using Java 1.6 or older The old drivers are still available in /prodata/rdb5/ (jtds_1.2.8 & sqljdbc4)

Date: 08/30/2018

Type: Fix
Description: Fixed max records reached (qprint in qtemp).

Date: 08/22/2018

Type: New
Description: RDBGetStrCs - Get character string by specific IBM i code page. Use with code page characters that are stored with double byteS. Example pages Cp935 Chinese, CP420 Arabic, CP933 korean, etc. You must create IBM file Column with DATA TYPE g and change your Client Access host code page settings

Date: 07/17/2018

Type: Fix
Description: Fixed problem in RDBCFG when tracelog file was too big.

Date: 03/06/2018

Type: Fix
Description: fixed RDBsetISOTIME() to work with java 8

Date: 01/09/2018

Type: Fix
Description: Fixed problem when inserting a *loval value from IBMi to MSSQL using a DS. The value inserted will be 1900-01-01 00:00:00.000 when the value in IBMi is *LOVAL.

Date: 08/25/2017

Type: Fix
Description: Modified RDBGETBLOB API output parameter from 9999999 characters to 15728640, this will allow another 5 mB if needed.

RDB Connect - Version 4.04

Date: 03/06/2018

Type: Fix
Description: fixed RDBsetISOTIME() to work with java 8

Date: 04/24/2017

Type: New
Description: Added new DTAARA (RDBSNGLQT) to specify the server type that require single quotes in SQL statement when using RDBEXPORT

Type: Fix
Description: Modified RDBExport to allow to use a different table name on remote server.

RDB Connect - Version 4.03

Date: 01/11/2017

Type: Fix
Description: Updated PTF process to include IFS objects.

Type: Fix
Description: Updated the log process to include more information for each field set in a prepared statement.

Type: Fix
Description: Updated the log process to include more information for each field set in a prepared statement.

Date: 09/16/2016

Type: New
Description: Added new API RDBSETINT to set a integer value field on a remote database

Type: New
Description: Added new API RDBSETNEGINT to set a negative integer value field on a remote database

Date: 08/25/2016

Type: New
Description: Added New API "RDBGetISOTime" to retrieve TIME from a remote database and return TIME in ISO format.

Type: New
Description: Added New API "RDBAscIsoTime" to retrieve TIME from a remote database and return TIME in ISO format.

Type: New
Description: Added New API "RDBAscIsoDate" to retrieve DATE from a remote database and return DATE in ISO format.

Type: Fix
Description: Modified RDBGetNum to return zeros when a null value is found on a remote database column

RDB Connect - Version 4.02

Date: 08/17/2016

Type: Fix
Description: Modified RDBSetDate to use POSTGRE timestamp format when setting a timestamp in a prep-statement.

Date: 01/27/2016

Type: Fix
Description: Fixed problem in RDBImport when using a CAST expressions in SQL SELECT statement.

Date: 08/18/2015

Type: Fix
Description: Modified RDBConnect (ODBC) connection to prevent error when inserting row using RDBEXEC.

Date: 08/03/2015

Type: New
Description: Added new function F22 to RDBCFG to display the active java version running on the system.

Date: 07/30/2015

Type: Fix
Description: Modified installer to include the latest RdbConnect version when installing GUI Client.

Date: 07/16/2015

Type: New
Description: Api RdbSndErrAlert - Sends a notification message to a specific user defined in (RDBUSERMSG) DTAARA when an error occurs. This will only work when using any of the API getters. eg: RdbGetNum.

Date: 04/30/2015

Type: New
Description: NEW API RdbGetIsoDate. This API will return an ISO date from a remote database DateTime column.

Date: 04/08/2015

Type: Fix
Description: Fixed RdbConnect to allow true lengths of Integer columns instead of a fixed length of 10,0.

Date: 04/06/2015

Type: Fix
Description: RDBSEC was giving message of license permanently installed but was not creating an entry in license information.

Date: 03/17/2015

Type: Fix
Description: Increased the remote DB field name length to display correctly when using RDBFIELDS Function Key F10 Fold/Drop.

Date: 02/16/2015

Type: New
Description: RDBGetCharStr(Get character stream after a prepared statement. This allows up to 32767 characters to be retrieved from remote database.)

Type: New
Description: Added a prompt window to (RDBCFG Add screen) Schema field. This function will retrieve all available Schemas for the remote database catalog specified. A Catalog/Service, User Name, Password, IP and Port are required to connect to the remote database. Currently this will work with the following databases (MSSQL, ORACLE, and POSTGRES).

Type: New
Description: RDBSetCharStr(Set character stream after a prepared statement. This allows up to 32767 characters to be set.)

RDB Connect - Version 4.01

Date: 01/23/2015

Type: New
Description: Added a new API RDBSetIsoTime. RDBSetIsoTime sets the time under ISO Format to transfer from IBMi to a compatible remote database. The function is only valid when RDBPrepStmt has been previously executed. Syntax rc = RDBSetIsoTime(ID: FieldNumber: TIME);

Type: Fix
Description: Modified RDBConnect configuration screen to prevent Users from error out when adding Remote Server ID's with invalid IBMi characters.

RDB Connect - Version 4.0

Date: 01/04/2019

Type: Fix
Description: Modified RDBConnect job to use RDBQPRINT file for errors that were sent to IBM's default print file QPRINT. RDBCOnnect will clear the PF member every time it starts.

Date: 07/17/2018

Type: Fix
Description: Fixed problem in RDBCFG when tracelog file was too big.

Date: 01/09/2018

Type: Fix
Description: fixed problem when inserting a *loval value from IBMi to MSSQL using a DS. The value inserted will be 1900-01-01 00:00:00.000 when the value in IBMi is *LOVAL.

Date: 09/28/2017

Type: Fix
Description: REMOVED CONNECTION PROGRAM FROM TRACELOGS TO PREVENT ERROR WHEN CONNECTING TO ODBC DB

Date: 12/04/2014

Type: Fix
Description: RDBCFG - Added validation to prevent spaces in between Remote Server Id when adding a new entry.

Type: Fix
Description: Added validation to prevent spaces in between Remote Server Id when adding a new entry.

Date: 11/10/2014

Type: New
Description: New RDBConnect Menu for quick access to commands. The following commands were added to RDBConnect Menu. RDBCFG(RDB Configure), RDBJARCFG(JAR Configuration), RDBTABLES(Database Tables), RDBFIELDS(Database Fields), RDBRUNSQL(Run SQL Statemnt), RDBTRACE(Turn Tracing ON/OFF), RDBIMPORT(Database Import), RDBEXPORT(Database Export), and RDBPTF(PTF Processor).

Type: New
Description: New command RDBEXPORT to transfer data from IBMi to a remote Database. All fields can be transfered or specify specific fields can be selected using an SQL statement. The subfile at the top contains the IBMi file columns and a subfile at the bottom contains the remote database details. The screen includes a Field Name Description, Field Name, Type Name, Type, NULL, Length and Decimal. Added function key F6 to create the Table and transfer data to remote database if it does not exist.

Type: New
Description: New API RDBsetIsoDate to transfer ISO Dates from IBMi. This prevents errors when transfering to another IBMi machine.

Type: New
Description: New edit when importing to IBMi, prevents invalid characters on IBMi file columns. The first position of column fields only allows letters and the following characters $#%@. An 'X' is added to the first position of the column name when the character is an underscore or numeric.

Type: New
Description: Added new functions to (RDBCFG) Manage Remote Systems. 1.Function key F7 displays the trace logs when trace logs have been turned on. 2.Function key F8 displays the IFS directory. 3.Function key F20 can end and start RDBSBS subsystem. 4.Function key F21 can clear the tracelogs directly from here and start a new tracelog entry. Option 8 from the subfile field can display RDBTABLES directly from here. Added a RDBSBS job status to the screen, a log file size was added to display the size of the tracelogs file. A log size max was added to warn a specified user when the trace logs have exceeded the warning size.

Type: New
Description: RDBTABLES - Added an option column to display the fields for each table directly from here. An F4 Prompt key was added to select a different remote database.

Type: New
Description: RDBTRACE - Added a log file warning size max to send a message to a specified User when the log file size has maxed out. An option Y/N to send the warning message. User profile specification for the User where the message will be sent.

Type: New
Description: Added validation programs to prevent users from leaving the Server Name, File or Library blank on screen prompts.

Type: New
Description: New mouse double-click feature was added to all display program F-Keys to function the same way as keyboard F-Keys.

Type: New
Description: Added function on all display program F-Keys to use the left mouse button double click function along with the keyboard F-Keys.

Type: New
Description: Upgraded Java Environment System Library to (JDK 1.5.0.11). IBMi Java needs to be updated to version 5 before installing RdbConnect 4.0

Type: Fix
Description: Fixed error when transfering file containing DATE and TIME fields from one IBMi to another IBMi.

Type: Fix
Description: Fixed "Invalid Fetch Size" error when Inserting/Updating ODBC Database.

Type: Fix
Description: Changed DATETIME format (yyyy-MM-dd-kk.mm.ss.SS) to 24 hours instead of 12 hours when transfering from and to IBMi TimeStamp fields.

Type: Fix
Description: Can't add numeric fields to POSTGRESQL. Fixed RDBConnect to insert or update numeric fields in API's RDBADDREC/RDBUPDREC.

Type: Fix
Description: RDBCFG - Fixed the Database Type Description to populate correctly on the Database Type Window when pressing F4=prompt in add mode.

Type: Fix
Description: RDBCFG - Fixed the Turn Tracing On function, turns trace logs ON/OFF.