Re: SQL knowledge, was (Re: Válasz: AW: Another order by question ? / Thanks)

Let me put in a plug for three excellent SQL courses offered by IBM:

http://www-3.ibm.com/servlet/com.ibm.ls.lsow.servlets.CourseDescriptionServlet?coursecode=S6137

http://www-3.ibm.com/servlet/com.ibm.ls.lsow.servlets.CourseDescriptionServlet?coursecode=S6138

http://www-3.ibm.com/servlet/com.ibm.ls.lsow.servlets.CourseDescriptionServlet?coursecode=S6139


If you have questions, you may write me offline.

Bob

Bob Slaney/Atlanta/IBM@IBMUS (Lotus Notes)
Internet id: rjslaney@us.ibm.com
VM id: DALVM1.RJSLANEY@VM

Tieline 596-3022 Direct (770)835-3022
Fax tie 596-3912 Direct (770)835-3912

IBM Learning Services
iSeries Courseware Developer
IBM Corp.
3100 Windy Hill Road
Atlanta, GA 30339
Internal Zip WE3A1


rob@dekko.com@midrange.com on 07/03/2001 10:20:14 AM

Please respond to RPG400-L@midrange.com

Sent by:  owner-rpg400-l@midrange.com


To:   RPG400-L@midrange.com
cc:
Subject:  SQL knowledge, was (Re:  Válasz: AW: Another order by question ?
      / Thanks)




I've dabbled in SQL for years.  But how is it recommended that I learn all
of these options?  When I studied in college it focused on specific
languages and database concepts were not part of the community college
scene.  But then again, I left a university with punched cards for a
community college with a S/34 and all the terminal time you wanted.  And I
don't miss programming fortran in which the disgruntled grad student wanted
to show off his knowledge of advanced calculus versus showing you the
programming concepts involved.
But please focus on SQL and not my rant on education.

Rob Berendt

==================
A smart person learns from their mistakes,
but a wise person learns from OTHER peoples mistakes.



                    Refaie.Heba@khb.h
                    u                        To:     RPG400-L@midrange.com
                    Sent by:                 cc:
                    owner-rpg400-l@mi        Subject:     Válasz: AW:
Another order by question ? / Thanks
                    drange.com


                    06/26/2001 08:53
                    AM
                    Please respond to
                    RPG400-L







Hi Group

Thanks for all the advices, I changed the statement to

 C/EXEC SQL
  C+   DECLARE @CURSOR1 CURSOR FOR
  C+   SELECT  file1.flda , file1.fldb , file1.fldc,
coalesce(file2.seqno,999)
  C+   FROM file1 LEFT JOIN file2
  C+   ON file1.fldb  = file2.fldb
  C+   AND file1.fldc = file2.fldc
  C+   ORDER BY coalesce(file2.seqno,999)
  C/EXEC SQL

and it works sharply...

All the best
Heba



+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---


+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---