RE: RE: Visual Basic and AS/400

["Schenck, Don" <Don.Schenck@xxxxxxxxxx>]

But ... but ...

I thought the idea of ILE was several entry points???



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

> -----Original Message-----
> From: Walden H. Leverich [mailto:WaldenL@TechSoftInc.com]
> Sent: March 15, 2001 11:33 AM
> To: 'MIDRANGE-L@midrange.com'
> Subject: RE: RE: Visual Basic and AS/400
> 
> 
> 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
> +---
> 
+---
| 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
+---