RE: RE: Visual Basic and AS/400

["Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>]

Don,

You sure can (write all the DB IO in RPG). However, I don't believe you can
call an entry point other than the main one in your RPGLE programs.

I tend to take the middle road in my applications. Data reads that return
simple lists (select name, address from customer where state = 'NY') are
coded as SQL calls from the PC. Complex data lists (list orders for customer
12 where a line is open and the item is in stock or scheduled in stock in
the next day in either the Harrisburg or Elkhart warehouse) and _ALL_ data
updates are done via stored procedure calls implemented as RPG programs.

To return a set of records from the RPG program you need to use the SET
RESULTS SET SQL operation. This is one of the most powerful yet overlooked
operations in SQL.

-Walden 


-----Original Message-----
From: Schenck, Don [mailto:Don.Schenck@pfizer.com]
Sent: Wednesday, March 14, 2001 7:45 AM
To: 'MIDRANGE-L@midrange.com'
Subject: RE: RE: Visual Basic and AS/400


QUESTION:

It's possible to call an RPG program from within a VB program, right?

And it's possible to create an ILE RPG program with multiple entry points,
right?? An "object", if you will.

So my question is: Can't you write all the data access routines in ILE RPG,
and simple call them from the VB programs??

'Nother question: HOW does one return a SET of records from the ILE RPG
program to VB??



-- Don Schenck
   Schenck Technical Consulting
   DonS@SchenckTech.com / www.SchenckTech.com 

> -----Original Message-----
> From: Andy Leisk [mailto:ALeisk@banta.com]
> Sent: March 13, 2001 6:37 PM
> To: midrange-l@midrange.com
> Subject: Re: RE: Visual Basic and AS/400
> 
> 
> yes the AS/400 is just another data server, but does any one 
> have any examples
> of how to use an MS ADO Data Control 6.0 OLDEB for accessing 
> an AS/400 data
> object (a physical or logical file).
> 
> 
> Andy Leisk
> Stratagem Inc., I.T. Consultant at Banta Corp.
> (Rent-a-programmer and AS/400 computer janitor)
> 920-751-4434
> 
>  >>> owner-midrange-l@midrange.com 03/13 8:29 AM >>>
> Alan --
> 
> Don't think about the AS/400 ... just learn VB. The AS/400 is 
> just another
> database server.
> 
> 
> -- Don Schenck
>     Schenck Technical Consulting
>     DonS@SchenckTech.com / www.SchenckTech.com
> 
> 
> 
> -----Original Message-----
> From: Alan Novick [mailto:mida@pressmantoy.com]
> Sent: March 13, 2001 8:53 AM
> To: MidRange-L
> Subject: Visual Basic and AS/400
> 
> 
> What are some good resources for learning about using Visual 
> Basic with the
> AS/400?
> 
> Thanks,
> 
> Alan Novick
> Pressman Toy Corp
> New Brunswick, NJ
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to 
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: 
> david@midrange.com
> +---
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>                              
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to 
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: 
> david@midrange.com
> +---
> 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---