Re: [WDSCI-L] VisualAge RPG and DB2 Personal (Developer's) Edition

[Peter.Colpaert@xxxxxxxxxx]

Bruce,

Strange, in the VisualAge RPG Language Reference Chapter 7 "SQL support" 
it is said that

The VisualAge RPG embedded SQL support differs from most other 
implementations in that there is no separate precompiler for creating the 
intermediate file which is then compiled. The embedded SQL statements are 
handled during the compile step of the build process. 

Your application can be built to use local databases, databases on other 
workstation nodes, or databases on other iSeries servers. Any differences 
in the level of SQL supported on these other systems are overlooked with 
the level of SQL supported on the workstation where the build is 
performed. Only the syntax supported by DB2 on the build-time workstation 
is allowed.

I understood this as if VARPG can access DB2 P(D)E.  Or is a "local 
database" not exactly that?

When referring to the "Quick Beginnings for DB2 Personal Edition", VARPG 
is of course nowhere mentioned.

Any IBM'ers on this list care to shed a light here?

Thanks,

Peter Colpaert
Application Developer
Massive - Kontich, Belgium
-----
Yoda of Borg are we.  Futile is resistance, assimilated will you be.
-----




R Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>
Sent by: wdsci-l-bounces@xxxxxxxxxxxx
25/04/2005 15:48
Please respond to Websphere Development Studio Client for iSeries

 
        To:     Websphere Development Studio Client for iSeries 
<wdsci-l@xxxxxxxxxxxx>
        cc: 
        Subject:        Re: [WDSCI-L] VisualAge RPG and DB2 Personal 
(Developer's) Edition


On Fri, 2005-04-22 at 05:39, Peter.Colpaert@xxxxxxxxxx wrote:

> Is it possible to use embedded SQL in VisualAge RPG to connect to a 
> database on the same PC in DB2 PE or DB2 PDE?

The question and the answer lay in whether or not DB2 UDB for LUW
supports a pre-compiler for RPG, particularly VA RPG.

I believe the answer is no. Beginning on like page 8 of the Application
Building Guide is a long list of languages supported by the pre-compiler
for various Operating Systems and nowhere is RPG listed in any form.


> As a side question, I understood that *remote files in VARPG always need 

> to be on an AS/400 - iSeries - i5 - iNameDuJour.  Or can you also use a 
> local DB2 PE for this?

The DB2 UDB for LUW does not support a "native" IO method, if that's
what you are asking.




-- 
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.