diff btw SQLJ and E/SQL

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

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

Joined: Jun 09, 2001
Posts: 56

posted Feb 13, 2002 08:38:00

0

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

Joined: May 15, 2001
Posts: 673

posted Feb 14, 2002 03:10:00

0

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.