RE: Query/400 to RPG program -- RPG400-L

I'll grant you that.  One of the reasons that I try to encourage the use 
of Query Manager.  It doesn't have this problem.  Query Manager also supports 
the use of *LIBL.  Makes it easier to share queries.  However once a user get's 
their hands on Query you about have to peel their cold dead fingers off of it.





dleland@Harter.com on 02/25/2000 09:49:33 AM
Please respond to RPG400-L@midrange.com@Internet
To:     RPG400-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        RE: Query/400 to RPG program

The one thing I hate about queries is something that was brought up in a
previous post.  If I make a change to a database file, I can very easily
compile all RPG programs which reference the file (I use FNDSTRPDM w/
OPTION(*CMPL) quite a bit).  But, I can't w/ Queries.  I have to manually go
into each one.  And there isn't a good way to determine which queries use
the affected file.  For companies which make a lot of database changes
(our's is one), I strongly discourage Queries.

Dave

-----Original Message-----
From: Rob Berendt [mailto:rob@dekko.com]
Sent: Friday, February 25, 2000 7:20 AM
To: RPG400-L@midrange.com
Subject: Re: Query/400 to RPG program


What is so bad about Query?  Is this some sort of programmers union 
uprising?  'The users are access their own data without going through 
us!  Wait, lets remove the easy maintainability of Query and put it into
RPG!'





danielh@elp.rr.com on 02/25/2000 02:23:59 AM
Please respond to RPG400-L@midrange.com@Internet
To:     RPG400-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        Query/400 to RPG program

I just started working with RPG. This company lives on querys! They run
around a 80 different ones a day. Is there a good tool that anyone would
suggest that would convert querys to code. we run 3.7.

Thank you
Dan

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---


+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
<TITLE>RE: Query/400 to RPG program</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2>The one thing I hate about queries is something that was 
brought up in a previous post.&nbsp; If I make a change to a database file, I 
can very easily compile all RPG programs which reference the file (I use 
FNDSTRPDM w/ OPTION(*CMPL) quite a bit).&nbsp; But, I can't w/ Queries.&nbsp; I 
have to manually go into each one.&nbsp; And there isn't a good way to 
determine which queries use the affected file.&nbsp; For companies which make a 
lot of database changes (our's is one), I strongly discourage 
Queries.</FONT></P>

<P><FONT SIZE=2>Dave</FONT>
</P>

<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Rob Berendt [<A 
HREF="mailto:rob@dekko.com">mailto:rob@dekko.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Friday, February 25, 2000 7:20 AM</FONT>
<BR><FONT SIZE=2>To: RPG400-L@midrange.com</FONT>
<BR><FONT SIZE=2>Subject: Re: Query/400 to RPG program</FONT>
</P>
<BR>

<P><FONT SIZE=2>What is so bad about Query?&nbsp; Is this some sort of 
programmers union </FONT>
<BR><FONT SIZE=2>uprising?&nbsp; 'The users are access their own data without 
going through </FONT>
<BR><FONT SIZE=2>us!&nbsp; Wait, lets remove the easy maintainability of Query 
and put it into RPG!'</FONT>
</P>
<BR>
<BR>
<BR>
<BR>

<P><FONT SIZE=2>danielh@elp.rr.com on 02/25/2000 02:23:59 AM</FONT>
<BR><FONT SIZE=2>Please respond to RPG400-L@midrange.com@Internet</FONT>
<BR><FONT SIZE=2>To:&nbsp;&nbsp;&nbsp;&nbsp; 
RPG400-L@midrange.com@Internet</FONT>
<BR><FONT SIZE=2>cc:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>
<BR><FONT SIZE=2>Fax to: </FONT>
<BR><FONT SIZE=2>Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Query/400 
to RPG program</FONT>
</P>

<P><FONT SIZE=2>I just started working with RPG. This company lives on querys! 
They run</FONT>
<BR><FONT SIZE=2>around a 80 different ones a day. Is there a good tool that 
anyone would</FONT>
<BR><FONT SIZE=2>suggest that would convert querys to code. we run 3.7.</FONT>
</P>

<P><FONT SIZE=2>Thank you</FONT>
<BR><FONT SIZE=2>Dan</FONT>
</P>

<P><FONT SIZE=2>+---</FONT>
<BR><FONT SIZE=2>| This is the RPG/400 Mailing List!</FONT>
<BR><FONT SIZE=2>| To submit a new message, send your mail to 
RPG400-L@midrange.com.</FONT>
<BR><FONT SIZE=2>| To subscribe to this list send email to 
RPG400-L-SUB@midrange.com.</FONT>
<BR><FONT SIZE=2>| To unsubscribe from this list send email to 
RPG400-L-UNSUB@midrange.com.</FONT>
<BR><FONT SIZE=2>| Questions should be directed to the list owner/operator: 
david@midrange.com</FONT>
<BR><FONT SIZE=2>+---</FONT>
</P>
<BR>

<P><FONT SIZE=2>+---</FONT>
<BR><FONT SIZE=2>| This is the RPG/400 Mailing List!</FONT>
<BR><FONT SIZE=2>| To submit a new message, send your mail to 
RPG400-L@midrange.com.</FONT>
<BR><FONT SIZE=2>| To subscribe to this list send email to 
RPG400-L-SUB@midrange.com.</FONT>
<BR><FONT SIZE=2>| To unsubscribe from this list send email to 
RPG400-L-UNSUB@midrange.com.</FONT>
<BR><FONT SIZE=2>| Questions should be directed to the list owner/operator: 
david@midrange.com</FONT>
<BR><FONT SIZE=2>+---</FONT>
</P>

</BODY>
</HTML>