• Subject: Re: just curious - Number of Parms
  • From: jpcarr@xxxxxxxxxxxx
  • Date: Fri, 28 Jul 2000 13:51:09 -0400


Again, I think you completely missed my point.   The number vs character
debate is irrelevant.

I don't care if it's in the fashion of "Customer ID"s  or whether zip codes
are numeric or character.
And yes,  I switched from YYMMDD as soon as date data types were available.
(As a matter of fact, we even did it on V3R1 with only RPGIII, and brought
them in character mode till
RPGIV was available)

My point was defining any field that would be passed as a parameter with
the same definition as it would be in a data base file, or the data
dictionary.

"If it's not going to be used for computational functions,  it's character"
Well good.  but that point had nothing to do with my post.

My post was for the people still using Parameters, Not procedures(Answering
"How many parms is the limit")

The technique of using externally defined data structures was a feeble/old
attempt to standardize
program parameter definitions external to the program and to correlate
those definitions with the data
dictionary.

Now then,  What do you see the future of PCML ?

http://www.as400.ibm.com/developer/education/abstracts/pcml_abs.html
Do a search on http://www.as400.ibm.com/   for PCML.

I can see that this thread will mutate for a week.
John Carr

-------------------------------------------
John,

Okay so we're MOSTLY on the same page. :)

Regarding your following comment, I would strongly argue that you don't
have a customer NUMBER. You have a customer ID! IMO, this is the same
sort of long-standing industry "mistake" that helped lead to the Y2K
(thought I'd NEVER type that letter combination again!) debacle.

With respect to Y2K, insisting on YYMMDD type formats for dates was one
of those habits the industry fell into and stayed in. We all know the
resulting costs. With respect to "Customer Numbers", I submit that it is
much better to move away from that nomenclature and begin referring to
the entities in the fashion of "Customer IDs". Then perhaps we can get
away from defining these entities in the database in a numeric format.
You never know when you're going to need a value that contains something
other than numeric-only data. Now that I've introduced the topic, let me
use a more demonstrative example - Zip Codes.

Limiting the conversation momentarily to the USA, Zip Codes often are
defined as numeric. In fact, in the not so distant past, they were
defined as 5 digits in length. Of course, 9 is a more appropriate length
now. But, all of a sudden your company decides to do business outside of
the USA -- hmm, now we need alpha characters, too! And, there's nothing
that prevents USA standards to change to allow alpha characters.

This having been said, I submit that it's best to leave numeric
definitions to those entities that indicate quantitative data and avoid
the type of problems mentioned.

Thoughts?

Gary Guthrie
REAL Solutions Technical Support
NEWS/400 Technical Editor



> To me the bigger sin(being a data base bigot) is
> using a 15,5 parameter variable for (say) a customer number or invoice
> number when my data dictionary defines it as 7,0.    I want that
attribute
> of the DB customer entity to cascade everywhere I used customer number.



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.