RE: RE: Visual Basic and AS/400 -- MIDRANGE-L

Title: RE: RE: Visual Basic and AS/400

I think we could create stored procedures calling service program, creating multiple entry points for different parameters, and return result sets back. We could use this technique for over loading as well, by creating multiple stored procedures with same name but with different parameters and multiple entry points in service programs with parameters to match. Since the SQL creates unique internal name for each of these procedures, it is not very difficult to handle. But it is a hassle later to drop one of them in particular.

Sudha

Sudha Ramanujan
System Team Leader
SunGard Futures Systems

-----Original Message-----
From: Schenck, Don [mailto:Don.Schenck@pfizer.com]
Sent: Thursday, March 15, 2001 12:42 PM
To: 'MIDRANGE-L@midrange.com'
Subject: RE: RE: Visual Basic and AS/400

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