RE: Can you do this in SQL

[Joel Fritz <JFritz@xxxxxxxxxxxxxxxx>]

I used to get a freebie magazine (now defunct) that had a wonderful SQL
column by Joe Celko.  Every column had a problem to solve.  Many of the
problems would have been easy to solve in a procedural language, but were
very difficult in SQL. OTOH, some problems are the exact reverse.  It kind
of depends. <g>

> -----Original Message-----
> From: M. Lazarus [mailto:mlazarus@ttec.com]
> Sent: Tuesday, January 29, 2002 4:42 PM
> To: midrange-l@midrange.com
> Subject: RE: Can you do this in SQL
>
>
> Joe,
>
> At 1/29/02 05:31 PM, you wrote:
> >RPG is an excellent language for doing database I/O.  Why
> people insist on
> >"getting away from it" is beyond my meager intellectual
> capabilities.  Maybe
> >it's "new-itis".
> >
> >I dunno, but I think my 5-line, two-program solution beats
> your 100-line, 3
> >object technique any day of the week.
>
>   I wholeheartedly agree.  As people try accomplish more w/ SQL, I'm
> finding that it often becomes unintelligible.  SQL is
> wonderful for certain
> straightforward tasks, but complex, record at a time tasks
> are usually done
> better in RPG.
>
>   -mark
>
NOTICE:
All e-mail sent to or from this e-mail address will be received or otherwise
recorded by The Sharper Image corporate e-mail system and is subject to
archival, monitoring, review by and/or disclosure to Sharper Image security
and other management.  This message is intended only for the use of the
addressee and may contain information that is privileged and confidential.
If you are not the intended recipient, dissemination of this communication
is prohibited.