What is the difference between using RPGLE and SQLRPGLE when updating a file?

55 pts.
Tags:
RPGLE
SQLRPGLE
What is the difference in updating a file using RPGLE or SQLRPGLE?

Software/Hardware used:
AS400

Answer Wiki

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

The main difference is that when using rpgle, you are restricted to doing one record at a time processing; whereas with sqlrpgle, you can use SQL statements and processed multiple rows with a single command.

Discuss This Question: 4  Replies

 
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 question doesn't make much sense. First, "rpgle" and "sqlrpgle" are nothing more than types that have meaning to PDM and SEU. You can use any "type" you want, and it won't change requirements for code in the program. You can code both to look exactly the same if you wish, no difference at all. But second, "sqlrpgle" normally uses SQL and "rpgle" doesn't, which is pretty clearly indicate by the "type". What exactly do you need to know? -- Tom
    125,585 pointsBadges:
    report
  • abhisheka1
    If I am not mistaken , This question is been asked in cotext of performance level. Updating data base using embedded or only RPGLE which gives better performance.
    400 pointsBadges:
    report
  • hunshabbir7
    yes I also think so, question is in context of performance.
    2,300 pointsBadges:
    report
  • hunshabbir7
    It depends on whether or not this is an interact or batch application. If batch, it shouldn't matter. If interactive, there will be a longer "up front" delay with SQL. In other words, if you're writing a report, I'd recommend whichever method you're most comfortable with. If you're loading a page-at-a-time subfile, it'll take longer for and SQLRPGLE program to load the first page, so right off the bat you're users have to sit there and wait. Go with native I/O.

    Reference: here
    2,300 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