RE: Getting data from a windows database in rpg

Gerald,
Was this coded in-house or purchased?
Coded in-house and released as a product for purchase.

Native API's - is that iSeries or windows api's?
The API's can be used in C, ILE/C, ILE/RPG, ILE/CL, ILE/COBOL or PASCAL (if
you have it).
OS/400 API form such as Rc = ISSQLConnect(ApiErr) which makes the connection
to your SQL server after the connection string variable has been loaded in a
Windows format. 

Commands to perform simple gets, puts, and deletes? 
Not really, I said it backwards - They are simple commands, but perform
simple or complex gets, puts and deletes to remote SQL tables.
The Get Table Command retrieves the records based on the where statement
(simple or complex), creates the file when required, saves the source from
the create and copies the records based on the selection into the file. The
OVERWRITE keyword will allow you to add/overwrite or any combination an
existing file.

I need to do sort of the same thing. Basically the equivalent of an RPG
chain operation to an SQL server to determine record existence or
non-existence.
One call to the API to open the connection (which you can leave open for the
entire run of your program) and 3-5 lines of code to set the Where
condition, make the call to the
ISRtvCount('master':'advworks':'products':sWhere) API and check the number
of records returned. One call to the ISSQLClose(ApiErr) at termination.

Care to share more info?
You can find more info at iStudio400.com including a short presentation on
the functionality. 

I will send you an off list e-mail with better details. 

John Brandt
iStudio400.com
(903) 523-0708

-----Original Message-----
From: GKern@xxxxxxxxxxxxxxxx [mailto:GKern@xxxxxxxxxxxxxxxx]
Sent: Wednesday, May 19, 2004 7:17 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: Getting data from a windows database in rpg


"Yes,
We have done it, but it doesn't use JDBC drivers. It is a purely native 
set
of API's and commands that allow direct access both directions including a
trigger subsystem to synchronize from AS/400-iSeries to and from MSSQL
server. It also includes commands for non-programmer types to perform 
simple
gets, puts and deletes."

I need to do sort of the same thing. Basically the equivalent of an RPG 
chain operation to an SQL server to determine record existance or 
non-existance.

Was this coded in-house or purchased?

Native API's - is that iSeries or windows api's?

Commands to perform simple gets, puts, and deletes? 

Care to share more info?

Regards,

Gerald Kern
IBM Certified AS/400 RPG IV Developer & RPG IV Programmer
MIS Project Leader, Lotus Notes/Domino Administrator
The Toledo Clinic, Inc.
4235 Secor Road
Toledo, OH 43623-4299
Phone 419-479-5535
gkern@xxxxxxxxxxxxxxxx
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.665 / Virus Database: 428 - Release Date: 4/21/04
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 5/18/04