1 / 8

DB-Gate vs. RDB Connect

IBM i Remote Database Access. DB-Gate vs. RDB Connect. Compiled on June 27, 2012. Comparison: DB-Gate vs. RDB Connect. 2. ProData’s RDB Connect. Does not work in Start SQL (STRSQL) Based on APIs

keith
Download Presentation

DB-Gate vs. RDB Connect

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. IBM i Remote Database Access DB-Gate vs.RDB Connect Compiled on June 27, 2012

  2. Comparison: DB-Gate vs. RDB Connect 2

  3. ProData’s RDB Connect • Does not work in Start SQL (STRSQL) • Based on APIs • New API-based language that requires special, non standard, programming to include it in RPG, COBOL • Must handle each column individually • No high-level activity log • Not integrated with i5/OS Server Authentication System (this is a method that eliminates repetitive use of User/Password) Example of RDB Connect in RPGLE: C Eval Id = RdbConnect('SQLSVR': :'me':'mypass') C Eval rc = RdbExec(Id:'Select * from [dbo].[Orders]') C Eval rc = RdbFetchNxt(Id) C Eval Field1 = RdbGetParmNum(Id:1) <- get numeric field C Eval Field1 = RdbGetParmStr(Id:1) <- get char field C Eval Field1 = RdbGetParmDate(Id:1) <- get date field 3

  4. Raz-Lee’s DB-Gate • Enables IBM i to initiate a connection, for SQL access, natively to Oracle, Microsoft SQL Server, PostgreSQL, MySQL, SQLite… • Uses standard SQL statements (no API required) • Works interactively in Start SQL (STRSQL) • Works with standard SQL in RPG, Cobol, C • Agent-less, Automatic handling of columns, supports F4=Prompt for remote table column names • Includes high-level activity log • Integrates i5/OS Server Authentication System • Patent Pending technology 4

  5. DB-Gate Examples Example of DB-Gate in RPGLE: C/EXEC SQL C+ DECLARE C1 CURSOR FOR C+ SELECT * FROM CORPDATA.DEPT WHERE JOB = ‘MANAGER’ C/END-EXEC Example of DB-Gate in STRSQL: > SELECT * FROM PROD.CUST > CREATE VIEW CORPDATA.MANAGERS AS SELECT LASTNAME, DEPT FROM CORP.EM WHERE JOB = ‘MANAGER’ > DELETE FROM PROD.CUST WHERE ID = 78 5

  6. DB-Gate Sample Screen – Standard SQL, Native Use 6

  7. Comparison of Products The information in this presentation is based on owner’s websites: http://www.prodatacomputer.com/rdbConnect.shtml http://www.razlee.com/products/security/dbgate/dbgate.php Notes: • Coloring and statements made by Raz-Lee Security in this comparison presentation may be considered subjective • RDB Connect and ProData are trademarks of ProDataComputer Services 7

  8. Thank You! Please visit us at www.razlee.com marketing@razlee.com

More Related