RE: Request for CL, DDS, SQL RPG enhancements

Hi Jim,

While the example you give justifies the use of CL with no doubt, I still
have some arguments to write some CLs (please don't get me wrong in that you
should do everything in CL) in RPG.

I once had a utility to list a complete database (files, fields, keys,
relations, ...) which was completely written in CL and took at that time
(quite some years ago) about 6 hours of the night processing to complete.

At a day when I was learning API's, I decided to rewrite the complete stuff
in RPG and when it was finally completed, the job only took about ... 25
minutes anymore !  Not only the speed is sometimes an advantage, but I know
of CL programs based on spool and outfiles that had to be recompiled due to
changes over various releases (and even languages).

You also mention... 'I have to have 2 CL' just like this is something dirty,
or you should feel guilty about.  This is modular design and is a good
point, it is not something bad.

Kind regards,
Paul

-----Original Message-----
From: Jim Langston [mailto:jlangston@celsinc.com]
Sent: 24 April, 2002 22:40
To: 'rpg400-l@midrange.com'
Subject: RE: Request for CL, DDS, SQL RPG enhancements


Why use 2 files in a CL when you could do that in RPG?

Here's an example:
I have an application that retrieves the list of files in a library, and
then does some quick math to see if I need to reorganize the physical file
member.

I don't want to do all libraries on my system, but only certain ones.  So I
put the list of libraries I want to reorganize into a physical file.

If I could open up more than one file in a CL it would be a simple CL
program.

Read from the list of libraries.
For each library DSPFD into a file, then read through the file and check for
members to be reorganized.

As it is right now, I have to have 2 CLs.  One to read the list of
libraries, one to read the list of members.

In no way would I think this better written in RPG.  These are fairly simple
CL commands, DSPFD, RGZPFM, etc.. that are being called that are very easy,
quick, and explicit in CL.  In RPG I would have to set up system calls,
etc... and it would be much harder to maintain and understand what was
actually going on.  I'm simply trying to use the appropriate tool for the
job, in this case CL.

Regards,

Jim Langston

------------------------------------------------------------------------------
Notice: This e-mail message, together with any attachments, contains 
information of Merck & Co., Inc. (Whitehouse Station, New Jersey, USA) that may 
be confidential, proprietary copyrighted and/or legally privileged, and is 
intended solely for the use of the individual or entity named on this message. 
If you are not the intended recipient, and have received this message in error, 
please immediately return this by e-mail and then delete it.

==============================================================================