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 ]
Joined: Jun 09, 2001
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?
Joined: May 15, 2001
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.