Re: SQL query to know lines of code for all the programs and it's associated modules

Hi,

Thanks for these inputs.

For This I mean count of the lines of all the source members which are
compiled successfully and whose objects are also present with respect to
their source code.



I tried both DSPFD and DSPFFD both to an OUTFILE() but could not find any
such field in their outfiles which shows the total number of lines of code
for a particular source member.


For comments i did not want to make it much complicated ,I simply meant
commented lines irrespective of source member 's attribute type and either
in continuation or in multi lines and for blank lines
yes of course they are also counted even if they are blanks because blank
line also occupies a sequence number if we browse a particular member's
source code.However there could also be such source members for which
sequence numbers are shown in points like '1234.56' for such I am also not
sure how to count them in a complete number.

As far as right side comments are concerned if they are not commenting on
the actual line of code and are there just for describing the code or for
adding some tags etc. they would not be considered as commented lines.

But is it possible to include all of IBM's
proprietary system programs as well here?


This statistics is required to have a complete overview of how complex a
particular IBM i environment is?



Thanks a lot...

On Tue, 27 Jun 2023 at 23:10, Peter Dow <petercdow@xxxxxxxxx> wrote:

Just to add to Buck's list, does 'all the programs' include all of IBM's
proprietary system programs?

Are you planning on comparing this to all the same statistics from a
Windows sytem? a Linux system?

On 6/27/2023 10:01 AM, Buck Calabro wrote:

On 6/27/2023 12:15 PM, tim ken wrote:

Is there any SQL query which could provide lines of code used inside
all
the programs and all the associated modules used in the entire IBM i
system?

What do these mean:
'provide lines of code'
'all the programs'
'all the associated modules'
'entire IBM i system'

The reasons that clarifications are needed:
Does 'provide' mean a count, a copy of each actual line, something else?
Does 'line of code' refer to source lines, compiled MI lines,
something else?
If source lines, how does one account for continuations, are they a
single line of code, multiple, something else?

It is very difficult to understand what value any of this might
provide; what question is being answered, what decisions will be made
based upon this information, what the actual business problem is.

Also in this SQL query can we know how many lines are commented and how
many lines are actual program and module code separately in different
columns against each program and it's associated module name ?

Again, clarification is needed. How do you want to treat right-hand
comments? As a commented line, as a line of code, something else?
Remember that a comment varies according to the programming language.
A comment in Cobol is different to a comment in RPG 3, RPG IV, CL,
Python, DDS... Our hypothetical SQL statement would need quite a few
CASE statements to pick these out. What about blank lines?
Continuations of comment lines?

If you are after a rough idea of the size of your application code, I
would use DSPFD to an OUTFILE() and query the number of
members/records in the source files found there.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.