10 pts.
Q:
Embedded SQL
I need to get a grip on using the embedded SQL in an RPG ILE program using the word "CURRENT" and I need to know how this works (in laymens terms please.)
ASKED: Oct 11 2008  6:51 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
145 pts.
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • Bookmark and Share
Well.
If you go to 'http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp'
and search on 'DB2 for i5/OS SQL Reference' select the first result in the left pane, and on the resulting page navigate down to 'Printable PDF's, you can download the reference manual that you will find most helpful. Some 1300 pages of good stuff.

As far as CURRENT goes, you'd have to be more specific. CURRENT is used in the names of several special registers such as CURRENT DATE, CURRENT DEBUG MODE, CURRENT SERVER, etc. It is also used in other places such as the WHERE CURRENT clause during cursor processing.

Beyond that, feel free to ask any specific questions. I'm sure there are many greater experts on the topic than I that visit this forum regularly, but I do work with it all the time and will be happy to help.
Last Answered: Oct 11 2008  8:53 PM GMT by Renojim   145 pts.
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _