Re: 10 Char object names was...

Hey all you crazy cats, did some more thinking about this today.

From here: http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzamp/rzampfilesys.htm

It shows that the max number of objects in one library is
"approximately 360,000."
(this, by the way, is not even enough space for using just A-Z and no
numbers in 4 character positions, as 26*26*26*26 = 456,976)

Now for Windows, and specifically NTFS, file limitations on one volume
= 4,294,967,295 objects.

http://www.microsoft.com/technet/prodtechnol/windows2000serv/reskit/prork/prdf_fls_pxjh.mspx?mfr=true

So let's assume you could create 300,000 libraries (since a *LIB is an
object inside of QSYS) and inside those 300,000 libraries you put
360,000 objects... that's 108,000,000,000 (108 billion) objects on
the system.

That darn 10-character limit is really bothersome. Or am I reading
the maximums wrong?

jch

On Mon, Feb 25, 2008 at 3:25 PM, Bruce Vining <bvining@xxxxxxxxxxxxxxx> wrote:

I wasn't there so I can't say what Mike may or may not have said, but "You heard correctly" would be my guidance :-) A decidedly non-trivial, but quite do-able, effort.

Bruce Vining
http://www.brucevining.com/




Kurt Anderson <kjanderson@xxxxxxxxxxxxx> wrote:
I thought that at Devcon, last November, I heard Mike Smith say, during
his keynote speech, that 10+ character object names were on their list
of things they're looking to do. Maybe I misheard?

Kurt Anderson
Application Developer
Highsmith Inc

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Monday, February 25, 2008 12:56 PM
To: Midrange Systems Technical Discussion
Subject: Re: 10 Char object names was...

What is really odd is that a stored procedure doesn't even physically
reside in a library. It's not as if you can do a WRKOBJ MYLIB/*ALL
*STRPRC iNav has a way of seeing them via the database option but I am
sure that all it is displaying you is the contents of QSYS2/SYSPROCS
And, when I query that I'll be danged if I can see any space for 10
character object names.

So, in this case, is it not the 10 character limitation, but the fact
that you use spaces, slashes and other special characters? Would using
camel case, or some such thing, be acceptable for your Crystal names?

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Steve Richter"

Sent by: midrange-l-bounces@xxxxxxxxxxxx
02/25/2008 12:02 PM
Please respond to
Midrange Systems Technical Discussion



To
"Midrange Systems Technical Discussion"

cc

Subject
Re: 10 Char object names was...









On Mon, Feb 25, 2008 at 11:44 AM, wrote:

Whose ODBC client is that? And what happened when you asked them why

they

didn't show the long name?

crystal reports is an odbc client to the as400 server. The method I
use when writing CR reports against the data from the 400 ( V5R4 ) is
to write a stored procedure that returns a result set. This way all
the application specific logic of joining tables, selecting and
grouping is encapsulated in a program running on the server. Works
very well. Only problem is I cant assign an sql procedure name that
matches the long descriptive crystal reports report name (
"forecast/GP unit detail", "forecast/GP dollary summary", "rankings
category unit", "rankings category dollar", ... ) This limitation was
confirmed by IBM support.

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


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

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




Bruce
Bruce Vining Services
507-206-4178



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