Writing Stored Procedures In SQL

Writing Stored Procedures In SQL

The question that I had about LIKE with global variables in SQL is pretty much a non-issue now. The more work I did on this translation from 4GL to SQL, the global variables that had been used in 4GL became less and less relevant to the code. Global variables are sometimes necessary, in some languages more than others, but when you can find a way to make them go away completely--all the better.

I also had my second occasion to do some Java work--although in this case, fiddling with Java beans. Still, at least there's a debugger in Java. SQL debugging under Informix is perilously close to printf.