Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

diff btw SQLJ and E/SQL

 
deep venu
Ranch Hand
Posts: 56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
could nebody tell me the pros and cons between using SQLJ or E/SQL programs..
basically the need to extract from data from multiple tables at regular intervals and then used the data to make XML type file format to be put on to queue...am welcome ny suggestions beside using one of the above mentioned ones...
 
Nigel Browne
Ranch Hand
Posts: 703
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
SQLJ is a layer that sits onto of jdbc. It allows you embed SQL in java code. It requires a translator and runtime, but once set up it allow you to perform queries, writing fewer lines of code than when using JDBC calls to the database.
[ February 13, 2002: Message edited by: Nigel Browne ]
 
deep venu
Ranch Hand
Posts: 56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanx nigel..
since i haven't worked on either on sqlj oe e/sql like ProC would it possible to say which one scores more than the other?
 
Nigel Browne
Ranch Hand
Posts: 703
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I only have experience of SQLJ on oracle. I found the basics very easy to learn and the advanced features were great once I had understood the concepts. One feature I really like is the named iterator.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic