Re: 10 Char object names was...

["Justin C. Haase" <jchaase@xxxxxxxxx>]

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.