Skip to main content

RDB Connect - Version 4.04


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: 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.