× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: RE: RE: Visual Basic and AS/400
  • From: "Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>
  • Date: Thu, 15 Mar 2001 14:19:06 -0500

Title: RE: RE: Visual Basic and AS/400
I don't think you can get to the result sets without dropping to the CLI. I've never played there so I can't say. Ideally you could do the following "select col1, col2 from (call storedProc) where col2 = 'N'" and use the call to the stored procedure as a data source but I haven't found a way to have SQL/400 eat this.
 
-Walden
-----Original Message-----
From: Sudha Ramanujan [mailto:SRamanujan@sungardfutures.com]
Sent: Thursday, March 15, 2001 12:03 PM
To: 'MIDRANGE-L@midrange.com'
Subject: RE: RE: Visual Basic and AS/400

Walden,
I have been using these result sets myself that are read by the java programs.  But would you know if these programs could be called by other rpgle programs and deal with these result sets within AS/400?  I thought  they needed CLIs.  Have you worked on them?

Thanks for the help.
Sudha

Sudha Ramanujan
System Team Leader
SunGard Futures Systems

-----Original Message-----
From: Walden H. Leverich [mailto:WaldenL@TechSoftInc.com]
Sent: Thursday, March 15, 2001 10: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
+---


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.