RPQSQL / SQLRPG

50 pts.
Tags:
RPG
RPG ILE
RPG IV
RPG/400
RPGLE
RPGSQL
SQLRPGLE
Any body please help Wanted to know the advantage and disadvantage using RPGSQL / SQLRPG I've heard that this is the new one its not only RPG but become one with SQL. Thanks in advance

Answer Wiki

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

Hi,

SQLRPG isn’t that new, it’s been around for some time now. It basically allows you to use SQL statements in your RPG program for database operations (embedded SQL). You can embed SQL in ILE RPG or OPM RPG.

The main advantage is that it allows some very complex data selections, which would otherwise involve a lot of RPG coding and database I/O.

The main disadvantage is that it can use a lot of machine resource and adversely affect the performance of your machine. This is very much dependent on how you use it and your database design.

Regards,

Martin Gilbert.

Discuss This Question: 1  Reply

 
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
  • TomLiotta
    The main disadvantage is that it can use a lot of machine resource and adversely affect the performance of your machine. That in itself isn't a disadvantage. Writing pure RPG to do the same poorly conceived database operations would result in performing just as badly -- and be much more complex and potentially more difficult to correct. Tom
    125,585 pointsBadges:
    report

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