MC Press Online Forum
Welcome, Guest
Please Login or Register.    Lost Password?
TechTip: Speed Up SQL Procedures with Service Program Support (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: TechTip: Speed Up SQL Procedures with Service Program Support
#121999
dwhitehouse@madico.com (User)
Fresh Boarder
Posts: 8
graphgraph
User Offline Click here to see the profile of this user
TechTip: Speed Up SQL Procedures with Service Program Support 3 Months, 3 Weeks ago Karma: 0  
This thread discusses the Content article: TechTip: Speed Up SQL Procedures with Service Program Support

Kent,

Can C generated service programs created by SQL be used directly in an RPG program (having mapped the parms correctly) - or, can they only be called via embedded SQL? If so, what issues may one encounter with mapping RPG & C parms?

Daron
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#122000
K.Milligan (User)
Fresh Boarder
Posts: 11
graphgraph
User Offline Click here to see the profile of this user
Re:TechTip: Speed Up SQL Procedures with Service Program Support 3 Months, 3 Weeks ago Karma: 0  
The C program & service program objects generated by SQL procedure must be called with an SQL CALL statement. There are several hidden parameters that the SQL CALL interface handles and processes.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#122001
dwhitehouse@madico.com (User)
Fresh Boarder
Posts: 8
graphgraph
User Offline Click here to see the profile of this user
Re:TechTip: Speed Up SQL Procedures with Service Program Support 3 Months, 2 Weeks ago Karma: 0  
That would figure.

As a rule, when a function is deemed usable for both SQL and RPGLE, we will create an RPG subprocedure and then an SQL stored procedure of function wrapper which to call the subprocedure. Is this common practice?

Thanks
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#122002
K.Milligan (User)
Fresh Boarder
Posts: 11
graphgraph
User Offline Click here to see the profile of this user
Re:TechTip: Speed Up SQL Procedures with Service Program Support 3 Months, 2 Weeks ago Karma: 0  
I've heard of customers sharing SQL procedures in a similar manner. However, usually the SQL users of the procedures are on remote clients.

Are you using SQL procedures instead of SQL embedded in RPG programs because the coding is simpler?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop
   MC-STORE.COM