Re: Display File for SQLRPGLE program.

You can use display files in SQLRPGLE.  However, you cannot run a SQL over
the display file.  For instance...

  Select * From Display1

I believe it will compile, it just won't collect any information.

Put you can

Dow not *InKC;
   exfmt Display1;
   If *inkc;
     leave;
   endif;
   exsr edit#;
   if anyerrors;
      iter;
   endif;
   exsr performSQL#;
endDo;

This code is valid in a SQLRPGLE.

Michael Schutte
Work 614-492-7419
email  michael_schutte@xxxxxxxxxxxx


                                                                           
             Pete Helgren                                                  
             <Pete@xxxxxxxxxx>                                             
             Sent by:                                                   To 
             rpg400-l-bounces@         RPG programming on the AS400 /      
             midrange.com              iSeries <rpg400-l@xxxxxxxxxxxx>     
                                                                        cc 
                                                                           
             04/04/2006 04:52                                      Subject 
             PM                        Re: Display File for SQLRPGLE       
                                       program.                            
                                                                           
             Please respond to                                             
              RPG programming                                              
              on the AS400 /                                               
                  iSeries                                                  
             <rpg400-l@midrang                                             
                  e.com>                                                   
                                                                           
                                                                           




Michael is correct.  You will need a separate program to prompt for the
value or you can use a display file inline to your CL program because
the SQLRPGLE source type won't accommodate a display file and I/O from
that file (as far as I know).

There are plenty of examples of using a CL to prompt for and pass the
value.  As an alternative you could just front end the program with a
command prompt but that would give you only a limited set of editing
options.

Several ways to skin the cat (no offense to PETA....)  You may want to
look at using a display file within a CL program first.

Pete


Jake M wrote:

>Michael and Pete,
>Thanks a lot for the suggestions and I agree with Michael my programming
>style is really crude because I am just trying to get the code to work for
>now...:-) but I will definitely take your suggestions into consideration
as
>a matter of fact I already modified my code. Pete, I never coded a display
>file before and you are right I have to get comfortable with that concept.
>Too bad that it is not as easy as a .jsp front end!! So, a CL program is a
>must to go with it? or is it just a good thing to have? Thanks for all the
>help coming my way
>
>
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.