Home > IT Answers > AS/400 > RPQSQL / SQLRPG
Help

Question

  Asked: Jun 25 2008   0:31 AM GMT
  Asked by: TG

RPQSQL / SQLRPG


RPG, RPG ILE, RPG IV, RPG/400, RPGILE, RPGLE, SQLRPG, RPGSQL

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

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Jun 25 2008  9:21 AM GMT  by Gilly400





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.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on AS/400.

Looking for relevant AS/400 Whitepapers? Visit the Search400.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register