Re: [WDSCI-L] Two VARPG questions

[rob@xxxxxxxxx]

I "assume" that VARPG can call a stored procedure, can it not?  And I 
would be willing to bet that it doesn't even require the SQL precompiler 
on the iSeries since it's all client code.  If so, then make your 
subprocedure, in your service program either a "Stored Procedure" or a 
"User Defined Function" by executing the Create Procedure or Create 
Function on your iSeries by using any number of tools:
- freebies:  put it in a source and CRTQMQRY and STRQMQRY,   or use 
iSeries Navigator scripts
- STRSQL

Then just call the stored procedure from your client.  From a RPG program 
on my iSeries to call a RPG program on another iSeries I use this 
technique.  Then my calling program just looks like:
     C/EXEC SQL
     C+ CONNECT TO :Systemname
     C/END-EXEC
     C/EXEC SQL
     C+ CALL ROUTINES/GDSSYS002 (:SysAsp, :PctSysAsp, :PctPerm, :PctTemp)
     C/END-EXEC 
A lot of the error checking, disconnecting, etc is not shown.
On your host you'll need
WRKRDBDIRE
and it's *LOCAL entry.

Granted, I've not written a speck of VARPG and I don't know if they built 
in anything better.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Mike Tobey" <Mike.Tobey@xxxxxxxxxxxxxxxxx> 
Sent by: wdsci-l-bounces@xxxxxxxxxxxx
11/29/2004 12:32 PM
Please respond to
Websphere Development Studio Client for iSeries <wdsci-l@xxxxxxxxxxxx>


To
<WDSCI-L@xxxxxxxxxxxx>
cc

Subject
[WDSCI-L] Two VARPG questions






1. Is there a email list like this for VARPG?  I know of the newsgroup but 
my company is reluctant to give me access to it. 
2. Can a VARPG program call a procedure that resides in a service program 
on the iSeries?  I have looked but cannot find a way to define the 
prototype so that I don't receive a linkage error.

Any help would be appreciated.

Thanks in advance.

Michael Tobey
Applications Analyst
Foremost Farms USA
mike.tobey@xxxxxxxxxxxxxxxxx
IBM Certified AS/400 RPG IV Developer & RPG IV Programmer



_______________________________________________
This is the Websphere Development Studio Client for iSeries  (WDSCI-L) 
mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.