Re: [WDSCI-L] VARPG and MySQL

[Claus Weiss <weiss@xxxxxxxxxx>]

Hi Peter, you will need to use the VARPG ODBC part, embedded SQL only works
with DB2.

Claus Weiss Visual AD tools, email: weiss@xxxxxxxxxx
Dept 522 IBM Canada Lab tie 969-3987 Phone(905)413-3987 FAX(905)413-4850
Greetings from Toronto
WDSc for iSeries homepage: ibm.com/software/awdtools/iseries
WDSc newsgroup: news://news.software.websphere.studio400     |   VARPG
newsgroup: news://news.software.ibm.com/ibm.software.varpg,


                                                                           
             "Peter Colpaert"                                              
             <Peter.Colpaert@m                                             
             assive.be>                                                 To 
             Sent by:                  WDSCi-l@xxxxxxxxxxxx                
             wdsci-l-bounces@m                                          cc 
             idrange.com                                                   
                                                                   Subject 
                                       [WDSCI-L] VARPG and MySQL           
             03/29/2005 04:15                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
                 Websphere                                                 
                Development                                                
             Studio Client for                                             
                  iSeries                                                  
                                                                           
                                                                           




Hi group,

A few days ago I inquired on this forum about random numbers in VARPG.

I have meanwhile discovered that I can simply use the rand() function in
MSVCRT, which seems more or less to correspond with QC2LE on the iSeries.

However, someone also mentioned using MySQL as a database server.

My question now is, whether you can simply use embedded SQL to address a
MySQL server, or that you need to use the ODBC/JDBC part, which seems to
be a lot more complex.

I could not find any reference to this in the manual nor in the archives.
Google only turned up some resumes of people knowing both VARPG and MySQL.

Thanks in advance.

Peter Colpaert
Application Developer
Massive - Kontich, Belgium
-----
Yoda of Borg are we.  Futile is resistance, assimilated will you be.
-----
--
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.