Embedded SQL

10 pts.
Tags:
Embedded SQL
RPG
RPG ILE
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.)

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following