Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JTOpen for iSeries: evaluating native access.

 
Claude Moore
Ranch Hand
Posts: 829
7
IBM DB2 Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Good morning,

we're using JTOpen JDBC driver to access iSeries dbms. It works fine and well, anyway we run in the need of executing massive data crunching. I've been asked to evaluate "native" access (I mean "record level access") instead of SQL access. Before running any test, I'd like to know if anybody used this approach and with which performance results. By the way: I'm aware that using Record Level access mines portability of our code. Within the scenario this approach will be targeted to, it is not a problem at all.

Thanks in advance for your support.
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
maybe this would make sense to the right person.
But to me you need SQL to get access to the records, so what is SQL access? and what is record level access (isn't everything accessing records)?
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Wendy Gibbons wrote:maybe this would make sense to the right person.
But to me you need SQL to get access to the records, so what is SQL access? and what is record level access (isn't everything accessing records)?


ahhh are you meaning native JDBC sql statements over using JTOopen? (which i just looked up and is a database layer thingy like hibernate or OpenJPA)
 
Claude Moore
Ranch Hand
Posts: 829
7
IBM DB2 Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry, I'd have been more explicit. With "record level access" I mean to use JTopen capabilities to read records in an RPG-like fashion, using DDS, CHAINS and similar constructs.... I'm far to be an expert on this ( I don't know RPG language).
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic