RE: Big, Honking SQL Statement

SQL-CLI = Structured Query Language Call Level Interface.
1 - There's a section on this in the InfoCenter
2 - There's some coverage of this in the RPG Sorcerer's Redbook.
Basically used by a few people:
- Those who can't get their bosses to pop for 5722-ST1.
- Those running obsolete versions of OS/400 and who are frustrated with 
precompiler issues that have been mostly resolved since V5R3.
- Those who'd rather spend the extra time coding CLI (vs the ease of 
imbedded SQL) than spend some time with an attractive member of the 
opposite sex
- I think there might be one or two obscure function only available with 
CLI versus imbedded sql
- A strange software house that wants to pi$$ off 95% of their customers 
who modify their code who now have to learn CLI versus easy imbedded sql 
in order for that same software house to sell packages to the 5% of their 
customer base that doesn't want to pop for 5722-ST1.

Rob Berendt