RE: RE: Visual Basic and AS/400

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

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