RE: SQL Embedded in RPG ILE.

>Here is an interesting challenge. Anyone care to write this in java and
vb.
>As an old RPG programmer, I would be interested in seeing the
difference. 

You're really taking something out of context here. In Java, C#, VB,
etc. you'd most likely have a data layer that contained your plumbing.
Assuming you had such a layer, the equivalent code would be something
like:

---Begin---

If (Customer.Exists(12345)) {
        //Do something here
}

---End---

This assumes that your Customer class has a static method called
'Exists' that takes a customer number and returns true or false
depending on whether the customer exists.

Expand it out, say you wanted to get the customer's name.

---Begin---

Customer c = new Customer(12345);
Return c.Name;

---End---

What you're really asking for is to see all the plumbing code for the
Customer object, however, you're not taking into account that that code
would be written once and used everywhere.

-Walden

------------
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)